sys.sp_syscollector_delete_collection_item

Description

Deletes a collection item from a collection set. The unique identifier for the collection item. @collection_item_id , with a default of @collection_item_id must have a value if The name of the collection item. , with a default of an empty string. must have a value if @collection_item_id

Syntax

sp_syscollector_delete_collection_item
[ [ @collection_item_id = ] collection_item_id ]
[ , [ @name = ]
N
'name'
]
[ ; ]

Remarks

Deletes a collection item from a collection set.

The unique identifier for the collection item.

@collection_item_id

, with a default of

@collection_item_id

must have a value if

The name of the collection item.

, with a default of an empty string.

must have a value if

@collection_item_id

(success) or

Examples

Example 1

sp_syscollector_delete_collection_item

Example 2

msdb

Example 3

MyCollectionItem1

Example 4

USE msdb;
GO
EXECUTE sp_syscollector_delete_collection_item @
name
=
'MyCollectionItem1'
;