Background
Today, a client suddenly found me and said that my execution plan could not be deleted. Just take a look at it for me.
Then throw me an error message.
I look at this mistake, I feel puzzled,,, this is the connection is not a database instance .... It seems to be remote.
Let the customer remote, I first tried one, the same error occurred.
Analysis
Check the SQL Server version first: SQL Server 2005, and then ask for recent server changes. It was the name of the server that was recently modified.
The previous maintenance plan was to log in to the database and establish a maintenance plan through the computer name +windows authentication method. Now of course it's not connected. Various solutions available on the Web, delete a series of maintenance plan related tables, delete jobs.
However, the following contents of the final maintenance plan still exist. Does not solve this problem.
Solve
Use the following method, simple, direct.
Connect directly to integration Services.
Locate the maintenance plan and delete it directly. Get!
SQL SERVER Work diary--Delete execution plan