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-08-06 : 23:39:46
|
| magdy writes "case : 2 serversserver1 : has database named DB1server2 : has database named DB1 DB1 : 2 tables ( T1 ,T2)i want to make 2 kinds of replicationt1 : merge replicationt2 : transaction replicationwhat i did :step1:I made a full snapshot from db1 on the server1 to server2so they both have the same schemastep2:merge replication with article filter to replicate the t1 (table 1)not using the t2step3:makeing the server2 as subscriber for server1 (the subscriber already has the schema check box = true) and start the merge replication result : working finestep4:making a transaction replication on server2 for the t2 ( Table 2 )on the same database DB1step5 :making server1 as a subscriber for server2 for the transaction replicationand starting the agentsresult : Could not find stored procedure 'sp_MSins_t2'. ( on server1 )i think that the schema of the merge replication is diffrent than the schema of the transaction replicaitonplease helpi need to know if it can be donecas if i said it can't be done and it isI WILL GET FIERD u r my last hopeplease helpthank u" |
|
|
|
|
|
Replication