Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Disables the data collector. Because there is only one data collector per server, no parameters are required.
.gif "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.
USE msdb;
GO
EXEC dbo.sp_syscollector_disable_collector;
See Also
Reference
System Stored Procedures (Transact-SQL)