[태그:] SQL Server
-
Resolving REFERENCE Constraint Conflict Error When Deleting SQL Server Maintenance Plan Jobs
When attempting to delete a job in a SQL Server maintenance plan, you may encounter an error message similar to the following: The DELETE statement conflicted with the REFERENCE constraint “FK_subplan_job_id”. The conflict occurred in database “msdb”, table “dbo.sysmaintplan_subplans”, column ‘job_id’. The statement has been terminated. (Microsoft SQL Server, Error: 547) This error message indicates…