I have various tables and stored procedures that I need to port to
another server. So I have to script each one out to a file or to the
clipboard. Is there any way to script each one so that each new one
appends to a file instead of creating a new file every time? When I
create multiple files, I have to cut and paste to put them into one
file, and the same goes for the clipboard.
Thanks,
Marvin

The generate script wizard improvements made in service pack 2 supports this (SSMS).

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


<COHENMARVIN@lycos.com> wrote in message
news:962991ce-b701-4e48-9179-e86f70ed23a4@d77g2000hsb.googlegroups.com...
>I have various tables and stored procedures that I need to port to
> another server. So I have to script each one out to a file or to the
> clipboard. Is there any way to script each one so that each new one
> appends to a file instead of creating a new file every time? When I
> create multiple files, I have to cut and paste to put them into one
> file, and the same goes for the clipboard.
> Thanks,
> Marvin

Are you not able to do this now? What version are your client tools
(|About in Management Studio)?


On 5/22/08 2:34 PM, in article
962991ce-b701-4e48-9179-e86f70ed23a4...oglegroups.com,
"COHENMARVIN@lycos.com" <COHENMARVIN@lycos.com> wrote:

> I have various tables and stored procedures that I need to port to
> another server. So I have to script each one out to a file or to the
> clipboard. Is there any way to script each one so that each new one
> appends to a file instead of creating a new file every time? When I
> create multiple files, I have to cut and paste to put them into one
> file, and the same goes for the clipboard.
> Thanks,
> Marvin

The versions I have are below. I don't find any 'generate script
wizard' though.
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 built
by: (_sqlbld)
5.0.2195

On May 22, 3:36pm, "Aaron Bertrand [SQL Server MVP]"
<ten....@dnartreb.noraa> wrote:
> Are you not able to do this now? What version are your client tools
> (|About in Management Studio)?
>
> On 5/22/08 2:34 PM, in article
> 962991ce-b701-4e48-9179-e86f70ed2...@d77g2000hsb.googlegroups.com,
>
>
>
> "COHENMAR...@lycos.com" <COHENMAR...@lycos.com> wrote:
> > I have various tables and stored procedures that I need to port to
> > another server. So I have to script each one out to a file or to the
> > clipboard. Is there any way to script each one so that each new one
> > appends to a file instead of creating a new file every time? When I
> > create multiple files, I have to cut and paste to put them into one
> > file, and the same goes for the clipboard.
> > Thanks,
> > Marvin- Hide quoted text -
>
> - Show quoted text -

1399 is RTM. It seems you have not updated your client (SSMS) to sp2.

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


<COHENMARVIN@lycos.com> wrote in message
news:5a79e6b8-fc29-4059-8424-99fbe30a0091@59g2000hsb.googlegroups.com...
The versions I have are below. I don't find any 'generate script
wizard' though.
Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00 built
by: (_sqlbld)
5.0.2195

On May 22, 3:36 pm, "Aaron Bertrand [SQL Server MVP]"
<ten....@dnartreb.noraa> wrote:
> Are you not able to do this now? What version are your client tools
> (|About in Management Studio)?
>
> On 5/22/08 2:34 PM, in article
> 962991ce-b701-4e48-9179-e86f70ed2...@d77g2000hsb.googlegroups.com,
>
>
>
> "COHENMAR...@lycos.com" <COHENMAR...@lycos.com> wrote:
> > I have various tables and stored procedures that I need to port to
> > another server. So I have to script each one out to a file or to the
> > clipboard. Is there any way to script each one so that each new one
> > appends to a file instead of creating a new file every time? When I
> > create multiple files, I have to cut and paste to put them into one
> > file, and the same goes for the clipboard.
> > Thanks,
> > Marvin- Hide quoted text -
>
> - Show quoted text -