0

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.

Easy987us
  • 83
  • 1
  • 2
  • 5
  • By scripts do you mean actual SQL files? Or procedures/views/functions etc? – Mark Sinkinson Nov 19 '15 at 15:13
  • I mean just searching through SQL code that is open in SSMS – Easy987us Nov 19 '15 at 15:20
  • Isn't this a bit the same as your other question (http://dba.stackexchange.com/questions/121346/need-to-get-identify-all-tables-and-columns-in-a-sql-query)? – Marco Nov 19 '15 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 Nov 19 '15 at 15:23
  • Some sample data and desired output would be good. – Vérace Nov 19 '15 at 23:27

1 Answers1

0

ApexSQL Search - http://www.apexsql.com/sql_tools_search.aspx

free tools, search database object (for this tasks) - search code for columns name

a_vlad
  • 3,655
  • 2
  • 12
  • 17