Is there a way to generate SQL for multiple objects through Management
Studio? Also can you generate a drop with a create or a create only?

TIA - Jeff.

UJ (f***@nowhere.com) writes:
Yes. There are even two. One is to right-click the database, and select
Generate Scripts. This will open a wizard that will permit you to set
some scripting options.

The other is to press F7 to get a summary screen and then navigate to
the group of objects you are interesting in. Here you can make multiple
selections, and then right-click and select Script As. In this case,
you don't have access to any options.

The scripting wizard gives you two choices: DROP only and CREATE only.
The option DROP + CREATE is missing, and it no appears that no other
feature from SQL 2000 is more missed by the community than this one.

hi Jeff,
UJ wrote:
in addition to Erland wise advice, you can perhaps have a look at at least 2
other tools..
ScriptIO, available at http://www.sqlteam.com/publish/scriptio/
and my amScript, available at http://www.asql.biz/en/Download2005.aspx

SQL Server Tuning
When was a database last used?
Enterprise Manager Newbie Question
Maintenance Plan on SQL2005
Using dtsrun in stored procedure