>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)