>>Hi everybody,
>>
>>With this code
>>
>>

>>declare @LongName varchar(max)
>>--set @LongName = ''
>>--
>>--select @LongName = @LongName + ' ' + ISNULL(FirstName,'') from Registration
>>--select @LongName as LongName
>>set @LongName = ''
>>select name from sys.procedures order by name
>>SELECT @LongName = @LongName + char(13) + OBJECT_DEFINITION(OBJECT_ID) from sys.procedures where Name Like 'Registration%'
>>print @LongName

>>
>>I only get the first N number of lines. Is there a way to get whole code of my procedures into some convenient text format without opening each one using SSMS?
>>
>>Thanks a lot in advance.
>
>You get all code, but the PRINT cuts it to 8000 chars.
>try:
>

>declare @LongName varchar(max)
>set @LongName = ''
>select name from sys.procedures order by name
>SELECT @LongName = @LongName + char(13) + OBJECT_DEFINITION(OBJECT_ID)
>             from sys.procedures
>              where Name Like 'Registration%'  AND
>              is_ms_shipped = 0 --- Only user SP
>print @LongName
>
>SELECT @LongName, LEN(@LongName)
>

Thanks, Borislav. The len is 32K. So, is there a way to get the whole code text?

Though I found that I did have these procedures in my long file I maintain.