| title | sp_syscollector_disable_collector (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql | ||
| ms.prod_service | database-engine | ||
| ms.reviewer | |||
| ms.technology | system-objects | ||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 9ef4c85d-cca6-452d-94be-2be6f616c3d8 | ||
| author | stevestein | ||
| ms.author | sstein |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
Disables the data collector. Because there is only one data collector per server, no parameters are required.
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;