gistfile1.txt

use ts95pro;
GO

SELECT 
     obj.name AS trigger_name 
    ,USER_NAME(obj.uid) AS trigger_owner 
    ,s.name AS table_schema 
    ,comments.text AS text
    ,OBJECT_NAME(parent_obj) AS table_name 
    ,OBJECTPROPERTY( obj.id, 'ExecIsUpdateTrigger') AS isupdate 
    ,OBJECTPROPERTY( obj.id, 'ExecIsDeleteTrigger') AS isdelete 
    ,OBJECTPROPERTY( obj.id, 'ExecIsInsertTrigger') AS isinsert 
    ,OBJECTPROPERTY( obj.id, 'ExecIsAfterTrigger') AS isafter 
    ,OBJECTPROPERTY( obj.id, 'ExecIsInsteadOfTrigger') AS isinsteadof 
    ,OBJECTPROPERTY(obj.id, 'ExecIsTriggerDisabled') AS [disabled] 
FROM sysobjects  obj

INNER JOIN sysusers 
    ON obj.uid = sysusers.uid 

INNER JOIN sys.tables t 
    ON obj.parent_obj = t.object_id 

INNER JOIN sys.schemas s 
    ON t.schema_id = s.schema_id 

INNER JOIN syscomments comments 
    ON comments.id = obj.id

WHERE obj.type = 'TR' 
and obj.name like '%bdusers%'