SSMS Tables (expanding...) when trying to refresh

Viewed 166

I have sql server management studio (SSMS) v18.9.1 and visual studio 2022 v17.1.1.

I'm using EF Migrations (dotnet 6) and after making changes to the pocos, I run add-migration followed by update-database from the package manager console window in visual studio.

If I try to refresh SSMS by right-clicking\Tables\Refresh I'm presented with SSMS Tables (expanding...) message. The table do eventually appear but this can take up to 10 minutes.

My colleague is experiencing the same behaviour on his laptop.

Any ideas how to fix?

1 Answers

if you are accessing your local database it will be fast. if you accessing azure or cloud database it will take time based on load. it will not occur often.

Related