I have to add a column to a table. No big deal, right? Except I've got to find where there are production queries that might crash when this column is added. Queries such as
Insert Into Some_Table
Select * from Changing_Table
What is the best way to find the source of a particular query? Would it be to search query plans using DMVs (I tried that but didn't find a DMV that gave me what I need)? Or would it be to set up a trace for, say, 24 hours looking at StatementCompleted? How could I find the queries I'm looking for in the trace results (I've been trying to look for a string in the textdata column )?