Q
Manage Learn to apply best practices and optimize your operations.

Unspecified error after upgrading to Service Pack 4

If you had trouble viewing information using SQL Server 2000's General Database Wizard after upgrading to Service Pack 4, Monitoring and Administration expert Kevin Kline offers a simple way to fix the problem.

We recently updated SQL Server 2000 with Service Pack 4 because an application needed to be upgraded. After the successful installation, I accessed Enterprise Manager to view the General Database Wizard for the MSDB, but no information was returned and I received a message indicating that a runtime error had occurred. I also received an unspecified error. When I attempt to debug, the following is displayed:

 

 szDB = parent.window.objSQLNScontext.GetDisplayName(strContextCookie)

Even though I receive no database information concerning the MSDB database, I can see the tables and views as I drill down. I can also view database info for all other databases in the instance. Do you have any idea how to fix this problem without restoring the database prior to the Service Pack 4 upgrade and having to reapply all upgrades?

Most folks don't realize it, but the service packs also need to be applied to your client installations as well as your server installation. Please go back to your DBA workstations and apply Service Pack 4 to your DBA tools, such as SQL Enterprise Manager, SQL Query Analyzer and SQL Profiler.

 


Do you have comments on this Ask the Expert Q&A? Let us know.
This was last published in September 2005

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close