sp_syscollector_disable_collector (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Disables the data collector. Because there is only one data collector per server, no parameters are required.

Applies to: SQL Server (SQL Server 2008 through current version).

Topic link icon Transact-SQL Syntax Conventions

  
dbo.sp_syscollector_disable_collector   

None

0 (success) or 1 (failure)

Defaults to the data collector on the server.

Requires membership in the dc_admin or dc_operator (with EXECUTE permission) fixed database role to execute this procedure.

The following example disables the data collector.

EXEC dbo.sp_syscollector_disable_collector;  

System Stored Procedures (Transact-SQL)
Data Collection

Community Additions

ADD
Show: