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

i use query stored procedure in database (i'm using microsoft sql server 2008):

 select      specific_name, routine_definition        information_schema.routines 

for result ok, row long routine_definition result cropped.

do know how solve it?

solved: final, correct, query:

select o.name, m.definition sys.objects o inner join sys.schemas s on o.[schema_id] = s.[schema_id] inner join sys.sql_modules m on o.[object_id] = m.[object_id] o.[type] in ('p', 'fn') 

please try sp_helptext 'procedurename' or can use either sys.sql_modules or object_definition([object_id]) function stored procedure text. gives exact code. information_schema.routines give max of nvarchar(4000).