MS SQL 2005 server Unable to access/create maintenance plans after SQL 2005 SP2 upgrade in a cluster enviroment - SQL
in

Microsoft SQL 2005

MS SQL 2005 server

SQL

Unable to access/create maintenance plans after SQL 2005 SP2 upgrade in a cluster enviroment

Installed the SP2 with no error.

When trying to access/create maintenance plans  the folowing error i displayd

TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
------------------------------
ADDITIONAL INFORMATION:

 

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Invalid column name 'from_msx'.
Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3257&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476

 

 

 

The resolution to this problem was to run the script sysdbupg.sql manually from the INSTALL folder.

 

Dedikerad server

Comments

No Comments
Powered by Community Server (Non-Commercial Edition), by Telligent Systems