Visual Studio 2022 hangs when creating sql table in SQL Server Object Explorer

Emirhan Türker 1 Reputation point
2022-05-29T15:07:42.767+00:00

I'm using the localdb 2019 that bundled with visual studio 2022. I was using Visual Studio 2019 but because of this problem I switched to 2022. But this problem still exists.

206501-image.png

Developer technologies Visual Studio Other
SQL Server Other
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
    2022-05-29T15:41:24.06+00:00

    Have you checked for blocking? Run sp_who2, and check the Blk column. If you see a number in this column, this means that this process is blocking the spid on the column.

    If you cannot see any trace of the Visual Studio thing in SQL Server, I guess it is an issue in Visual Studio, in which case you should add a tag for visual-studio.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.