• If you want the name of the table along with the trigger name:

    select tbl.name as TABLE_NAME, trg.name as TRIGGER_NAME

    from sysobjects trg

    inner join syscomments sc on sc.id = trg.id

    inner join sysobjects tbl on tbl.id = trg.parent_obj

    where trg.xtype = 'TR' and sc.text like '%[^A-Z0-9_]sales[^A-Z0-9_]%'