>I think the problem is in the spaces in the dir name. Try
EXEC xp_cmdshell '"C:\Program Files\CU Solutions\Car2\car2.exe"'
Thanks - I just tried that - the 'query' ran for a minute and then I stopped it - the program did not start. The exe in question is a VB exe.
When I go Start/Run and then type in "C:\Program Files\CU Solutions\Car2\car2.exe" - the program starts right away. There must be something missing in the SQL query code.
>
>< snip >
>>>>
>>>>USE Master
>>>>EXEC xp_cmdshell 'C:\AFX\DayEndService.exe' NO_OUTPUT
>>>
>>>You can run it from any database not just master.
>>
>>I just tried running this from the Query Analyzer:
>>
>>USE Master
>>EXEC xp_cmdshell 'C:\Program Files\CU Solutions\Car2\car2.exe'
>>
>>It returned:
>>
>>output ---------------------------------------------------
>>'C:\Program' is not recognized as an internal or external command,
>>operable program or batch file.
>>NULL
>>
>>(3 row(s) affected)
>>
>>*****************
>>
>>What am I missing?
Al Williams
Anola MB, CANADA