SSMS Crash When Modifying Query

Provides intelligent code completion for SQL Server editors.

SSMS Crash When Modifying Query

Postby bianchi1 » Fri May 30, 2014 7:53 pm

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

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


Modify to:

Code: Select all
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.
bianchi1
 
Posts: 3
Joined: Fri May 30, 2014 7:46 pm

Postby David Priddle » Mon Jun 02, 2014 9:49 am

Hi bianchi1,

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

Best regards,

David
David Priddle
 
Posts: 113
Joined: Tue Jan 28, 2014 10:22 am
Location: Red Gate Software, Cambridge

Postby bianchi1 » Mon Jun 02, 2014 3:38 pm

I'm using SQL Prompt 6.3.0.344
bianchi1
 
Posts: 3
Joined: Fri May 30, 2014 7:46 pm

Postby David Priddle » Mon Jun 02, 2014 3:46 pm

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/vi ... hp?t=20263

Please let me know if this fixes it for you.

Best regards,

David
David Priddle
 
Posts: 113
Joined: Tue Jan 28, 2014 10:22 am
Location: Red Gate Software, Cambridge

Postby bianchi1 » Mon Jun 02, 2014 5:19 pm

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

Michael
bianchi1
 
Posts: 3
Joined: Fri May 30, 2014 7:46 pm

Postby David Priddle » Tue Jun 03, 2014 7:42 am

Hi Michael,

Fantastic! Thanks for letting us know!

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

Best regards,

David
David Priddle
 
Posts: 113
Joined: Tue Jan 28, 2014 10:22 am
Location: Red Gate Software, Cambridge


Return to SQL Prompt

Who is online

Users browsing this forum: No registered users and 1 guest