| title | sp_syscollector_enable_collector (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/14/2017 | ||
| ms.prod | sql-non-specified | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | 53ff2b0d-b7da-4e3d-8f3d-35e857bc3720 | ||
| caps.latest.revision | 18 | ||
| author | JennieHubbard | ||
| ms.author | jhubbard | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Enables the data collector. Because there is only one data collector per server, no parameters are required.
| Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version). |
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;