SQL Server Management Studio - Script Objects to Individual Files

microsoft.public.sqlserver.tools

26 Jun 2006 4:06 PM

jlccd@newsgroups.nospam

Using SQL Server Enterprise Manager we typically select a group of objects
and scripted them to individual files. We are in the process of migrating
to SQL Server 2005 and using SQL Server Management Studio. How can we
accomplish this same task using SQL Server Management Studio?

What is the trick?

26 Jun 2006 11:28 PM

Sue Hoegemeier

There isn't as much scripting functionality in SQL Server
Management Studio as there was in Enterprise Manager. There
is a nice utility for more scripting flexibility in 2005 -
source code is available if you want to add more:
http://weblogs.sqlteam.com/billg/archive/2005/11/22/8414.aspx

-Sue

On Mon, 26 Jun 2006 11:06:36 -0500,
Show quote

"jlccd@newsgroups.nospam" <jdamukai***@p2plink.com> wrote:

>Using SQL Server Enterprise Manager we typically select a group of objects
>and scripted them to individual files. We are in the process of migrating
>to SQL Server 2005 and using SQL Server Management Studio. How can we
>accomplish this same task using SQL Server Management Studio?
>
>
>
>What is the trick?
>