June 22, 2004 at 3:54 am
I notice that in the Microsoft replication stored procedures they don't qualify the table names with the owner of that table!
June 22, 2004 at 7:42 am
The owner of the sp should be the login that you use to sincronize the publisher with the subscribers.
When you sincronice the replication, then SQL applies the snapshot and creates the sp needes to replicate the changes made at the publisher. The account that uses the distribution agent will create the SPs.
Wich doesn't need to be the same as the owner of the destination table.
The owner of the table at the publisher should be the same as the owner of the table at the subscriber, both dbo.
June 22, 2004 at 7:46 am
I know you don't have to specify the owner, but MS made a big song and dance about it being best practice.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply