Re: Replication and normal trigger

Thanks for your script. This one:

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

.... returns the set of replication triggers on my merge articles. Would the
same script work for transactional replication?

"Hilary Cotter" wrote:

Here's an improved version of your script ravi.

select name,object_name(deltrig),object_name(instrig),object_name(updtrig)
from sysobjects where replinfo=128

--
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



"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:u02vzSgQGHA.2012@xxxxxxxxxxxxxxxxxxxxxxx
Your correct Ravi, I think this will do it. I appreciate your correction.

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

--
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



"ravi lobo" <ravilobo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:369FD37B-6513-4149-A5E8-1FDB2DEBC178@xxxxxxxxxxxxxxxx
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: Transactional replication
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... These 2 tabbles have insert 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)