Hi RandyB,
quote:
Is there any known way to search triggers in all tables on a db for references to a specific table?
this is no complete solution but I hope someone else will provide the missing part
SELECT * FROM sysobjects WHERE xtype = 'TR' will give you a list of all triggers in a db
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]