I have a list of 50 columns in a database that are likely to change or be removed within the next few months. I have a task to identify any SQL scripts that reference these tables. Up until now, I have been doing this by eye however, I have come across some huge scripts that will take forever to use this method. I'm also getting a little sick and tired of doing it :)
I would like to be able to search through a script with the 50 table.column names and if there is a hit, I can do further, manual investigation.
Can anyone recommend a product? Freeware would be best as I don't really want to use my own money to pay for the solution.