Red Gate forums :: View topic - SQLPrompt format crashes crashes ssms
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

SQLPrompt format crashes crashes ssms

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
gokhanvarol@gmail.com



Joined: 03 Mar 2013
Posts: 7

PostPosted: Mon Mar 04, 2013 8:24 pm    Post subject: SQLPrompt format crashes crashes ssms Reply with quote

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
)
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Tue Mar 05, 2013 9:44 pm    Post subject: Reply with quote

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
Product Support
Red Gate Software
Back to top
View user's profile Send private message
gokhanvarol@gmail.com



Joined: 03 Mar 2013
Posts: 7

PostPosted: Tue Mar 05, 2013 9:49 pm    Post subject: The crash Reply with quote

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.
Back to top
View user's profile Send private message
PDinCA



Joined: 25 Jul 2005
Posts: 512
Location: Costa Mesa, CA, USA

PostPosted: Tue Mar 05, 2013 11:04 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Wed Mar 06, 2013 12:35 am    Post subject: Reply with quote

We have this logged in our bug tracking system under the internal reference number SP-4639
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group