Searching the database for text in SQL Server
Posted by Brian Clifton
Written May 9, 2010 at 23:57
Written May 9, 2010 at 23:57
In SQL Server, there's a lot of times where you need to find out where a stored procedure, user function, or value is referenced in the database.
For example, let's say we have a stored procedure called "InsertUser". We can search all database text for any references of this:
For example, let's say we have a stored procedure called "InsertUser". We can search all database text for any references of this:
SELECT *
FROM syscomments
WHERE text LIKE '%InsertUser%'