core.sp_add_collector_type (Transact-SQL)
Applies to: SQL Server
Adds a new entry to the core.supported_collector_types
view in the management data warehouse database. The procedure must be executed in the context of the management data warehouse database.
Transact-SQL syntax conventions
Syntax
core.sp_add_collector_type [ @collector_type_uid = ] 'collector_type_uid'
[ ; ]
Arguments
[ @collector_type_uid = ] 'collector_type_uid'
The GUID for the collector type. @collector_type_uid is uniqueidentifier, with no default value.
Return code values
0
(success) or 1
(failure).
Permissions
Requires membership in the mdw_admin (with EXECUTE permission) fixed database role.
Examples
The following example adds the Generic T-SQL Query collector type to the core.supported_collector_types
view. By default, the Generic T-SQL Query collector type already exists. Therefore, if you run this code on a default installation, you see a message that the collector type already exists.
This code runs successfully if you previously removed the Generic T-SQL Query collector type by using the core.sp_remove_collector_type
stored procedure, and then wanted to re-add it as a registered collector type that can upload data to the management data warehouse.
USE <management_data_warehouse>;
GO
DECLARE @RC INT;
DECLARE @collector_type_uid UNIQUEIDENTIFIER;
SELECT @collector_type_uid = (
SELECT collector_type_uid
FROM msdb.dbo.syscollector_collector_types
WHERE name = N'Generic T-SQL Query Collector Type'
);
EXECUTE @RC = core.sp_add_collector_type @collector_type_uid;
Related content
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें