There are times when you need to figure out what Stored Procedures are currently running and if they are blocking any if all other processes.
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext
WHERE DB_NAME(database_id) = ‘MyDatabaseName‘
If you every decided to do something ridiculous and whatever you did requires that all SP needs to be updated, here is how you can thumb through the SP in search of the string.
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
WHERE ROUTINE_DEFINITION LIKE ‘%AS400%’