Post reply

Job Fails when owned by user account

  • January 25, 2006 at 2:10 am

    #616834

    I have a current job which is launched by users, it uses xp_cmdshell to call BCP and import a large amount of data.

    Without using a proxy or sysadmin, is the only way to achieve this via scheduling or DTS?

  • January 25, 2006 at 7:04 am

    #616881

    Yes. If you don't have a proxy account setup, your users won't be able to run xp_cmdshell, even if you've granted access to it, unless they are sysadmins. Therefore, scheduling or DTS would be the only typical ways to do this.

    K. Brian Kelley
    @kbriankelley

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply