Help scripting all stored procedures in SQL 2005.

microsoft.public.sqlserver.tools

2 Feb 2007 2:15 PM

Nomad

Hi,

I understand how to script a single stored procedure, and how to script all
stored procedures into a single file, but I was wondering if it is possible
to script all stored procedures so that they are scripted into individual
scripts? i.e. SP_1, SP_2, SP_3 can be all scripted in a batch so that they
would be SP_1.sql, SP_2.sql, SP_3.sql?

Appreciate the help

Damon

2 Feb 2007 4:08 PM

Tibor Karaszi

Not using SSMS until sp2. But there are other options:
http://www.karaszi.com/SQLServer/info_generate_script.asp

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

Show quote

"Nomad" <nonse***@nononsense.com> wrote in message
news:45c34765$0$3939$9a6e19ea@unlimited.newshosting.com...
> Hi,
>
> I understand how to script a single stored procedure, and how to script all stored procedures into
> a single file, but I was wondering if it is possible to script all stored procedures so that they
> are scripted into individual scripts? i.e. SP_1, SP_2, SP_3 can be all scripted in a batch so that
> they would be SP_1.sql, SP_2.sql, SP_3.sql?
>
> Appreciate the help
>
> Damon
>