sp_syscollector_enable_collector (Transact-SQL)

APPLIES TO: yesSQL Server (starting with 2008) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

Enables 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_enable_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 enables the data collector.

USE msdb;  
GO  
EXEC dbo.sp_syscollector_enable_collector;  

See Also

System Stored Procedures (Transact-SQL)
Data Collection