We need to weed out some failing stored procedures due to security changes.
Alot of errors coming from GRANT EXEC inside stored procedures that didnt need to be there.
Run the following query to speed along the discovery process:
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
WHERE ROUTINE_DEFINITION LIKE ‘%GRANT %’
Happy Happy Joy Joy…