Search string across all tables and columns

Pipboy level utility!

I came across a wonderful script by SQLDenis at Less Than Dot – Blog. I have been mapping data between a Numara TrackIt 8 system and a ManageEngine ServiceDesk system. While trying to find out how ManageEngine maps fields (with no database documentation, or assistance from their support team), I came across some fields on the web form that I needed to map, but I couldn’t find them in the database. SQL Search by RedGate helped to some degree, but in this case I needed something a little faster.

Using the sp written by SQLDenis at http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/the-ten-most-asked-sql-server-questions–1#2 , I was able to put an identifying string (think codeword) then search it out. This enabled me to find form fields that used columns in the db named “Attribute_301” etc.

Thanks SQLDenis, you may take your place among the real men of genius.