The following may get you started:

Select 'Grant ' +

Case sp.action

        when 26 then 'REFERENCES'

        when 193 then 'SELECT'

        when 195 then 'INSERT'

        when 196 then...

We have experienced this problem too, and I agree with Colin that it seems to be a configuration change and not directly connected with SQL Server - it just suffers...

The following may go some way to providing the information you seek:

Select sdid.name as [Trigger Name], sdepid.name as [Dependent Object Name],

(Case sdepid.xtype

when 'P' then 'Procedure'

 when 'TR'...