We have 4 Databases with 100 to 200 Tables. The Application use the same
Table Name with different Table owner. This for productiv data, demo data,
test data etc. Merge Replication works per default only with dbo (Snapshot
ceration etc.) I tryed to create publication -> transfered Database with
backup restore -> transfered neded stored procedures -> created subscription
and changed SubscriberLogin
This tryed in many many combination without success.
- spend days in testing various scenarious also using snapshot instead of
backup restore etc..
- same steps with dbo as table owner works without problem
Has somebody more information ore a solution how to use merge replication
with different table owner
System NT Server 4 Sp6 with SQL Server 7 (Deskt. Ed.) and Sp2
Would be kuky about every tip, information or solution