SQL Server with Mr. Denny

Feb 24 2016   7:00PM GMT

How to make SSMS beep when a query is done?

Denny Cherry Denny Cherry Profile: Denny Cherry

SQL Server
SQL Server Management Studio

The other day I’m sitting at my computer, and this comes across Twitter. ssms

Well the good news is that there’s no need to develop anything. SQL Server Management Studio can already do this for you. Simply open SSMS, then click on Tools > Options. In the Options window open Query Results > SQL Server and check the check box next to “Play the Windows default been when a query batch completes” and click OK.


The next time you run a query (you might need to close all your query windows or restart SSMS, you usually do with this sort of change in SSMS) it’ll beep when the query is done.

Personally I’ve actually used this as an alarm clock when doing long running overnight deployments so that I’d get woken up when the script was done so I could start the next step. It’s also handy when you want to leave the room / your desk while queries are running.

Don’t forget to turn up the volume when leaving and turn it back down when you are done.

If you were wondering how long this feature has been in SSMS, I was first using it in Enterprise Manager, in SQL 2000.


2  Comments on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.
  • JenMcCown
    Good post. BUT WE STILL NEED THE TOGGLE SHORTCUT! So I'm holding out hope for someone to develop that.
    10 pointsBadges:
  • Denny Cherry
    Sadly I don't see any way to do that by just using SSMS. You might be able to get it added to SSMS tool pack.
    67,555 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: