generate trigger automaticlly when create replicatoin?

Yes - for all merged tables there are triggers which'll
update the MSmerge_tombstone and MSmerge_contents tables.
HTH,
Paul Ibison SQL Server MVP,
www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Hi paul:
My problem is that i couldn't insert new datas into those table ,which
has trigger generated by replication,
so what i am suppose to do with this,? can i just simply delete trigger ?
The error message i got is :
Invalid object name 'dbo.MSmerge_contents'. couldn't use view or
function'.............' because of binding errors
Cheers
nick
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:047101c53439$7ae97e70$a601280a@.phx.gbl...
> Yes - for all merged tables there are triggers which'll
> update the MSmerge_tombstone and MSmerge_contents tables.
> HTH,
> Paul Ibison SQL Server MVP,
> www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Hi paul:
my problem is that i couldn't insert data into those tables have
triggers that generated by replication.
so what i am suppose to do with that? can i just simply delete those
trigger, and would it be effect when i doing replciation later?
cheers
nick
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:047101c53439$7ae97e70$a601280a@.phx.gbl...
> Yes - for all merged tables there are triggers which'll
> update the MSmerge_tombstone and MSmerge_contents tables.
> HTH,
> Paul Ibison SQL Server MVP,
> www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Nick,
have you have removed the subscription? In this case try
using sp_removedbreplication to remove any lingering
traces. If you want the subscription to remain active,
then what error are you getting on an insert to the table?
Rgds,
Paul Ibison SQL Server MVP,
www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||hi paul:
the subscription here is from PDA. the errore i got is :
Invalid object name 'dbo.MSmerge_tombstone'.
Couldn't use view or function'tsvw_D758c7b90dd14f.........'
because of binding errors.
by the way , i already delete the publication associated with this
DB.
Cheers
Nick
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:108801c53502$7ba206b0$a501280a@.phx.gbl...
> Nick,
> have you have removed the subscription? In this case try
> using sp_removedbreplication to remove any lingering
> traces. If you want the subscription to remain active,
> then what error are you getting on an insert to the table?
> Rgds,
> Paul Ibison SQL Server MVP,
> www.replicationanswers.com/default.asp
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||Nick,
if sp_removedbreplication doesn't do the trick, then you'll have to remove
the triggers. Initially you could disable them all using sp_msforeachtable
"ALTER TABLE ? DISABLE TRIGGER ALL".
HTH,
Paul Ibison