How to view all triggers

[kwilla]

I need a way to view all existing triggers in our MS Server database
especially since I don't know what tables are involved.

Thanks,

kwilla

[MC]

SQL Server 2000:
select *
from sysobjects
where xtype ='TR'
SQL Server 2005:
Select *
from sys.triggers
MC
"kwilla" <kw****@comcast.netwrote in message
news:11**********************@j27g2000cwj.googlegr oups.com...

>I need a way to view all existing triggers in our MS Server database
especially since I don't know what tables are involved.

Thanks,

kwilla

[kwilla]

On Feb 28, 7:51 am, "MC" <[e-mail]:

SQL Server 2000:
select *
from sysobjects
where xtype ='TR'

SQL Server 2005:
Select *
from sys.triggers

MC

"kwilla" <[e-mail] in message

news:11**********************@j27g2000cwj.googlegr oups.com...

I need a way to view all existing triggers in our MS Server database
especially since I don't know what tables are involved.

Thanks,

kwilla- Hide quoted text -

- Show quoted text -

Thanks!