We need to weed out some failing stored procedures due to security changes.
A Lot of errors coming from GRANT EXEC inside stored procedures that did not 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…