Re: Replication and normal trigger

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hilary..I think your query lists all the triggers on replicated tables
(System+user). I think the requirement here is only for system triggers.

-Ravi Lobo

"Hilary Cotter" wrote:

select 'tablename'=object_name(objid),sysobjects.name from sysmergearticles
join sysobjects on sysobjects.parent_obj =objid
where sysobjects.type='tr'

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Laurence" <Laurence@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:83BB18E8-E329-4331-B372-91A1FD2D99D5@xxxxxxxxxxxxxxxx
Did anyone ever find a reliable way of identifying replication triggers? I
need a way to do this with 100% certainty so I can't reply on the naming
convention.

Thanks

"José Araujo" wrote:

Yeah... I think you are better off relaying on the name conventions.

However you can only do that if you are the one naming the other
triggers.

Good luck

"ravi lobo" <ravilobo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:236CF93E-F981-4ED1-86C2-E21920F0C2DF@xxxxxxxxxxxxxxxx
José,

This is not correct. I have a merge replication setup. I am not getting
category=2 for merge triggers.

-Ravi


"José Araujo" wrote:

Not sure, but I would check the Sysobjects.Category column for those
triggers (and compare it to user generated triggers).

I just took a quick look and Category seems to be =2 for replication
triggers - users triggers seems to be 0.

Note: I didn't really check it throughfully...

José.







.

Relevant Pages

  • Re: Replication, DTS, Triggers?
    ... If it goes the way I would hope, we would do incremental pulls of ... your saying it sounds like replication is the best starting point. ... > DTS is a great tool for pulling stuff in and making some (hopefully not ... > I'd avoid triggers if possible but that's just me. ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication and normal trigger
    ... There are no triggers on plain vanilla transactional replication. ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication Triggers
    ... you do not want to "mess" with the triggers that replication creates. ... evaluate replication blob triggers and decide whether they need adjustment ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication and normal trigger
    ... join sysobjects on sysobjects.parent_obj =objid ... returns the set of replication triggers on my merge articles. ... Director of Text Mining and Database Strategy ... I think the requirement here is only for system triggers. ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication with Triggers
    ... database during the day) from the subscriber database and write to the file ... So for this I have created the transactional replication between the ... Triggers are not complex just it is a one line(update tablename set ...
    (microsoft.public.sqlserver.replication)