Remove a Utility Control Point (SQL Server Utility)

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This topic describes how to remove a SQL Server utility control point (UCP) from the instance of SQL Server in SQL Server 2017 by using Transact-SQL.

In This Topic

Before You Begin

Limitations and Restrictions

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

  • Before you run this procedure, all managed instances of SQL Server must be removed from the UCP. Note that the UCP is a managed instance of SQL Server. From more information, see Remove an Instance of SQL Server from the SQL Server Utility.

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

  • If the instance of SQL Server where the UCP was removed has a non-Utility data collection set, the UMDW database (sysutility_mdw) will not be dropped by the procedure. If this is the case, the UMDW database (sysutility_mdw) must be dropped manually before the UCP can be created again.



This procedure must be run by a user with sysadmin permissions; the same permissions required to create a UCP.

Using Transact-SQL

To remove a Utility Control Point

  1. Connect to the Database Engine.

  2. From the Standard bar, click New Query.

  3. Copy and paste the following example into the query window and click Execute.

EXEC msdb.dbo.sp_sysutility_ucp_remove;  

See Also

SQL Server Utility Features and Tasks
Use Utility Explorer to Manage the SQL Server Utility
Troubleshoot the SQL Server Utility