Simply put, this blog is a dumping ground for things I find interesting or worth remembering relating to Java, programming, web, lean, agile, etc, etc.
Thursday, September 20, 2012
SQL Server: Find a Trigger By The Table Name
Given a table name, this is how to find the triggers that are on that table.
select name, object_name(parent_id) as parent from sys.triggers where object_name(parent_id) = 'MY_TABLE_NAME'
And next time you want to use a trigger in your webapp...don't.
No comments:
Post a Comment