Baber Amin
asked on
search for a string in all tables
Hi,
Is there any query to find a string e.g 'abc' in all fields and all tables in a particular database in SQL Server?
Is there any query to find a string e.g 'abc' in all fields and all tables in a particular database in SQL Server?
ASKER
Thanks.
Its a stored procedure.
Can I just run it simply as SQL to get results?
Its a stored procedure.
Can I just run it simply as SQL to get results?
Assuming you declare the variables and set them to some values instead of passing the parameters values to the SP for sure - caution though that may take a while depending on the size of the database.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
https://gallery.technet.microsoft.com/scriptcenter/c0c57332-8624-48c0-b4c3-5b31fe641c58