General discussion

Locked

SQL Replication

By tammy.sutton ·
After successfully replicating DB to another server permissions are dropped on the DB that was replicated. Any ideas? ver 7.0

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL Replication

by headbangerphil In reply to SQL Replication

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.

Collapse -

SQL Replication

by tammy.sutton In reply to SQL Replication

The question was auto-closed by TechRepublic

Collapse -

SQL Replication

by Cedric King In reply to SQL Replication

You referring to the source or the destination?

Collapse -

SQL Replication

by tammy.sutton In reply to SQL Replication

The question was auto-closed by TechRepublic

Collapse -

SQL Replication

by tammy.sutton In reply to SQL Replication

This question was auto closed due to inactivity

Back to Networks Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums