I've recently started working at a company that maintains between four hundred and five hundred client databases, and am doing various maintenance tasks on code (I am junior level after all). I've been tasked with identifying a particular bug in a group of views across the entire scope of the company, and changing each one. I was able to identify all of the culprits already via SQLSearch (a lifesaver), but am now tasked with modifying one particular line of code to a new standard across almost 1,200 views.
- The wrong line of code (there are 3 variations, i know all three)
- The correct line of code I need to replace the wrong lines with
- Which views and which databases have the error.
- How many views in each database are currently 'wrong'
How can I easily modify the views to correct the error without doing it by hand?