SSMS Crash When Modifying Query

bianchi1

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.

David Priddle

Hi bianchi1,

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

Best regards,

David

bianchi1

I'm using SQL Prompt 6.3.0.344

David Priddle

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

bianchi1

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

Michael

David Priddle

Hi Michael,

Fantastic! Thanks for letting us know!

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

Best regards,

David