In object explorer, I can normally right click on 'Views' to create 'new view'.
However, in 1 DB, SSMS simply hangs when I r-click on 'views'.
Really no sure where to begin on resolving this.
Only thought I had, was that there are 110,000 tables in the DB, and possibly there is a call to go off and fetch this list (the graphical UI for a new view does have a dialogue listing tables to select from).
Anyone had this before, or ideas on how to get around ?
Thanks
Microsoft SQL Server Management Studio
14.0.17289.0