Disable “save” prompt in SQL Server Management Stu

问题:

I just want to close all my query windows without saving, but SSMS always prompts me and I can't find the turn-off switch. Any ideas?

回答1:

There isn't an off switch - currently!

Microsoft are reluctant to add one, but you can perhaps join the growing throng of people who are trying to persuade them:

prompting-for-modified-windows-when-closing-ssms-should-be-optional

回答2:

In SQL Server Management Studio 2016 you can unchecked the Prompt to save unsaved T-SQL query windows on close:

The option is under the Query Execution\SQL Server\General sub-menu.

Once unchecked, the annoying prompt for saving is disabled.

回答3:

The feature doesn't exist, but you can vote for it here.