To turn off the sometimes annoying message when you try to close SQL Server Management Studio with unsaved queries check out the option below…
You might also be interested in...
How to set scripting defaults in SQL Server Management StudioIn SQL Server Management Studio when you use the DB (right click) -> Tasks -> Generate Scripts option to export a DBs schema you’ll see that by default SSMS does...
How to show query window on startup in SQL Server Management Studio
A lot of time the first thing we do when we startup SQL Server Management Studio is to open a new query window. To save time we can have SSMS...
Use Registered Servers in SQL Server Management Studio for easy access to multiple DB servers
Switching between multiple DB servers in SQL Server Management Studio can be a pain. Registered Servers in SQL Server Management Studio helps by allowing us to store servers for access...
Showing line numbers in SQL Server Management Studio
Line numbers are not displayed by default in SQL Server Management Studio but… they are super helpful if you’re sharing your screen and talking through TSQL with colleagues. Turning them...
How to select more than 1000 rows by default in SQL Server Management Studio
In SQL Server Management Studio when we right-click a table we have an option to ‘Select Top 1000 Rows’ and ‘Edit Top 200 Rows’ as shown below… SQL Server Management...
