Ever wonder which stored procedures reference a particular table, or where the column "Foo" is used? This script will help you answer that.
Change the value of @Search to the string you want to find, then run the script. It will return a list of object names and types where that string is used.
Enjoy!
DECLARE @Search VARCHAR(255) SET @Search = 'myData' -- change 'myData' to the string you want to locate SELECT DISTINCT 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 '%' + @Search + '%' ORDER BY 2 ,1
Find all columns containing a string value across all tables and schemas.
2012-11-07 (first published: 2012-10-12)
1,944 reads
2010-02-15 (first published: 2010-01-18)
20,825 reads
Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.
2019-04-15 (first published: 2009-04-29)
4,994 reads
