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.

Topic link icon Transact-SQL Syntax Conventions

Syntax


dbo.sp_syscollector_disable_collector   

Arguments

None

Return Code Values

0 (success) or 1 (failure)

Remarks

Defaults to the data collector on the server.

Permissions

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

Examples

The following example disables the data collector.

EXEC dbo.sp_syscollector_disable_collector;  

See Also

System Stored Procedures (Transact-SQL)
Data Collection