本文介绍了解决SQLServer2005中无法删除维护计划的问题。首先通过查询获取维护计划的对象ID，然后根据ID从sysmaintplan_plans、sysmaintplan_log和sysmaintplan_subplans表中删除相应的记录。
SQLServer2005的维护计划无法删除的解决方法
1.查看"维护计划"对象的ID
use msdb
select * from sysmaintplan_plans
select * from sysmaintplan_log
select * from sysmaintplan_subplans
2.根据ID号删除相应的"维护计划"
delete from sysmaintplan_plans where id = ' '
use msdb
select * from sysmaintplan_plans
select * from sysmaintplan_log
select * from sysmaintplan_subplans
2.根据ID号删除相应的"维护计划"
delete from sysmaintplan_plans where id = ' '
delete from sysmaintplan_log where plan_id = ' ‘
delete from sysmaintplan_subplans where subplan_id = ' '
delete from sysmaintplan_subplans where subplan_id = ' '
来源:http://blog.youkuaiyun.com/aikesi117/article/details/4815055
扫一扫
8677
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
