| title | sp_syscollector_delete_collection_set (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 | 29c63a74-4db4-4068-bd57-9fb519b0c598 | ||
| caps.latest.revision | 18 | ||
| author | JennieHubbard | ||
| ms.author | jhubbard | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Deletes a user-defined collection set and all its collection items.
| Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version). |
Transact-SQL Syntax Conventions
sp_syscollector_delete_collection_set [[ @collection_set_id = ] collection_set_id OUTPUT ]
, [[ @name = ] 'name' ]
[ @collection_set_id = ] collection_set_id
Is the unique identifier for the collection set. collection_set_id is int and must have a value if name is NULL.
[ @name = ] 'name'
Is the name of the collection set. name is sysname and must have a value if collection_set_id is NULL.
0 (success) or 1 (failure)
sp_syscollector_delete_collection_set must be run in the context of the msdb system database.
Either collection_set_id or name must have a value, both cannot be NULL. To obtain these values, query the syscollector_collection_set system view.
System-defined collection sets cannot be deleted.
Requires membership in the dc_admin (with EXECUTE permission) fixed database role to execute this procedure.
The following example deletes a user-defined collection set specifying the collection_set_id.
USE msdb;
GO
EXEC dbo.sp_syscollector_delete_collection_set
@collection_set_id = 4;
Data Collector Stored Procedures (Transact-SQL)
Data Collection
syscollector_collection_sets (Transact-SQL)