|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL 2005 generate multiple script filesDoes 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. 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. |
|||||||||||||||||||||||