Networks

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.

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

Related Discussions

Related Forums