How can we help you today? How can we help you today?

SSMS Crash When Modifying Query

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.
bianchi1
0

Comments

5 comments

Sort by
  • 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
    David Priddle
    0
  • bianchi1
    I'm using SQL Prompt 6.3.0.344
    bianchi1
    0
  • 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
    David Priddle
    0
  • bianchi1
    Thank you. I've updated to 6.3.0.345 and the issue is resolved.

    Michael
    bianchi1
    0
  • 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
    David Priddle
    0

Add comment

Please sign in to leave a comment.