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

• Microsoft SQL Server, versions 6.0 and 6.5

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.