scripting in sql management studio

2 Nov 2005 5:26 AM

Quinn

Like EM, management studio allows us to select multiple objects to script.
However unlike EM, it doesn't give us the option to create separate scripts
per object. Is there a way to create separate scripts for each object in sql
management studio?

2 Nov 2005 9:45 AM

Sophie Guo [MSFT]

Hello,

In SQL server 2005 Management Studio, you can script the table, view,
database, etc.

You may refer to the following information:

Scripting a Table
http://msdn2.microsoft.com/en-us/library/ms169684(en-US,SQL.90).aspx

You may use SQL Server Scripts Wizard to generate the Scripts. To start the
Scripts Wizard, right-click a database in Object Explorer, select Tasks>
Generate Scripts.

I hope the information is helpful.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

3 Nov 2005 1:48 AM

Quinn

Hi Sophie,
My question is how to script multiple objects at once and
have separate scripts created for each object. For example, in SQL 2000 when
multiple objects are scripted and saved as separate files, tables are
scripted as .TAB files, stored procedures as .PRC files, functions as .UDF
files, etc...

Show quote

"Sophie Guo [MSFT]" <v-s***@online.microsoft.com> wrote in message
news:gVKwlI53FHA.2904@TK2MSFTNGXA01.phx.gbl...
> Hello,
>
> In SQL server 2005 Management Studio, you can script the table, view,
> database, etc.
>
> You may refer to the following information:
>
> Scripting a Table
> http://msdn2.microsoft.com/en-us/library/ms169684(en-US,SQL.90).aspx
>
> You may use SQL Server Scripts Wizard to generate the Scripts. To start
> the
> Scripts Wizard, right-click a database in Object Explorer, select Tasks>
> Generate Scripts.
>
> I hope the information is helpful.
>
> Sophie Guo
> Microsoft Online Partner Support
>
> Get Secure! - www.microsoft.com/security
>
> =====================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>

3 Nov 2005 11:00 AM

Sophie Guo [MSFT]

Hello,

Thanks for clarify . Based on my research, I didn't find the similar way to
have separate scripts created for each object at once. I will do more
research on it. If there is any update, I'll let you know.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

3 Nov 2005 3:16 PM

Kevin3NF

Wow...major oops for the GUI team :(

I use the separate file feature recularly to create files which I then get
stored in VSS....

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

Show quote

"Sophie Guo [MSFT]" <v-s***@online.microsoft.com> wrote in message
news:Fok2VXG4FHA.1144@TK2MSFTNGXA01.phx.gbl...
> Hello,
>
> Thanks for clarify . Based on my research, I didn't find the similar way
> to
> have separate scripts created for each object at once. I will do more
> research on it. If there is any update, I'll let you know.
>
> Sophie Guo
> Microsoft Online Partner Support
>
> Get Secure! - www.microsoft.com/security
>
> =====================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>

9 Nov 2005 7:31 AM

William Stacey [MVP]

Couldn't you just script all that in a single script (i.e. a script to
generate all those scripts and store them in your DB, files, etc.)?

--
William Stacey [MVP]

Show quote

"Quinn" <dellsql@newsgroups.nospam> wrote in message
news:uKwH8323FHA.2552@TK2MSFTNGP10.phx.gbl...
> Like EM, management studio allows us to select multiple objects to script.
> However unlike EM, it doesn't give us the option to create separate
> scripts per object. Is there a way to create separate scripts for each
> object in sql management studio?
>