Christian Palacios
asked on
Search an SQL Server database for a specific string
Hi there,
Does anyone have a quick SQL Server stored procedure/script that will allow me to search an entire database for a string and then the output will show the exact table and column of where that string is?
We're trying to review an SQL Server database for how everything is stored.
Thanks in advance!
- Christian
Does anyone have a quick SQL Server stored procedure/script that will allow me to search an entire database for a string and then the output will show the exact table and column of where that string is?
We're trying to review an SQL Server database for how everything is stored.
Thanks in advance!
- Christian
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
have a look at this free tool from Red Gat:e: https://www.red-gate.com/products/sql-development/sql-search/
ASKER
Thank you Sam, that worked very well!
https://www.experts-exchange.com/questions/29164472/Find-a-text-string-in-Sql-server-database.html