Ever get this message in SQL Server Management Studio (SSMS) when you’re certain that the object exists? Then it proves you right when you go ahead and execute the command anyway? Why does SSMS complain that the object doesn’t exist when it obviously does? This happens because SSMS does not monitor database changes made in … Continue reading How to Get SSMS to Recognize an Existing Object (Refreshing Lists in SSMS)
Tag Archives: Object Explorer
How to select multiple SQL Server database objects in SSMS
My students sometimes ask me how they can script multiple tables, views, or other database objects at once without having to do it one at a time. They correctly point out that you can select only one table at a time in SQL Server Management Studio’s Object Explorer, only one view at a time, one … Continue reading How to select multiple SQL Server database objects in SSMS