How to search every table and field in a SQL Server Database
Friday, November 02, 2007 1:28:37 PM (GMT Standard Time, UTC+00:00)
Update: I have corrected the original issue with this script. Please see Search every table and field in a SQL Server Database Updated.
Today I had an issue with Umbraco and a copy of a deleted page appearing in the menu, I'll post how I fix it if I ever do find the answer but while trying to track the issue down I came across a really useful piece of T-SQL from Narayana Vyas Kondreddi (Vyas) that searches each table in a database and then each field in the table. I had to expand it to include integers etc but all credit to him! For reference here's a copy of the code: