>Hi everybody,
>
>With this code
>
>
>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%'
>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.
In addition to Borislav's answer, in SMSS
Right click on a DB in ObjecExplorer
Select 'Tasks'
Select 'Generate Scripts'
Select a DB
Tick 'Stored Procedures'
Tick the SPs (or All) you want to script, select 'Next'
Tick 'Script to file'
Choose 'Single file' or 'File per object' (I like File per object. Makes it easy to create artifacts that can be added to source control)
Select 'Finish'