Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

SSMS Crash When Modifying Query

bianchi1bianchi1 Posts: 4
edited June 3, 2014 2:42AM in SQL Prompt
When I start to modify the query below, SSMS crashes. When I Disable code suggestions, SSMS no longer crashes.
SELECT FCSN, SUBSTRING(FCSN, CHARINDEX('.', FCSN, 0) + 1, LEN(FCSN))
FROM ssis.FailedTools

Modify to:
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.

Comments

Sign In or Register to comment.