BUG: SQL-DMO ::GetMemUsage Method Returns Empty String (152621)
The information in this article applies to:
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
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.
| Modification Type: | Major | Last Reviewed: | 10/16/2003 |
|---|
| Keywords: | KB152621 |
|---|
|