Mega Code Archive
Retrieving all of the triggers for each table
<![CDATA[
13>
14>
15> SELECT name,
16> COALESCE(OBJECT_NAME(instrig), 'N/A') AS InsertTrigger,
17> COALESCE(OBJECT_NAME (updtrig), 'N/A') AS UpdateTrigger,
18> COALESCE(OBJECT_NAME (deltrig), 'N/A') AS DeleteTrigger
19> FROM sysobjects
20> WHERE type = 'U'
21> ORDER BY name
22> GO
name InsertTrigger
UpdateTrigger DeleteTrigger
-------------------------------------------------------------------------------------------------------------------------------- -----------------------------------------------------------------------
--------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------
-------------------------------------------------------------------------------------------------------------------
MSreplication_options N/A
N/A N/A
department_pivot N/A
N/A N/A
SalesMw N/A
N/A N/A
spt_fallback_db N/A
N/A N/A
spt_fallback_dev N/A
N/A N/A
spt_fallback_usg N/A
N/A N/A
spt_monitor N/A
N/A N/A
spt_values N/A
N/A N/A
(8 rows affected)
]]>