How to view triggers in SQL server

[Ryan]

Hello,

I am pretty much a newbie with SQL server. I have what is probably a
pretty stupid question. In SQL Enterprise manager, is there a way to
easily see all triggers, or, even better, all tables and there
associated triggers? I suppose at the least in a way similar to
viewing all saved functions or views.

Thanks,
Ryan

[Michael Gray]

On 30 Aug 2004 15:47:53 -0700, ry************@kp.org (Ryan) wrote:

Hello,

I am pretty much a newbie with SQL server. I have what is probably a
pretty stupid question. In SQL Enterprise manager, is there a way to
easily see all triggers, or, even better, all tables and there
associated triggers? I suppose at the least in a way similar to
viewing all saved functions or views.

Thanks,
Ryan

It's a bit cludgy, but in Enterprise Manager, on the database you are
looking at, select [generate SQL scripts].
Untick [Script All Objects]
Tick [All Tables]
Under the [Formatting Tab] untick everything.
Under the [Options] tab, tick [Script Triggers]
(.) Create one file
Then [OK]

This text file will then contain the scripts for creating every
trigger in the database.
I know that is not what you wanted, but you never know!

[Simon Hayes]

ry************@kp.org (Ryan) wrote in message news:<b5**************************@posting.google. com>...

Hello,

I am pretty much a newbie with SQL server. I have what is probably a
pretty stupid question. In SQL Enterprise manager, is there a way to
easily see all triggers, or, even better, all tables and there
associated triggers? I suppose at the least in a way similar to
viewing all saved functions or views.

Thanks,
Ryan

Probably the easiest way is to use a query in Query Analyzer:

select name as 'Trigger', object_name(parent_obj) as 'Table'
from sysobjects
where xtype = 'TR'

sp_helptrigger will give you the details of an individual trigger, but
you need to know the table name first.

Simon

[Chinni]

sq*@hayes.ch (Simon Hayes) wrote in message news:<60**************************@posting.google. com>...

ry************@kp.org (Ryan) wrote in message news:<b5**************************@posting.google. com>...

Hello,

I am pretty much a newbie with SQL server. I have what is probably a
pretty stupid question. In SQL Enterprise manager, is there a way to
easily see all triggers, or, even better, all tables and there
associated triggers? I suppose at the least in a way similar to
viewing all saved functions or views.

Thanks,
Ryan

Probably the easiest way is to use a query in Query Analyzer:

select name as 'Trigger', object_name(parent_obj) as 'Table'
from sysobjects
where xtype = 'TR'

sp_helptrigger will give you the details of an individual trigger, but
you need to know the table name first.

Simon

YOu can run sp_helptext 'Triggername' to display the text of triger, sp function.

Raju

[Ryan]

Thank you everyone for you help. I am able to view individual
triggers using the method you suggested Simon/Raju. I would like to
use the scripting wizard that was recommended by you Chinni, as this
would give me a list of all the trigger definitions at once, but when
I generate the script per the instructions provided I only ger an
empty file. I know there are triggers set. Any idea as to why this
might be. We are running SQL 2000 if that helps.

Thanks,
Ryan

an****@gmail.com (Chinni) wrote in message news:<6d*************************@posting.google.c om>...

sq*@hayes.ch (Simon Hayes) wrote in message news:<60**************************@posting.google. com>...

ry************@kp.org (Ryan) wrote in message news:<b5**************************@posting.google. com>...

Hello,

I am pretty much a newbie with SQL server. I have what is probably a
pretty stupid question. In SQL Enterprise manager, is there a way to
easily see all triggers, or, even better, all tables and there
associated triggers? I suppose at the least in a way similar to
viewing all saved functions or views.

Thanks,
Ryan

Probably the easiest way is to use a query in Query Analyzer:

select name as 'Trigger', object_name(parent_obj) as 'Table'
from sysobjects
where xtype = 'TR'

sp_helptrigger will give you the details of an individual trigger, but
you need to know the table name first.

Simon

YOu can run sp_helptext 'Triggername' to display the text of triger, sp function.

Raju