您现在的位置是：网站首页> 编程资料编程资料
SQL2005的维护计划无法删除的解决方法_mssql2005_
2023-05-27
408人已围观
简介 SQL2005的维护计划无法删除的解决方法_mssql2005_
1.查看"维护计划"对象的ID
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 = ' '
复制代码 代码如下:
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 = ' '
相关内容
- 分页存储过程（一）使用sql2005的新函数构造分页存储过程_mssql2005_
- sqlserver 通用存储过程分页代码(附使用ROW_NUMBER()和不使用ROW_NUMBER()两种情况性能分析)_mssql2005_
- sqlserver FOR XML PATH 语句的应用_mssql2005_
- SqlServer 2005/2008数据库被标记为“可疑”的解决办法_mssql2005_
- SQL2005 高效分页sql语句_mssql2005_
- 关于SQLServer2005的学习笔记 XML的处理_mssql2005_
- SqlServer 2005 简单的全文检索_mssql2005_
- SqlServer 2005的排名函数使用小结_mssql2005_
- SQLServer 2005数据库连接字符串 连接sql2005必备资料_mssql2005_
- 简单有用的SQL脚本 (行列互转,查询一个表内相同纪录等)_mssql2005_
