As a DBA/Developer, you must have seen below screen lot of times and most of the time you must have hit No. I know it is one of those moments when you want to leave from work and those annoying popup just stops you for that couple of seconds that you don’t want to waste. In reality, I inadvertently press the space bar and it asks for a location to save. Let us see an interesting blog post about SSMS 2016.
I really hate this when I am working with a client and I run queries on an adhoc basis and I don’t want to save them. I remember that this feedback was given to Microsoft via connect Permit nameless windows that do not need saving in SSMS – by Erland Sommarskog and I am happy to see that they have heard this and incorporated this in the product.
So now, in SQL Server 2016 Management Studio, we can choose to change this setting. Which means that we have option to skip prompt to save T-SQL files. As shown below, we can see a new option under “Tools > Options > Query Execution > SQL Server” to control if a prompt is shown for unsaved T-SQL files.
Once we uncheck the checkbox mentioned above, there would be no prompt to save the file.
Did you know that SQL Server Management Studio is a free standalone installer now?
Download SQL Server Management Studio (SSMS)
Is there any new trick you know in SSMS 2016. Please share via comments. Do you like this neat little addition to SQL Server Management Studio?
Reference: Pinal Dave (https://blog.sqlauthority.com)
11 Comments. Leave new
But it is a dangerous setting. We can accidentally loose our work.
Very true, you need to use this feature if you prefer to not have the prompt. It is all how you want to use it.
It’s a great feature to use when combined with a tab history saver like Redgate or ApexSQL’s
Fair Point!
The standalone SSMS installer is just getting bigger and bigger these days.
SQL Server 2017. Unchecked the option but it still prompts. Ideas?
I have the same issue, even after restarting SSMS. Very strange!
It doesn’t apply to closing individual query windows (annoyingly). It only applies to closing SSMS while there are unsaved queries still present. If you close an individual unsaved query window, it will still prompt you.
This checkbox no longer works. It doesn’t do anything.
It works if you are closing a query window. If you have scripted an object it will still prompt you to save. i.e Modify a stored procedure.
It still prompts me too, in v18.5.1 I hate it!