First, add
PRINT @strbcpcmd
so that you can verify that something has not been mangled by mistake.
Also keep in mind that the path must be accessible from the server you running xp_cmdshell; it bears no relation to the server you are connecting to.
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
No comments:
Post a Comment