Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
Enables the data collector. Because there's only one data collector per server, no parameters are required.
Transact-SQL syntax conventions
Syntax
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;