Prompt To Save unsaved T-SQL query windows on close

WILLIAM BEHNING 36 Reputation points
2021-10-01T20:57:45.25+00:00

I am using SSMS V 18.7.
I am continually prompted to save changes to query windows when closing them, even though "Prompt To Save unsaved T-SQL query windows on close" is unchecked.

In fact, the "Prompt To Sqve unsaved T-SQL query windows on close" option seems to have no effect on anything.

How do I stop this behavior?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,267 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 105.9K Reputation points MVP
    2021-10-01T21:20:55.827+00:00

    I also have it unchecked. Since I mainly use SSMS for scratch windows (I edit SQL code in a different editor), I have little reason to be nagged about saving windows.

    But as you say, SSMS till often asks about saving unchanged windows. It does not seem consistent, though. For instance, right now, I had two query windows, both changed. I tried to close SSMS, and one window was closed, but I was nagged about the other.

    Ideally, I would like to get questions for windows that actually are tied to a file, and not just a generic SqlQueryn window.

    I guess I have given up that Microsoft will ever get this.

    1 person found this answer helpful.

  2. CathyJi-MSFT 21,121 Reputation points Microsoft Vendor
    2021-10-04T02:23:40.507+00:00

    Hi @WILLIAM BEHNING ,

    I test this in SSMS 18.8 and SSMS 18.9.1 in my environment. It works well. SSMS will not prompted to save changes to query windows when closing them, if "Prompt To Save unsaved T-SQL query windows on close" is unchecked in SSMS 18.8 or SSMS 18.9.1.

    Suggest you using a newer version SSMS, you can download it from this link.


    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.