What are the challenges you face when working across database platforms? Take the survey

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

randyvrandyv Posts: 166
edited August 4, 2011 7:49AM in SQL Prompt Previous Versions
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.
What we do in life echoes in eternity <><
Randy Volters


Sign In or Register to comment.