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 |
|
filson
Starting Member
1 Post |
 Posted - 2006-09-03 : 07:43:04
|
| Dear friends I have a problem in replication.Please read it patientfully and give give some better ideas.I taken a backup of replicated database.That I restored on another server.I made that one as a publisher.Another instance I made as a subscriber.I restored same database on this subscriber.Then I tried for transactional replication.While synchronizing I got error on my subscriber 'Sp_MsIns_AgentCode is not found'.This I got while Inserting records to AgentCode Table in publisher.Then I come to know for each table article published in Transactional replication will have three system generated stored procedures 1)insertion 2)updation 3)Deletion.This is not generating when i subscribing to my publisher..Here when I am pulling the subscription I am specifying 'No Shema & data transfer'.So I am not able to transport this System generated Procedures.If I am selecting 'Schema & data Tansfer'.It won't able to initialize in subscriber due to Foreign Key criterias.Please suggest after completing Subscription through Wizard,Can I trnsfer UPD,INS,DEL Procedure Schema through any Sp_procedure call? Give me some better way |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-09-05 : 23:03:31
|
| re-run the snapshot and make sure your articles are set to be dropped to resolve the schema conflictshope this helps--------------------keeping it simple... |
 |
|
|
|
|
|
Generation of stored procedures for replication