CODEWITHSUNDEEP
sql-serverssms
Emma
Emma

Reputation: 562

SQL Management Studio Hangs when adding table into view or query

Within a view or the graphical design of a query if I right click - then add table, instead of seeing the table list SQL management studio hangs and says "not responding".

Version is SQL Server 2016. Running SQL Server Management 13.0.15000.23

Any thoughts as to what may cause this ?

Upvotes: 0

Views: 911

Answers (1)

Dan Guzman
Dan Guzman

Reputation: 46320

These symptoms could be due to an uncommitted transaction involving DDL. Open a separate instance of SSMS and run sp_who2 to see if you observe blocking.

A word of warning - the SSMS graphical query design editor has a number of bugs. I would avoid using it.

Upvotes: 1

Related Questions