Sunday, March 25, 2012

do I need to enable cross database ownership chaining for merge repl?

I have seen conflicting info on this one:
Do I need to enable cross database ownership chaining on databases that
participate in Merge replication (publishers and subscribers)? I have seen
info pointing to maybe yes, maybe no...
anyone have comments on this?
DJC,
I'm not aware of any issues having been reported.
In what context have you heard of problems arising? Maybe from the SP3
readme - there was an issue which has been clarified in the ReadMe
additions:
Clarification to Section 5.3.17 - Change to Requirements for Attaching or
Restoring a Replication Database
Section 5.3.17 "Change to Requirements for Attaching or Restoring a
Replication Database" in the SQL Server 2000 SP3 Readme file incorrectly
implies that enabling cross-database ownership chaining is a requirement for
attaching or restoring replication databases after SQL Server 2000 SP3 has
been applied. The preferred method for attaching or restoring databases
after applying SQL Server 2000 SP3, is to have a member of the sysadmin
fixed server role run the sp_changedbowner stored procedure to assign
ownership of the database to the sa built-in administrator logon. For
example:
Regards,
Paul Ibison
sql

No comments:

Post a Comment