| title | sp_syscollector_enable_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 | 53ff2b0d-b7da-4e3d-8f3d-35e857bc3720 | ||
| author | stevestein | ||
| ms.author | sstein |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]
Enables the data collector. Because there is only one data collector per server, no parameters are required.
Transact-SQL Syntax Conventions
dbo.sp_syscollector_enable_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 enables the data collector.
USE msdb;
GO
EXEC dbo.sp_syscollector_enable_collector;