SQLPrompt format crashes crashes ssms

• 
  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.

  Manfred.Castro March 05, 2013 15:44

  - 0 +
• 
  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.

  gokhanvarol March 05, 2013 15:49

  - 0 +
• 
  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.

  PDinCA March 05, 2013 17:04

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

  Manfred.Castro March 05, 2013 18:35

  - 0 +

Add comment

Please sign in to leave a comment.