We have replication set up between 2 servers (SQL 2005) and among tables and views we also replicate procedures. Because roles can't get replicated, we have roles with procedure execute permissions set up on Subscriber server. It works fine until we
add procedure at Distrubutor server and reinitialize the subscription. Then database roles get "reset" i.e. all procedure entries are removed. Table entries are left intact in DB role.
Can someone tell me if this is functioning as designed or is something misconfigured. If database role can't get replicated, then it would be nice if they could at least not be replicated.
I would appreciate any help or to be pointed in right direction.
Kind regards, Max
View Complete Post