Disassociates the specified maintenance plan from the specified database.
sp_delete_maintenance_plan_db [ @plan_id = ] 'plan_id' ,
[ @db_name = ] 'database_name'
[@plan_id =] 'plan_id'
Specifies the maintenance plan ID. plan_id is uniqueidentifier.
[@db_name =] 'database_name'
Specifies the database name to be deleted from the maintenance plan. database_name is sysname.
Return Code Values
0 (success) or 1 (failure)
sp_delete_maintenance_plan_db must be run from the msdb database.
The sp_delete_maintenance_plan_db stored procedure removes the association between the maintenance plan and the specified database; it does not drop or destroy the database.
When sp_delete_maintenance_plan_db removes the last database from the maintenance plan, the stored procedure also deletes the maintenance plan.
Only members of the sysadmin fixed server role can execute sp_delete_maintenance_plan_db.
Deletes the Northwind database, previously added with sp_add_maintenance_plan_db.
EXECUTE sp_delete_maintenance_plan_db N'FAD6F2AB-3571-11D3-9D4A-00C04FB925FC', N'Northwind'