PRB: Current Activity in SEM May Not Be Displayed

Last reviewed: April 15, 1997
Article ID: Q149695

The information in this article applies to:

Microsoft SQL Server, version 6.0

SYMPTOMS

The current activity display window under SQL Enterprise Manager (SEM) may be blank.

CAUSE

SQL Server uses Tempdb for storing certain temporary results for displaying the current activity graph by creating certain temporary objects. If the Select-Into/Bulkcopy option for Tempdb is switched to False, the Server is not able to create those objects and hence the user activity window may appear blank.

RESOLUTION

Set the Select-Into/Bulkcopy option to True for the (Tempdb)Temporary Databases and restart SQL Enterprise Manager.

Additional query words: sem sql6
Keywords : kbtool SSrvEntMan
Version : 6.0
Platform : WINDOWS
Issue type : kbprb

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 15, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.