So on twitter this morning a question was asked about attaching a sound file to SQL Server Management Studio to play a sound when a query completes.
So I decided to poke around the managment studio a bit and under Tools -> Options if you select Query Results there is a checkbox for playing the default beep when a query batch completes.
Who knew? I didn’t LOL
Granted this doesn’t give you the option to attach your own sound… but I imagine there are some smart folks out there that would be able to “hack-fu” something if needed hehehe 
Enjoy!!
[...] I read a post from my good friend Colin Stasiuk (aka @BenchmarkIT) where he talked about making SSMS beep when a query has [...]
Colin, thanks for posting this. I was digging too deeply when trying to find this setting earlier today.
Just change the windows default beep to whatever you want…
Control Panel>Sounds> Scroll down to Default Beep…. Browse for your WAV file..
BUT… you have to make sure that you want to have that sound for EVERY thing that uses the beep.