Prev: is the Top or Order by done first?
Next: SubQueries or CASE
From: fniles on 22 Apr 2010 18:00
In SQL 2005, how do you create a script for all the stored procedures to a
file ?
I only know how to do it 1 procedure at a time.
Thank you.


From: Uri Dimant on 22 Apr 2010 23:25
Right click on the database ---Tasks ---Generate Scripts--then choose Object
Types =stored procedures

"fniles" <fniles(a)pfmail.com> wrote in message
news:%237Vrpcm4KHA.620(a)TK2MSFTNGP02.phx.gbl...
> In SQL 2005, how do you create a script for all the stored procedures to a
> file ?
> I only know how to do it 1 procedure at a time.
> Thank you.
>


From: fniles on 23 Apr 2010 09:59
Great, Thanks !

"Uri Dimant" <urid(a)iscar.co.il> wrote in message
news:%23dY%23$Rp4KHA.6108(a)TK2MSFTNGP06.phx.gbl...
> Right click on the database ---Tasks ---Generate Scripts--then choose
> Object Types =stored procedures
>
> "fniles" <fniles(a)pfmail.com> wrote in message
> news:%237Vrpcm4KHA.620(a)TK2MSFTNGP02.phx.gbl...
>> In SQL 2005, how do you create a script for all the stored procedures to
>> a file ?
>> I only know how to do it 1 procedure at a time.
>> Thank you.
>>
>
>


 | 
Pages: 1
Prev: is the Top or Order by done first?
Next: SubQueries or CASE