Tuesday, November 17, 2009

Quick (and dirty) way of finding impact of field changes

If you are going to change a database table field and want to know what stored proc or UDF will be affected, you can use the following query as a quick and dirty way to find out which stored proc or UDF is using that field.


SELECT routine_name, routine_definition
FROM INFORMATION_SCHEMA.routines
WHERE ROUTINE_DEFINITION LIKE '%TextToSearch%'
ORDER BY last_altered DESC

Labels: