It works when i execute my C programs.
--------------------------------------
exec master..xp_cmdshell "c:MyCExeConvert.exe"
This is Suppose to work. But for some reason it is running for ever.
--------------------------------------------------------------------
exec master..xp_cmdshell "crogra~1Micros~1OfficeWinword.exe"
or
exec master..xp_cmdshell "start amex3.doc"
-MAK
------------
Boris at 3/25/01 7:11:12 AM
For every one
Visual basic permit use shell command to execute any file
shell "crograms Filesword.exe
How could I make it in SQLServer 7.0
1) The application will run at the SERVER and not be visible.
2) It runs with server admin priviledges if an 'sa' in executing it, as 'SQLAgentCmdExec' if a non-'sa' user.
3) Do not ask it to print unless you have logged in as the 'SQL Service' (or 'SQLAgentCmdExec' user and configured printing for THAT user.
4) Running something like WORD is a bit pointless 'cause you can't see or control it.