Query using schema to determine if Trigger exists

Hi,

I would like to know if there's a query that can tell me whether or not a trigger exists!

Thanks!

Quote:

Originally Posted by Barno77

Hi,

I would like to know if there's a query that can tell me whether or not a trigger exists!

Thanks!

Returns list of trigger names from a specific database

select * from dbo.sysobjects where OBJECTPROPERTY(id, N'IsTrigger') = 1

Regards

Jim :)|||Thank you! This helped me!