Utility5:remove UCP

Remove UCP Using TSQL code

EXEC Msdb.dbo.sp_sysutility_ucp_remove;

Limitations and Restrictions

Before the procedure to remove the UCP from the SQL Server Utility, note the following requirements. The stored procedure would run prerequisite checks as part of the operation.

• Before you run this procedure, all managed instances of SQL Server must is removed from the UCP. Note that the UCP is a managed instance of SQL Server.

• This procedure must was run on a computer that is a UCP.

• If the instance of SQL Server where the UCP is removed has a non-utility data collection set, the UMDW database (Sysutili TY_MDW) is not being dropped by the procedure. If This was the case, the UMDW database (SYSUTILITY_MDW) must was dropped manually before the UCP can be created again.

Reference Documentation:

Remove a Utility Control point (SQL Server Utility)

Utility5:remove UCP