run external program

run external program

Post by Anith Se » Tue, 13 Aug 2002 05:51:55



Quote:>> exec master.dbo.xp_cmdshell 'C:\winnt\notepad.exe'<<

This may not work as expected, mostly. Any processes which
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.

--
- Anith