How can I find a specific string in all Stored Procedures?
I need to change the name of the location in a warehouse. the database has a table with the location name, high, and depth. i.e. DrivinIN_03_02, but now I need to change to JIN00000303.
How can i find in all the stored procedures DrivinIN in case that it is hard coded.
I know that if I open all the stored procedures I will able to do a search but I am working remotely and that will take time.
Microsoft SQL Server 2008Microsoft SQL Server 2005