December 11, 2001 at 1:30 am
I am trying to do replication from source database with owner 'SYSTEM' to target database on different server when the replication is completed the object at target database have 'DBO' owner ship insteed of 'SYSTEM'.
How do i replicate between source and target database on different servers so that owner of the source and target database remain same?
Please help me in this..
Ashok
December 11, 2001 at 4:16 am
Im surprised this would happen, but I dont use object ownership, so wouldnt have noticed if it did! Seems like you should be able to change the object owner on the subscriber manually if nothing else. I will experiment some.
Andy
December 11, 2001 at 5:02 am
Please notice that I am doing merge replication where sql-server never ask for
destination database owner.
Ashok
December 11, 2001 at 11:11 am
What kind of subscriber it is if it is a puch subscriber then the owner will be System....
If it is pull or anonymous it will be DBO 🙂
Aleem A Mohammed
Aleem A Mohammed
December 11, 2001 at 8:54 pm
It is push subscribtion..
December 12, 2001 at 9:56 pm
What happend no solution till date???.
Ashok
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply