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.
-
By scripts do you mean actual SQL files? Or procedures/views/functions etc?Mark Sinkinson– Mark Sinkinson2015年11月19日 15:13:09 +00:00Commented Nov 19, 2015 at 15:13
-
I mean just searching through SQL code that is open in SSMSEasy987us– Easy987us2015年11月19日 15:20:58 +00:00Commented Nov 19, 2015 at 15:20
-
Isn't this a bit the same as your other question (dba.stackexchange.com/questions/121346/…)?Marco– Marco2015年11月19日 15:21:21 +00:00Commented Nov 19, 2015 at 15:21
-
Hi Marco, I think the question is different but it is to achieve the same result. Instead of outputting all tables and columns I was hoping to just search for all of them in one go.Easy987us– Easy987us2015年11月19日 15:23:19 +00:00Commented Nov 19, 2015 at 15:23
-
Some sample data and desired output would be good.Vérace– Vérace2015年11月19日 23:27:13 +00:00Commented Nov 19, 2015 at 23:27
1 Answer 1
ApexSQL Search - http://www.apexsql.com/sql_tools_search.aspx
free tools, search database object (for this tasks) - search code for columns name