Como encontrar um texto em Functions, Procedures e Views

por **fabio.cerqueira** Qui Jun 09, 2016 7:33 pm

Código:: -- SQL 2000 e posteriores SELECT B.name , case type when 'P' then 'Stored procedure' when 'FN' then 'Function' when 'TF' then 'Function' when 'TR' then 'Trigger' when 'V' then 'View' else 'Outros Objetos' end FROM syscomments A (nolock) JOIN sysobjects B (nolock) on A.Id = B.Id WHERE A.Text like '%Nome_Objeto%' –Objeto a ser procurado ORDER BY 2 DESC -- 2005/2008 SELECT type_desc, obj.name AS SP_NAME, sqlmod.definition AS SP_DEFINITION FROM sys.sql_modules AS sqlmod INNER JOIN sys.objects AS obj ON sqlmod.object_id = obj.object_id WHERE sqlmod.definition LIKE '%Nome_Objeto%' –Objeto a ser procurado ORDER BY type_desc