How you can find a string in a SQL database? One option would be to export the database to Excel file and use the Excel searching capabilities. Unfortunately I did not manage to get the export working for me at all. If you want to do it the smart way, here is a query that search all tables and columns in a database written by from Vyas Kondreddi. Another one is available for replacing string in a database.
2 Comments
Leave a Reply
You must be logged in to post a comment.
I also struggled with this problem in my work and I have tried TM Field Finder form TargetMind.com it’s really cool and light software which helps to search for anything in SQL Server schema and data.e
This tool (Search string in SQL) is handy and easy to search string in a SQL Server database.