Problems with xp_cmdshell

Two possibilities:

1) The batch file resides on a different machine from which SQL Server is running from.

2) The BAT file includes a relative path, for instance ..\TEMP which does not exist from the default folder for xp_cmdshell (which is C:\Windows\Syste32).

---

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se