What are the challenges you face when working across database platforms? Take the survey
Options

Formatting bug with NO_INFOMSGS

rjpaulsenrjpaulsen Posts: 50 New member
edited July 26, 2016 5:07AM in SQL Prompt
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

Comments

Sign In or Register to comment.