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)
 Roles required for replication

Author  Topic 

mona
Starting Member

5 Posts

Posted - 2004-06-04 : 05:44:52
Hi,
Is there a way to perform a replication (configure distribution, publishing ...) without being a member of sysadmin role? (i am using SQL server 200).
if so, is there any documentation or case study that supports that distribution of role so i can present the case?
Thank you for your help

mr_mist
Grunnio

1870 Posts

Posted - 2004-06-04 : 06:15:06
The roles are detailed in the Books Online under replication, roles. You have to be sysadmin to configure the initial steps. Database owners can do some bits.

I am not aware of a way around that.

-------
Moo. :)
Go to Top of Page
   

- Advertisement -