Friday, February 24, 2012

Can''t management maintenance plans in SQL Mgmt Studio

When I click on the "Maintenance Plans" node in SQL Management Studio, I get an error:

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476


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.3042&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476


BUTTONS:

OK

As you can imagine, the links take me to a "We're sorry... no additional info available" message. Has anyone else seen this, or better yet, resolved it?

--Geoff

I think you need to have SQL 2005 SP2 refer,

http://207.46.236.188/MSDN/ShowPost.aspx?PostID=1757393&SiteID=1

No comments:

Post a Comment