SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%mytablename%'
The problem this encounteres however is that ROUTINE_DEFINTION is NVARCHAR(4000) and hence only returns the first 4000 characters of a stored procedure. The alternative below searches the entire codebase.
SELECT DISTINCT SCHEMA_NAME(schema_id) as schema_name ,o.name AS Object_Name ,o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_id = o.object_id WHERE m.definition LIKE '%mytablename%' ORDER BY 1,2
No comments:
Post a Comment