BUG: SQL-DMO ::GetMemUsage Method Returns Empty String

ID: Q152621

The information in this article applies to:

Microsoft SQL Server versions 6.0, 6.5

BUG #: 15500 (6.00 6.50) (sqlserver)

SYMPTOMS

When you carry out the SQL-DMO database consistency check (DBCC) methods, you can receive empty return values. In most cases this is valid output.

All the SQL-DMO DBCC methods use the WITH NO_INFOMGS option to suppress information level output.

For example, if you use the ::CheckAllocations method and there are no problems, the output remains empty. However, if the processing encounters an error greater than Severity 10, it is placed in the output string.


    strOutput$ = oServer.Databases("pubs").CheckAllocations

CAUSE

In the case of ::GetMemUsage, all output is informational and is less than Severity 10, so it is always suppressed.

WORKAROUND

Run DBCC MemUsage from ISQL or ISQL/W.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 6.00 and 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords : kbbug6.00
Version : 6.0 6.5
Platform : WINDOWS
Issue type :