How to Script Muplitple SPROCS/VIEWS at one time | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to Script Muplitple SPROCS/VIEWS at one time

n 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?

Right click the database and chose Tasks | Generate Script. In the wizard you can select the objects you want to script. Simon
Ah, ha! Thanks.
]]>