New Options in SQL Server Management Studio

If you open the “Tools | Options” menu bar item, you’ll find that we’ve made a few changes. First, you can set new Startup options in the “General” section. My favorite is to start with the new Activity Monitor showing.

Another change is in the “Text Editor | Status Bar Layout and Colors” area. You can change the color of single-server query status bars and multiple-server query status bars.

And speaking of that, there’s another control knob for multi-server queries. In the “Query Results” area you’ll find a new item called “Multiserver Results”, where you can change how the results from a multi-server query. You can include the name of the server and/or your login name to the result set. Not only that, you can choose to combine the results into a single dataset, or break out each server into separate datasets.