Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Export Data Via Task (Permission) Expand / Collapse
Author
Message
Posted Tuesday, March 26, 2013 1:57 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 9:33 AM
Points: 157, Visits: 1,178
I've set up a simple task which copy data from a table and export them to another database that is on a different server. I have the radio button on to "Delete rows in destination table". I notice the job fails with the error "You don't have Permissions to delete/truncate this table". I had created the task under the sa account as well as my account which is an administrator account. Should I (the task) be able to delete the data in the destination table?
Post #1435679
Posted Tuesday, March 26, 2013 2:17 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 9:33 AM
Points: 157, Visits: 1,178
I got it.
Post #1435688
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse