Autosave open tabs

The first improvement is the option to choose whether SSMS should prompt to save unsaved tabs when you decide to close SSMS. This is a simple change, but if you use SSMS to run many ad hoc queries and do not want to constantly close out and save each tab, this is now an option. The default is for SSMS to prompt when closing a window, but by unchecking the checkbox marked as shown in the following screenshot you can force SSMS to silently close these windows:

Options window in SQL Server Management Studio—prompt to save unsaved work

Get SQL Server 2017 Developer's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.