MS SQL xp_cmdshell permission error

Do you ever get Access denied error when using MS SQL xp_cmdshell command?

E.g. I have an special AD account access to \\server2\backups folder. In my Store Procedure, I have to copy db.bak from local folder to share folder.

Read the rest of this entry (moved to www.bronios.com) »