Formatting bug with NO_INFOMSGS

rjpaulsen

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:

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

Ali D

Hi rjpaulsen

Thanks for reporting this. I've been able to reproduce the issue and we'll start looking into it.

Ali

Ali D

Hi

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