PHWinfo - Afficher un message - Is there anyway to script multiple tables to one file?

27/05/2008, 18h10

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 -

27/05/2008, 18h10	#5
Tibor Karaszi Messages: n/a Hébergeur:	Re: Is there anyway to script multiple tables to one file? 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 -