Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 play wav on complete

Author  Topic 

jtwork
Yak Posting Veteran

82 Posts

Posted - 2008-09-01 : 13:11:02
i know there is a option in QA to play a wav after each set of results complete but can i set a sp to play a wav and exec it at the end of my code as i see fit?

I have tried but this doesnt work
exec master..xp_cmdshell 'C:\WINDOWS\Media\Windows XP Ringin.wav'

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2008-09-01 : 15:32:07
procs run on the server, not the client.

at the most what would happen is there'd be a beep on the server, which only someone in the server room would hear (assuming the server even has a speaker)


elsasoft.org
Go to Top of Page
   

- Advertisement -