Select Multiple Objects in SQL Manager Studio

This is a little tip for developers who are using SQL Server 2005 and, like me, are missing some of the functionality Enterprise Manager used to offer.

It’s often necessary to select multiple objects (tables or stored procedures) to script or drop them. But in the Object Explorer in SQL Management Studio you can only select one item at a time. That’s a pain when you need to publish your new stored procedures on the production database at the end of the day.

After a couple of days I realised that you can use the summary page to multiselect objects. Just use the F7 key to open it and now you can script or delete multiple objects. You can even filter the objects you want to see on the page by using the filter option on the top of the page. That’s very helpful when your database has more than one thousand stored procedures.