How to display all triggers
-
Hi,
I work for a software house who's application is written around an sql database. We use merge replication and one publication to a specific subscriber reports duplicate entries in msmerge_contents.
The customer in question has an IT associate who restored the database from a backup but didn't copy back the entire MSSQL subfolder and subsequently were left with subscriptions that enterprise manager thought did not exist. I've used a T-SQL script to clear the subscriptions :
sp_mergesubscription_cleanup @publisher=???????, @PUBLISHER_DB=??????,@PUBLICATION=?????
We then re-setup the replication using initialise from the publisher.
I suspect there are duplicate INSERT triggers for the table in question and wondered if Query Analyser shows only 1 trigger for each action (update/delete/insert) is there any chance of some old triggers still firing ?
If so how could I display them using sysobjects in a simple way to clear them ?
SQL version 8.00.2039 (SP4) on publisher and subscriber
-
Hi Stephen,
This script http://www.chriskempster.com/scripts/listtriggers.sql, which appears to be originally from sqlservercentral.com, will do the trick. It's just a text file, so do a "view source" in your browser to get line breaks and indentation.
-
Thanks Karen,
Unfortunately it showed that wasn't the cause of the problem. It seems to fail on the delivery of the snapshot then leave the data there rather than roll back and undo the transactions. That leaves a duplicate copy of the data in the table and subsequently duplicate rowguids. Disabling all triggers and deleting table contents and pushing out again still fails to complete. I now can't get into the system remotely to get the full error message ARRGHH
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply