SQL Server Management Studio Mulit-select Items to Delete
Countless developers have been annoyed by the fact that you can't hold down shift and select muliple items in SQL Server Management Studio for Microsoft SQL Server 2005. I can guess why MS built it this way, because of the way that the right pane works when you have items selected on the left, it would be hard to provide the context-sensitive properties view for mulitple items (especially if those items were different types such as a table, a stored procedure, and a security permission).
But we're all so used to holding shift and getting multi-select (probably because Enterprise Manager works that way), that it can be frusterating. So here's the way to do it which is more of a "workaround" tip than an actual solution.
SQL Server Management Studio
Just hit F7. That will bring up the Summary window. You also open it by going to the file menu at View -> Summary. You can always multi-select in the right side summary pane and perform a multiple-delete or whatever action you want.
Popular Articles
Last viewed:
- Using Stored Procedures in the Entity Framework with Scalar Return Values
- How to Slipstream Windows XP Service Pack 3 Installation
- C# Programmatically Manage Contacts in Microsoft Outlook
- SQL Create Table Add Description to Column
- Silverlight Memory Leak DataGrid, DataForm, DataTemplate, etc...
- Fixing Relative Paths in C# ASP.NET When Using Url Rewriting

Recent comments
8 hours 51 min ago
23 hours 43 min ago
3 days 11 hours ago
4 days 11 hours ago
6 days 12 hours ago
1 week 2 hours ago
1 week 12 hours ago
1 week 18 hours ago
1 week 22 hours ago
1 week 3 days ago