You can use the objectproperty function to check if the trigger is enabled. If you don’t mind getting it in few recordsets, you can also use the undocumented procedure sp_MSforeachdb that will run the statement on all databases. Notice that since this is an undocumented procedure I use it on my own scripts, but I never use it in a real production application.

exec sp_MSforeachdb 'use ? if DB_ID()>4 select ''?'' as DBName, name,

objectproperty(object_id,''ExecIsTriggerDisabled'') as IsDisabled

from sys.objects

where type = ''TR'''

Adi