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 |
|
wnix
Starting Member
1 Post |
 Posted - 2003-01-15 : 19:09:14
|
| I've setup a merge replication between 2 servers (1 publisher + distributer, another subscriber).Everything works fine from the publisher's end, but when I try to do updates/inserts to the subscriber's db it gives errors like:Server: Msg 208, Level 16, State 1, Procedure upd_7BD6BFF9E597457C83581F5577E821DF, Line 76Invalid object name 'ctsv_7BD6BFF9E597457C83581F5577E821DF'.Now I know that upd_7BD6BFF9E597457C83581F5577E821DF is a trigger for the table I'm trying to update, and indeed line 76 does have the so-called invalid object ctsv_blablabla, but that's all I can find out and now I'm completely stuck. What's this ctsv crap and how do I make sure it's there? I have the part of the trigger code that's causing the problem (if you want the whole bunch just let me know):---- line 76 ------ update ctsv_7BD6BFF9E597457C83581F5577E821DF set lineage = { fn UPDATELINEAGE(lineage, @nick) }, generation = @newgen, joinchangegen = case when (@joinchange = 1) then @newgen else joinchangegen end, partchangegen = case when (@partchange = 1) then @newgen else partchangegen end, colv1 = { fn UPDATECOLVBM(colv1, @nick, @bm, @missingbm) } FROM inserted as I JOIN ctsv_7BD6BFF9E597457C83581F5577E821DF as V ON (I.rowguidcol=V.rowguid) and tablenick = @tablenick---------------------------------------Thanks a lot for any help as I continue on my quest for an answer. |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-01-16 : 07:43:50
|
| The problematic code you've identified is your code rather than auto gen'd code inserted to maintain the subscription, yes? I don't see that merge replication is relevant to your problem.If you have an update trigger on a table which references an nonexistent object, find the object or modify the trigger.Jonathan{0} |
 |
|
|
|
|
|
|
|
Can't update from subscriber end