This may not work as expected, mostly. Any processes whichQuote:>> exec master.dbo.xp_cmdshell 'C:\winnt\notepad.exe'<<
spawns threads which are not under the SQL Server Service
may not work reliably using xp_cmdShell. This is applicable
for any applications with a visible or interactive User
Interface. And hence the application may appear 'hanging'.
A better option would be to check out the sp_OA* procedures
so that out of process automation can be done.