• Mac1986 (7/8/2013)


    yes i do have xp_cmdshell enabled. All i see in the job log is Access denied. Its does not say anything else.

    --Turn on extended configuration options

    exec sp_configure 'show advanced option',1;

    reconfigure;

    --Check to see whether CMDSHELL is turned on (value one is returned)

    exec sp_configure 'xp_cmdshell';

    --If not activated then execute the following

    exec sp_configure 'xp_cmdshell', 1;

    reconfigure;

    If that doesn't work then check the NTFS permissions to the file to ensure that you have access.

    I know you have said it is turned on but it can always be worth checking.....