Thursday, 15 April 2010

sql - How to copy file without using XP_CMDSHELL? -


I am using SQL Server 2008. I would like to give users the possibility to copy files, what is possible without using the XP_CMDSHELL process? Because I should not change the permissions for this.

Error when I try to copy using XP_CMDSHELL:

Exec permission on object 'xp_cmdshell' was rejected, database 'mssqlsystemresource', Schema 'sys'.


No comments:

Post a Comment