mark.rozario (1/28/2008)
well nothing gets printed out, because of that error in syntax.
If you double click the error message (in management studio) it will take you to the line of the error.
What I was suggesting was adding print @cmd just before the exec master..xp_cmdshell so that you can see exactly what you're exec-ing. Often helps to debug.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability