How to view all triggers

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,

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

SQL Server 2005:
Select *
from sys.triggers

MC

"kwilla" <kwilla@.comcast.netwrote in message
news:1172666233.553151.165650@.j27g2000cwj.googlegr oups.com...

Quote:

Originally Posted by

>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
>

|||On Feb 28, 7:51 am, "MC" <marko.culoNOS...@.gmail.comwrote:

Quote:

Originally Posted by

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

Quote:

Originally Posted by

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

>

Quote:

Originally Posted by

Thanks,

>

Quote:

Originally Posted by

kwilla- Hide quoted text -

>
- Show quoted text -

Thanks!