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.