MSSQL - List definitions of very long stored procedures

Watch this example on YouTube:



SELECT ROUTINE_NAME, ROUTINE_TYPE, ROUTINE_DEFINITION AS FIRST4000,
OBJECT_DEFINITION(Object_ID(ROUTINE_NAME)) AS FULLDefinition,
LEN(OBJECT_DEFINITION(OBJECT_ID(ROUTINE_NAME))) AS LenOfTheObject
FROM INFORMATION_SCHEMA.ROUTINES
WHERE (LEN(OBJECT_DEFINITION(OBJECT_ID(ROUTINE_NAME)))> 4000)
ORDER BY LenOfTheObject