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=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182857 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
