How to delete a stubborn SQL 2005 Maintenance Plan

Question

Our SQL 2005 server has a Maintenance Plan that cannot be deleted.

When I try and delete it via Management Studio I get the following error:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) -> The SELECT permission was denied on the object 'sysmaintplan_plans', database 'msdb', schema 'dbo'. (Microsoft SQL Server, Error: 229)

Its SQL 2005 Enterprise Edition version 9.0.3042.0

I have been able to modify the plan so that it doesn't do anything, but I can't rename it or delete it.

I have a hunch that this might be something to do with Service Pack 2, as the Maintenance Plan may have been created before SP2 was applied, and I've heard some people had problems with that scenario.

edit: I am logged in as sa

Answer 1

Thanks to SqlACID for the suggestion to fix this (see the question comments)

I had been using Management Studio on a separate machine.

Running Management Studio on the Server itself (and logging in as SA) allowed me to delete the stubborn Maintenance Plan.