
Your hero for the day!
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
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE ‘%GRANT %’
AND ROUTINE_TYPE=’PROCEDURE’
Happy Happy Joy Joy…