Posts

Showing posts from November, 2019

SSMS Becomes "Not Responding" and Shuts Automatically When Clicking "Design" on SQL Database's View

Image
I faced a problem from SSMS which doesn't show any error when I wanted to see the "Design" of a SQL Database's View. There is a similar post  here . I would say similar because my problem was a bit different than that post as my SSMS didn't even display any error, it just became "Not Responding" and closed itself automatically. There was an AccessViolationException when I looked into the event of that SQL application, such as the following (also similar stacktrace): The solution is ... the same with the solution in the post above :) My version of SSMS (2016) is older than the SQL Server itself (2017). Another good reference which I referred for getting the version information is this:  https://buildnumbers.wordpress.com/sqlserver/