Discussion Locked

SQL Replication

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
After successfully replicating DB to another server permissions are dropped on the DB that was replicated. Any ideas? ver 7.0

5 replies

by headbangerphil

books online suggests 'sp_helpreplicationdboption' under remarks, you'll find advice to execute permissions default to the 'public' role. also check out the system stored procedures . I would think that you will have to reset all permissions in replicated db. perhaps this is a good place to start..
luck, hbp.

This discussion is closed to new replies.