Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Execute permission on object sp_add_dtspackage

Author  Topic 

jlrajan
Starting Member

6 Posts

Posted - 2004-12-01 : 17:32:44
Hi,

How do I grant execute access to the msdb.dbo.sp_add_dtspackage. My login is not a member of the sysadmin or any admin role. Would I be able to create or modify DTS packages that I create? If so, could you please explain how this can be done?

Thanks

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-12-01 : 17:58:32
Do you have a DBA you can talk to?

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -