How to Script Muplitple SPROCS/VIEWS at one time

In Enterprise Manager one can select several SPROCS/VIEWS using the CONTROL key and then Right-Click to script out those objects. Alternativly, pressing CONTROL-C copies, to the clipboard, the T-SQL to create the selected objects.

SQL Management Studio seems to only allow you to script one object at a time.

Is there a way in SQL Management Studio to select multiple objects and generate create or modify scripts?

[436 byte] By [RobertP] at [2007-12-19]

SQL Server

Site Classified