Printable View
Any idea where to look for? thanks,
Try this: select name, objectproperty(id,'ExecIsTriggerDisabled') as disabledTrigger from sysobjects where objectproperty(id, 'isTrigger') = 1