Home Forums SQL Server 2005 T-SQL (SS2K5) master.dbo.xp_cmdshell 'C:\WINDOWS\system32\notepad.exe' RE: master.dbo.xp_cmdshell 'C:\WINDOWS\system32\notepad.exe'

  • hello,

    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.

    Fabienne