SQL Server - Saber cuando un objeto tiene cursores!!

SELECT  N'master' AS [Database], COUNT(o.[object_id]) AS [MS Objects Using Cursors]

FROM    master.sys.all_objects AS o

            INNER JOIN master.sys.all_sql_modules AS m

            ON  o.[object_id] = m.[object_id]

WHERE   o.is_ms_shipped = 1 AND

        m.[definition] LIKE N'%DECLARE%CURSOR%OPEN%FETCH%CLOSE%DEALLOCATE%'

UNION

SELECT  N'msdb' AS [Database], COUNT(o.[object_id]) AS [MS Objects Using Cursors]

FROM    msdb.sys.all_objects AS o

            INNER JOIN msdb.sys.all_sql_modules AS m

            ON  o.[object_id] = m.[object_id]

WHERE   o.is_ms_shipped = 1 AND

        m.[definition] LIKE N'%DECLARE%CURSOR%OPEN%FETCH%CLOSE%DEALLOCATE%';

GO

SELECT  o.[name], o.type_desc

FROM    master.sys.all_objects AS o

            INNER JOIN master.sys.all_sql_modules AS m

            ON  o.[object_id] = m.[object_id]

WHERE   o.is_ms_shipped = 1 AND

        m.[definition] LIKE '%DECLARE%CURSOR%OPEN%FETCH%CLOSE%DEALLOCATE%'

ORDER BY

        [name];

GO