Select Object_name(o.parent_obj) as "Table_name", o.[name] as "Trigger_name"From sysobjects oWhere Objectproperty(o.[id], 'IsTrigger')=1 and Objectproperty(o.[id], 'IsMSShipped')=0Order by 1,2