Formatting bug with NO_INFOMSGS
rjpaulsen
Posts: 50 New member
With the current version of SQL Prompt I have the following options selected:
Add/Remove square brackets [Checked]
Add brackets to all identifiers [Selected]
Formatting the following valid statement:
results in the following invalid statement:
Sql Prompt 7.2.4.291
Microsoft SQL Server 2014 (SP1-CU7) (KB3162659) - 12.0.4459.0 (X64) May 27 2016 15:33:17 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.3 <X64> (Build 10586: )
Microsoft SQL Server Management Studio 13.0.15500.91
Add/Remove square brackets [Checked]
Add brackets to all identifiers [Selected]
Formatting the following valid statement:
DBCC CHECKIDENT ('dbo.Test', RESEED, 100) WITH NO_INFOMSGS;
results in the following invalid statement:
DBCC CHECKIDENT ('dbo.Test', RESEED, 100) WITH [NO_INFOMSGS];
Sql Prompt 7.2.4.291
Microsoft SQL Server 2014 (SP1-CU7) (KB3162659) - 12.0.4459.0 (X64) May 27 2016 15:33:17 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.3 <X64> (Build 10586: )
Microsoft SQL Server Management Studio 13.0.15500.91
Comments
Thanks for reporting this. I've been able to reproduce the issue and we'll start looking into it.
Ali
We’ve now got a private build that should fix this issue. You can download it here.
Please let me know if it behaves as you'd expect.
Thanks
Ali