Run external file

[Boris]

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

Sincerely.
Fain Boris.

[MAK]

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

Sincerely.
Fain Boris.

[Dale Shaw]

Hi

Remember:

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&#39 user and configured printing for THAT user.
4) Running something like WORD is a bit pointless 'cause you can't see or control it.

Dale Shaw
Auckland, New Zealand