Home All Groups Group Topic Archive Search About

SQL 2005 generate multiple script files

Author
23 Feb 2006 2:49 PM
John F.
Does anyone know how to generate multiple script files like was possible in
SQL2000?  The only option I can find is to gen one huge long file, or to
clipboard or query window (still one file) - the doc says its possible but I
dont see it in the Mgmt Studio - thanks.
--------- from the doc
Script to file
Generate the script to a .sql file, either as Unicode or ANSI text. Click
the browse button (…) to specify a name and location for the file.

Script to clipboard
Save the script to the Clipboard.

Script to Query Editor
Generate the script to a Query Editor window. If no editor window is open, a
new editor window is opened as the target for the script.

--
John F.

Author
24 Feb 2006 3:25 AM
Sue Hoegemeier
You can't in SQL 2005. Check this article and scripting
utility:
http://weblogs.sqlteam.com/billg/archive/2005/11/22/8414.aspx

-Sue

On Thu, 23 Feb 2006 06:49:28 -0800, "John F."
<juant***@newsgroups.microsoft.com> wrote:

Show quote
>Does anyone know how to generate multiple script files like was possible in
>SQL2000?  The only option I can find is to gen one huge long file, or to
>clipboard or query window (still one file) - the doc says its possible but I
>dont see it in the Mgmt Studio - thanks.
>--------- from the doc
>Script to file
>Generate the script to a .sql file, either as Unicode or ANSI text. Click
>the browse button (…) to specify a name and location for the file.
>
>Script to clipboard
>Save the script to the Clipboard.
>
>Script to Query Editor
>Generate the script to a Query Editor window. If no editor window is open, a
>new editor window is opened as the target for the script.

AddThis Social Bookmark Button