This query looks through all databases for objects using the xp_cmdshell command. The original select query originally came from: http://stackoverflow.com/questions/2833389/finding-all-stored-procedures-calling-a-function

xp_cmdshell.sql

EXEC sp_MSForEachDB ' Use [?]; SELECT DB_NAME() AS ''Database Name'';
               Select *
    FROM sys.sql_modules        m
        INNER JOIN sys.objects  o ON m.object_id=o.object_id
        INNER JOIN sys.schemas  s ON o.schema_id=s.schema_id
    WHERE m.definition Like ''%xp_cmdshell%''
    ORDER BY 1'