SQL2005的维护计划无法删除的解决方法
2016-02-19 10:26
图老师设计创意栏目是一个分享最好最实用的教程的社区，我们拥有最用心的各种教程，今天就给大家分享SQL2005的维护计划无法删除的解决方法的教程，热爱PS的朋友们快点看过来吧！
代码如下：
use msdb
select * from sysmaintplan_plans
select * from sysmaintplan_log
select * from sysmaintplan_subplans
2.根据ID号删除相应的"维护计划"
代码如下：
delete from sysmaintplan_log where plan_id = ' ‘
delete from sysmaintplan_subplans where subplan_id = ' '
delete from sysmaintplan_plans where id = ' '
