Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-29 : 22:36:20
|
Sridhar writes "I have two servers Server 1 and Server 2. I am using Server 1 as the Publisher and Server 2 as the Subscriber and am using Transactional Replication. When configuring the Push Subscription, I selected the option that the schema and data already exist on the Subscriber. The idea is that thought the schema and structure of the tables is the same on Server 1 and Server 2, the data is different and I wanted to preserve the original database on Server 2 and propagate only the subsequent changes from Server 1 to Server 2.
After setting up the replication in the above manner and making some data changes on Server 1, I get an error saying that "Could not find 'sp_MSdel_table name' and the replication fails. What is the reason?
If I select to create the snapshot and run it at the subscriber initially, the replication works fine but the problem is that the database on Server2 is replaced with data from Server 1 initially and I did not want this.
" |
|
|
|
|
|
Replication