SQL query to get Stored Procedure crop result if the routine_definition is greater than 4000 char

Please try with sp_helptext 'ProcedureName' or you can use either sys.sql_modules or OBJECT_DEFINITION([object_id]) function to get the stored procedure text. All this gives your exact code. Information_Schema.Routines will give up to max of nvarchar(4000).