How can we help you today? How can we help you today?

Formatting bug with NO_INFOMSGS

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
rjpaulsen
0

Comments

2 comments

Sort by
  • 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
    0
  • 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
    Ali D
    0

Add comment

Please sign in to leave a comment.