triggers

[anonymowho]

I am looking at a table in Microsoft SQL Server. I went to the dependencies of this table and it says TRIG_customer. so i am thinking there is a trigger that affects the table but how do i see what is the code that resides within this trigger. I looked among the stored procedures but i couldnt find this trigger.

are all the triggers listed together somewhere. where is this trigger named TRIG_customer?

thanks in advance

 

[pritcham]

Hi

From MS Books online:

How to view a trigger (Enterprise Manager)
To view a trigger

Expand a server group, and then expand a server.


Expand Databases, expand the database in which the table containing the trigger belongs, and then click Tables.


In the details pane, right-click the table on which the trigger exists, point to All Tasks, and then click Manage Triggers

Hope that helps
Martin