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

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