Search string across all tables and columns

01_Vault_101_Citizenship_Award

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.

One comment

  1. I really like your blog.. very nice colors & theme.
    Did you make this website yourself or did you hire someone to do it
    for you? Plz answer back as I’m looking to create my own blog and would like to know
    where u got this from. appreciate it

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.