How to view all triggers

#1

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

#2

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

SQL Server 2005:
Select *
from sys.triggers

MC

"kwilla" <kwilla (AT) comcast (DOT) net> wrote

Quote:

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

#3

On Feb 28, 7:51 am, "MC" <marko.culoNOS... (AT) gmail (DOT) com> wrote:

Quote:

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

SQL Server 2005:
Select *
from sys.triggers

MC

"kwilla" <kwi... (AT) comcast (DOT) net> wrote in message

news:1172666233.553151.165650 (AT) j27g2000cwj (DOT) googlegroups.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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to view all triggers

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

How to view all triggers - 02-28-2007 , 06:37 AM

Re: How to view all triggers - 02-28-2007 , 06:51 AM

Re: How to view all triggers - 02-28-2007 , 02:00 PM