Answer the question
In order to leave comments, you need to log in
Is there a setting in Microsoft SQL SMS to instantly read changes to a DBMS instance?
After creating any objects (tables, views, adding/deleting columns, etc.) in the database, these objects are considered by the Microsoft SQL Server Management Studio editor as non-existent and it marks any queries with their participation in red with a corresponding error.
Queries involving these new objects work, but when debugging large queries, you constantly have to restart Microsoft SQL Server Management Studio, which is wildly inconvenient. A quick google search turned up no results.
Maybe there is a corresponding setting in Microsoft SQL Server Management Studio responsible for re-caching the list of actual database objects?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question