Management Studio & Summary Reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael MacGregor - 24 Jul 2008 06:15 GMT

I have Management Studio installed on two different machines, one is
9.00.3042.00 (SP2) running against SQL Standard Edition SP2 and the other
is 9.00.1399.00 running against Enterprise RTM. The former, let's call it
MS2 (for being SP2), has a tab named Object Explorer Details that would
appear to be the same as the Summary tab in the latter, let's call it MS1,
however MS2 does not have a Reports function for accessing information such
as Disk Usage, Object Execution Statistics, User Statictics, etc., as is the
case with MS1.

What happened to Reports? Was the Reports function moved in SP2? Or is this
a difference between Enterprise and Standard editions?

Michael MacGregor
Database Architect

Reply to this Message

Tibor Karaszi - 24 Jul 2008 07:52 GMT

That tab you mention has indeed been renamed from "Summary" to "Object Explorer Details". While that
was done, then reports was also moved off of that window. You, as of sp2, get to the reports from
Object Explorer, but right-clicking a node. Try the databases node for instance, you will find a
"Reports" menu option.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

>I have Management Studio installed on two different machines, one is 9.00.3042.00 (SP2) running
>against SQL Standard Edition SP2 and the other is 9.00.1399.00 running against Enterprise RTM. The
[quoted text clipped - 8 lines]
> Michael MacGregor
> Database Architect

Reply to this Message

Erland Sommarskog - 24 Jul 2008 10:38 GMT

> I have Management Studio installed on two different machines, one is
> 9.00.3042.00 (SP2) running against SQL Standard Edition SP2 and the
[quoted text clipped - 7 lines]
> What happened to Reports? Was the Reports function moved in SP2? Or is
> this a difference between Enterprise and Standard editions?

Right-click on a node in Object Explorer, and you will find an item
Reports.

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Reply to this Message

Michael MacGregor - 24 Jul 2008 14:21 GMT

Thanks Erland.

Why did this change so much?

MTM

Reply to this Message

Aaron Bertrand [SQL Server MVP] - 24 Jul 2008 15:38 GMT

Mainly to support custom reports:

http://blogs.msdn.com/sqlrem/archive/2006/11/20/custom-reports-in-management
-studio.aspx

Also see:

http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4
195B4/WhatsNewSQL2005SP2.htm#BKMK_ManagementStudio

(Scroll down a little to see the part about reports.)

On 7/24/08 9:21 AM, in article #6DSSAZ7IHA.4532@TK2MSFTNGP05.phx.gbl,

> Thanks Erland.
>
> Why did this change so much?
>
> MTM

Reply to this Message

Michael MacGregor - 24 Jul 2008 15:55 GMT

Thanks Aaron.

MTM

Reply to this Message