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

SSMS not responding; SQL Prompt is root cause. Why?

Every once in a while, when I am connected to certain SQL Server instances, the SSMS will go into 'Not Responding' mode.

This seems to happen when I am writing T-SQL using temp tables. The more temp tables created, the slower and less responsive the query becomes until I cannot edit it at all and have to kill SSMS.

I noticed the other day when I restart SSMS, SQL Prompt takes a very long time doing whatever it does when opening a query window. So I turned it off on one of the troublesome queries and presto! Problem solved. So it was SQL Prompt causing SSMS to become unresponsive.

Any ideas why? I have grown dependent on SQL Prompt and do not want to turn it off.
randyv
0

Comments

2 comments

Sort by
  • Paul Stephenson
    Hi Randy,

    This sounds very similar to the problems reported by mikeh on this forum.

    Which version of SQL Prompt are you using? SQL Prompt 5.1.8 was released on 2 August and addressed some of these issues. If you're not on this version already, could you give it a try?

    Regards,
    Paul
    Paul Stephenson
    0
  • randyv
    downloading now; thanks for the tip. :wink:
    randyv
    0

Add comment

Please sign in to leave a comment.