Selecting Multiple Objects in 2005 Server Management Studio -- sql server clients

Andrew J. Kelly
12/19/2005 1:23:08 PM

You have to do it at the db level. Right click the DB and select "Tasks"
then "Generate Scripts". From here the wizard lets you select all or
individual objects.

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

Alan Waiss
1/10/2006 9:32:01 AM

For simple scripting you could also use the Summary window - this allows
selection of multiple objects.

The other thing I like about it is you can jump directly to your object
simply by pressing the first letter of the name (like Enterprise manger)
since it doesn't add the "dbo."

[quoted text, click to view]

Quinn
2/8/2006 9:46:01 PM

Even though we can still select multiple objects, it scripts all object as
one big file. In SQL 2000, we had the option of generating a separate script
per object or as one big script.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clients

sql server clients : Selecting Multiple Objects in 2005 Server Management Studio