Thanks for the postings, taht works great - narrows things down to about a dozen tables that I need to look at. Is there a way to programatically get the actual trigger code for a given trigter? I've followed the various links from sysobjects for the triggers, but none lead to the actual code.
thanks for the help, -reed >This should tell you if you have any: > >SELECT * >FROM sysobjects >WHERE (xtype = 'tr') > >Rey.... > > >----- Original Message ----- >From: <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Thursday, October 28, 2004 1:42 PM >Subject: SP to find all triggers in a database? > > >> Howdy - I've inherited the database (SQL Server 2000) from &^&*^*, and it >has about a zillion tables in it. I need to make some changes to the app >that goes with it, but want to find out if there are any triggers out there >that are going to do things behind my back. Is there an easy way to do this >without going through each and every table one at a time? I cannot find any >SP_ procedures to do this. >> >> thanks everyone, >> -reed >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182872 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54