Microsoft KB Archive/161522

= BUG: Current Activity Blank in Enterprise Manager 6.5 =

Article ID: 161522

Article Last Modified on 8/9/2006

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q161522



BUG #: 1289 (NT: 6.5)



SYMPTOMS
After ensuring the tempdb 'Select into/Bulk copy' option is set to TRUE, the SQL Server Enterprise Manager 6.5 Current Activity will still be blank. If you open an ISQL/W window, connect to the SQL Server's master database, and run the sp_processinfo stored procedure, the following error is returned:

Msg 2812, Level 16, State 4

Stored procedure 'sp_processinfo' not found



CAUSE
During the upgrade or installation of Service Pack 1 for SQL Server 6.5, the Procsyst.sql script is run against the master database. This script builds certain temporary tables in the tempdb database. If 'Select into/Bulk copy' is set to FALSE for the tempdb database when this script is run, the following stored procedures may fail to be created within the master database:

  sp_processinfo sp_dropsegment sp_lockinfo sp_helpsort sp_who2



WORKAROUND
To work around this problem, do either of the following:

 Enable 'Select into/Bulk copy' through Enterprise Manager.

-or-  Run the following statement from a query window:

sp_dboption tempdb, 'Select into/Bulk copy', TRUE

Then rerun the Procsyst.sql script against the master database.

NOTE: If you have installed SQL Server Service Pack 1, run the Procsyst.sql script that is shipped with SQL Server 6.5 Service Pack 1. 



STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server 6.5 Service Pack 1. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: SP1

Keywords: kbbug kbusage KB161522

-

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

© Microsoft Corporation. All rights reserved.