Before deciding on how to retrieve the queries, we would need to determine how queries are written against your database.

Does your application build dynamic strings which are then executed as queries against your database (adhoc queries from the app)?

Does your application strictly call stored procedures from the database?

Or is there a mix of adhoc and procs?

If the application is building dynamic adhoc queries, you need to go chat with your developers to find all of the potential places a query could hit your database and fail due to the new changes.

In the case of stored procedures and triggers - you can query the definitions of those to find anything in the database that may need to be changed due to your pending change. There are several scripts on SSC for doing that type of search to make it easier.