What do I have to do in SQL 2000 to replicate permissions?
Depends on the exact scenario, but I use a post-snapshot script to replicate
permissions for initialization. For subsequent changes to permissions, I use
sp_addscriptexec.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||thanks Paul.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment