Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

save change to the following items

Is it possible to configure SQL Server Management Studio (SSMS). so that the dialog box shown above does not appear when I close an unsaved query window?

share|improve this question
+1 annoying pop up – Aki Apr 18 '14 at 15:48
it's no correct. i know there is no setting! so connect item was raised link have error! – Massoud Afrashteh May 18 '14 at 7:05

In SQL Server 2016 this is apparently coming.

The pre-release docs says

New option to skip prompt to save T-SQL files We have added a new option under "Tools|Options|Query Execution|SQL Server" to control if a prompt is shown for unsaved T-SQL files.

enter image description here

In previous versions there is no setting to suppress this warning.

A connect item was raised about this by Erland Sommarskog and closed as won't fix with the explanation.

Hello Erland -

I did a review with some of the other product teams and to stay consistent within our guidelines we're not going to be able to do this. Excel, Visual Studio and other products won't let you save with changed content, so we have to pop the message.


Buck Woody, SQL Server Program Manager

The Connect page is returning an error at the moment so here is a cached copy of it.

share|improve this answer
Another attempt to get this solved is at… – Twinkles May 15 '14 at 15:37

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.