sys.sp_syscollector_delete_collection_set

Description

Deletes a user-defined collection set and all its collection items. The unique identifier for the collection set. @collection_set_id , with a default of @collection_set_id must have a value if The name of the collection set. , with a default of @collection_set_id

Syntax

sp_syscollector_delete_collection_set
[ [ @collection_set_id = ] collection_set_id ]
[ , [ @name = ]
N
'name'
]
[ ; ]

Remarks

Deletes a user-defined collection set and all its collection items.

The unique identifier for the collection set.

@collection_set_id

, with a default of

@collection_set_id

must have a value if

The name of the collection set.

, with a default of

must have a

@collection_set_id

(success) or

Examples

Example 1

sp_syscollector_delete_collection_set

Example 2

msdb

Example 3

NULL

Example 4

syscollector_collection_set

Example 5

USE msdb;
GO
EXECUTE dbo.sp_syscollector_delete_collection_set @collection_set_id = 4;