I was using DTS in SQL2000 tu run aplications form SQLServer (Iexporer.exe, for example).
How can I do the same thing (without DTS) with SQL 2008 ? When I try that on sql2008 :
EXEC xp_cmdshell 'Echo Hello' : it works
EXEC xp_cmdshell 'c:\progra~1\intern~1\iexplore.exe' : it keeps running, doesn't open IE
I have to restart sqlserver to end the running of xp_cmdshell...
What is the problem ? and the solution ... ?
Thanks for you help.