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

ID: Q152621

The information in this article applies to:
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        :

Last Reviewed: March 27, 1999