April 16, 2013 at 1:47 am
What are the permission required to configure Transactional Replication? 😛
April 16, 2013 at 4:09 am
YOu require the Clustered index for transactional replication
Rajesh Singh
DBA(HCL Comnet)
+91-0560888360
April 16, 2013 at 2:56 pm
What kind of answer it is? He is asking for permission required to create Transactional replication.
Only members of the sysadmin fixed server role can set this up from end to end.
because adding publisher would require that.
But members of db_owner fixed database role can execute sp_addpublication, & sp_addsubscription.
April 17, 2013 at 4:02 am
For initial setup of any replication like transactional, you need sysadmin permissions. However, most of the things you can do with Database Owner permissions once the replication is setup. Like, adding\removing subscriptions, add\modify articles etc can be done using Database owner permissions.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply