Microsoft KB Archive/152621

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

Article ID: 152621

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q152621



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: KB152621

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.