OBJECTPROPERTY (Example: Is Trigger Disabled)

				
--**************************************
-- Name: OBJECTPROPERTY (Example: Is Trigger Disabled)
-- Description:OBJECTPROPERTY allows you to glean a little more usefully information concerning many aspects of your database. In this example I will demonstrate ho to use it to check if a trigger is in a disabled state or not. (For more options see SQL Books Online).
-- By: James Travis
--
-- Inputs:OBJECTPROPERTY ( id , property )
--
-- Returns:In most cases 1 for True and 0 for False (Again see SQL Books Online for specific property options)
--
-- Assumes:For this example keep in mind one of the biggest problems you can have is trying to determine is why a specific trigger is not working. Sometimes this can be due to a disabling of a trigger done for whatever reason and inadvertently left isabled. This provides a simplistic way to quickly check first before you spend hours trying to find this simple mistake. (Also note: I am using OBJECT_ID so I can input the name which is more user friendly than me looking up the ID myself.)
--
--This code is copyrighted and has-- limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=399&lngWId=5--for details.--**************************************

SELECT OBJECTPROPERTY(OBJECT_ID('YourTriggerNameHere'),'ExecIsTriggerDisabled')
 
 
The above is just one example of information available thru OBJECTPROPERTY. You also have many more, such as:
 
CnstIsDisabled to determine if a constraint is disabled.
 
CnstIsNotRepl to identify if a constraint is being replicated to another server.
 
IsCheckCnst to determine a constraint is a check type constraint.
 
IsIndexed to check if a table (or view) has an index.
 
TableHasClustIndex to make sure a table has a clustered index.
 
For more options check out SQL Books Online.