Red Gate forums :: View topic - SSMS Crash When Modifying Query
Return to www.red-gate.com RSS Feed Available

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

SSMS Crash When Modifying Query

Search in SQL Prompt 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
bianchi1



Joined: 30 May 2014
Posts: 3

PostPosted: Fri May 30, 2014 7:53 pm    Post subject: SSMS Crash When Modifying Query Reply with quote

When I start to modify the query below, SSMS crashes. When I Disable code suggestions, SSMS no longer crashes.

Code:
SELECT FCSN, SUBSTRING(FCSN, CHARINDEX('.', FCSN, 0) + 1, LEN(FCSN))
FROM ssis.FailedTools


Modify to:

Code:
UPDATE SUBSTRING(FCSN, CHARINDEX('.', FCSN, 0) + 1, LEN(FCSN))
FROM ssis.FailedTools


SSMS crashes after I type UPDATE and press the space bar and I don't get a chance to make the other modifications to the query to make it a valid update statement.

The workaround is to not change the original select query and just write the update query separately.
Back to top
View user's profile Send private message
David Priddle



Joined: 28 Jan 2014
Posts: 36
Location: Red Gate Software, Cambridge

PostPosted: Mon Jun 02, 2014 9:49 am    Post subject: Reply with quote

Hi bianchi1,

Unfortunately we can't recreate this issue on our development machines. Which version of Prompt are you running?

Best regards,

David
Back to top
View user's profile Send private message Send e-mail
bianchi1



Joined: 30 May 2014
Posts: 3

PostPosted: Mon Jun 02, 2014 3:38 pm    Post subject: Reply with quote

I'm using SQL Prompt 6.3.0.344
Back to top
View user's profile Send private message
David Priddle



Joined: 28 Jan 2014
Posts: 36
Location: Red Gate Software, Cambridge

PostPosted: Mon Jun 02, 2014 3:46 pm    Post subject: Reply with quote

Hi bianchi1,

Would it be possible to upgrade to 6.3.0.345?

We fixed a similar issue in that version, it may or may not be related:

http://www.red-gate.com/MessageBoard/viewtopic.php?t=20263

Please let me know if this fixes it for you.

Best regards,

David
Back to top
View user's profile Send private message Send e-mail
bianchi1



Joined: 30 May 2014
Posts: 3

PostPosted: Mon Jun 02, 2014 5:19 pm    Post subject: Reply with quote

Thank you. I've updated to 6.3.0.345 and the issue is resolved.

Michael
Back to top
View user's profile Send private message
David Priddle



Joined: 28 Jan 2014
Posts: 36
Location: Red Gate Software, Cambridge

PostPosted: Tue Jun 03, 2014 7:42 am    Post subject: Reply with quote

Hi Michael,

Fantastic! Thanks for letting us know!

If you have any more issues, please don't hesitate to tell us.

Best regards,

David
Back to top
View user's profile Send private message Send e-mail
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