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.
]]>