triggers

anonymowho

New Member
Joined
Dec 2, 2005
Messages
21
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
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

pritcham

Board Regular
Joined
Oct 26, 2005
Messages
128
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,069
Messages
5,570,004
Members
412,304
Latest member
citrus
Top