sp_syscollector_delete_collector_type (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Deletes the definition of a collector type.

||
|-|
|Applies to: SQL Server ( SQL Server 2008 through current version).|

Topic link icon Transact-SQL Syntax Conventions

Syntax


sp_syscollector_delete_collector_type [[ @collector_type_uid = ] 'collector_type_uid' ]  
          , [[ @name = ] 'name' ]  

Arguments

[ @collector_type_uid = ] 'collector_type_uid'
Is the GUID for the collector type. collector_type_uid is uniqueidentifier and must have a value if name is NULL.

[ @name = ] 'name'
Is the name of the collector type. name is sysname and must have a value if collector_type_uid is NULL.

Return Code Values

0 (success) or 1 (failure)

Remarks

Either collector_type_uid or name must have a value, both cannot be NULL.

This procedure will throw an error if collection items of this collection type exist.

Permissions

Requires membership in the dc_admin (with EXECUTE permission) fixed database role to execute this procedure.

Example

This example deletes the Generic T-SQL Query collector type.

USE msdb;  
GO  
EXEC sp_syscollector_delete_collector_type @collector_type_uid = '302E93D1-3424-4be7-AA8E-84813ECF2419';  

See Also

System Stored Procedures (Transact-SQL)
Data Collection