Home Forums SQL Server 2008 SQL Server 2008 - General Using xp_cmdshell to grant fulladmin (read/write/xecute/full control) to a sql user RE: Using xp_cmdshell to grant fulladmin (read/write/xecute/full control) to a sql user

  • when running as a sql server account the job will impersonate the service account at the OS level. If the service account has permission to the folder then it will be successful.

    Setup a credential and map to a file system proxy to do the necessary work for you.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉