Deleting maintenance plan

How do I delete an old maintenance plan that is causing errors in my event
viewer?
EM, Management, Database Maintenance Plans.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"kmd" <kmd@.hotmail.com> wrote in message news:eAyEMCJhEHA.1724@.tk2msftngp13.phx.gbl...
> How do I delete an old maintenance plan that is causing errors in my event
> viewer?
>

DELETE Rouge Statistic from sys.sysindexes

Morning,

I have a stale statistic that I need to remove from the sysindexes table.

It is causing our DB upgrade tool to fail.

In the past, on SQL Server 2000, I could just go into the sysindexes table and delete it.

In SQL Server 2005 of course, no ad hoc catalog changes error prohibits me from doing this.

How can I delete this rouge stat?

Thanks ALL!

What about using DROP STATISTICS?

AMB

|||

Thanks for the info AMB.

SO ... if I have a statistic named '_WA_Sys_name_009508B4'

How do I find what table it is referencing in order to use that table name in the DROP STATISTICS command?

Thanks for your help so far!

J Kusch

|||

Try:

select

object_name([object_id])as table_name,

[name] as stats_name

from

sys.stats

where

[name] like'\_WA\_Sys\_%'escape'\'

AMB

|||

PERFECT!

Thanks a bunch for all the help!

DELETE Rouge Statistic from sys.sysindexes

Morning,

I have a stale statistic that I need to remove from the sysindexes table.

It is causing our DB upgrade tool to fail.

In the past, on SQL Server 2000, I could just go into the sysindexes table and delete it.

In SQL Server 2005 of course, no ad hoc catalog changes error prohibits me from doing this.

How can I delete this rouge stat?

Thanks ALL!

What about using DROP STATISTICS?

AMB

|||

Thanks for the info AMB.

SO ... if I have a statistic named '_WA_Sys_name_009508B4'

How do I find what table it is referencing in order to use that table name in the DROP STATISTICS command?

Thanks for your help so far!

J Kusch

|||

Try:

select

object_name([object_id])as table_name,

[name] as stats_name

from

sys.stats

where

[name] like'\_WA\_Sys\_%'escape'\'

AMB

|||

PERFECT!

Thanks a bunch for all the help!