Search content within the blog

Tuesday, November 18, 2008

Obtaining the list of triggers in your database alnog with the table names

select tbl = object_name(parent_obj), "trigger" = name
FROM sysobjects
where type = 'TR'
order by tbl

No comments:

Post a Comment