How do you query for trigger status?

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Andy Warren SSC Guru Points: 119902 More actions · Answer 1

Check the status column of the trigger in sysobjects, something like this:

--will return if enabled, d_delete is the trigger name

select * from sysobjects where name='d_delete' and xtype='tr' and status & 2048 = 0

Andy

Jags2001 SSCommitted Points: 1529 More actions · Answer 2

Thanks Andy!

And I presume if it is disabled,

select * from sysobjects where name='d_delete' and xtype='tr' and status & 2048 = 1

Greg Larsen SSC-Insane Points: 20961 More actions · Answer 3

Here is another way:

select OBJECTPROPERTY ( object_id('pubs.dbo.employee_insupd'),'ExecIsTriggerDisabled')

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Gregory A. Larsen, MVP

Andy Warren SSC Guru Points: 119902 More actions · Answer 4

Better answer than mine!

Andy

Jags2001 SSCommitted Points: 1529 More actions · Answer 5

Thank you Greg!

Great website as well!! I guess I will go with your solution.

Thank you also Andy.