I am trying replication in sqlserver 7. My source db has table owners different to dbo. When I trying replication, it searches for tables in the destination server as dbo and not as the owner which is there in the source db.
For example in source db has db1.system.emp_master but it tries replication with db2.dbo.emp_master in the destination server.
How can I overcome this problem so that it searches for db2.system.emp_master in the destination server?