>>>>>I have this line in a script:
>>>>>
>>>>>

>>>>>EXEC MASTER.dbo.xp_cmdshell @Merge_Script, no_output
>>>>>

>>>>>
>>>>>When there is only one time for it to execute, it works great. It seems that if it needs to execute multiple times, it hangs up, or at least "Executing Query" does. It's hard to tell where it's stuck as there is no debugger in SQL Server MS. Is there something I can do to make sure it's a clean run for the exe? Sort of like CLEAR or RELEASE in Foxpro?
>>>>>
>>>>>UPDATE: Or, do I need to pause or something to let the EXE finish maybe? It runs fast though.
>>>>
>>>>Just a thought - how about have xp_cmdshell light off your exe using the START command. START can light off a program in a seperate shell (fire and forget) or it can wait for the program to finish depending on parameters.
>>>
>>>I can't find START as a command. Can you direct me to a link or give an example of the syntax.
>>
>>Open a command prompt on a workstation or server.
>>
>>type START /? to get help on it.
>
>Actually, DOS returns an error when I try it manually saying, "Windows cannot find 'start'. Blah, blah, blah... I tried just typing in Start and start /? etc.
>
>This is on Windows Server 2003.

?? I'm 99+% sure that is available on Server 2003.