SQLPrompt format crashes crashes ssms

gokhanvarol@gmail.com

Formatting the snipplet with sqlprompt crashes ssms. Please advise



CREATE TABLE #ChangedKeysChildren
(
CntyCd CHAR(5) NULL
, PclId VARCHAR(45) NULL
, PclSeqNbr TINYINT NULL
,NameSeq tinyint NULL
,BEFORE_FullName] varchar(60) NULL
,AFTER_FullName] varchar(60) NULL
)

Manfred.Castro

Your issue appears to be caused by the un enclosed square brackets in your script.
if you remove the un enclosed square brackets

CREATE TABLE #ChangedKeysChildren
(
CntyCd CHAR(5) NULL
, PclId VARCHAR(45) NULL
, PclSeqNbr TINYINT NULL
,NameSeq tinyint NULL
,BEFORE_FullName varchar(60) NULL
,AFTER_FullName varchar(60) NULL
)

or close the square brackets

CREATE TABLE #ChangedKeysChildren
(
CntyCd CHAR(5) NULL
, PclId VARCHAR(45) NULL
, PclSeqNbr TINYINT NULL
,NameSeq tinyint NULL
,[BEFORE_FullName] varchar(60) NULL
,[AFTER_FullName] varchar(60) NULL
)

Format SQL works as expected.

gokhanvarol@gmail.com

I know how to make it work by removing the bracket, but in any case sql prompt should not crash and take ssms down with it.
This piece of code was part of a longer (over 4500 lines) stored procedure which kept crashing on format, eventually I spent the time and find out what's crashing sqlprompt and posted here.

PDinCA

SSMS2012 simply spins its wheels - the Cancel button in the reformat dialog is inoperative. Killing SSMS is the only solution.

I agree with the original poster - SQL Prompt ==> format SQL should NEVER kill SSMS of any vintage.

Manfred.Castro

We have this logged in our bug tracking system under the internal reference number SP-4639