Naomi,

Please take a look at SP_HELPTEXT system stored procedure, it should return the whole SP as recordset.

Regards,

Zoran


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