Post reply

Permissions

  • September 30, 2008 at 10:43 am

    #127818

    To schedule SQL Jobs (DTS - Import Export etc) does a user need Sysadmin permissions on the database server? If no, then what permissions are required to perform this operation?

    Thanks,

  • September 30, 2008 at 12:50 pm

    #879090

    California (9/30/2008)

    To schedule SQL Jobs (DTS - Import Export etc) does a user need Sysadmin permissions on the database server? If no, then what permissions are required to perform this operation?

    Thanks,

    I'm assuming you're on 2005 being that you're in the 2005 forum?

    With 2005, there are now SQL Server Agent Fixed Database Roles: http://msdn.microsoft.com/en-us/library/ms188283.aspx

    If you're 2000, than I'm pretty sure that you do need to be a sysadmin to do anything with creating/modifying jobs.

  • September 30, 2008 at 12:52 pm

    #879094

    Thanks for the contribution.

Viewing 3 posts - 1 through 2 (of 2 total)

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