sp_syscollector_delete_collection_set (Transact-SQL)
Applies to:
SQL Server
Deletes a user-defined collection set and all its collection items.
Transact-SQL syntax conventions
Syntax
sp_syscollector_delete_collection_set
[ [ @collection_set_id = ] collection_set_id ]
[ , [ @name = ] N'name' ]
[ ; ]
Arguments
[ @collection_set_id = ] collection_set_id
The unique identifier for the collection set. @collection_set_id is int, with a default of NULL
. @collection_set_id must have a value if @name is NULL
.
[ @name = ] N'name'
The name of the collection set. @name is sysname, with a default of NULL
. @name must have a value if @collection_set_id is NULL
.
Return code values
0
(success) or 1
(failure).
Remarks
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 can't be NULL
. To obtain these values, query the syscollector_collection_set
system view.
System-defined collection sets can't be deleted.
Permissions
Requires membership in the dc_admin (with EXECUTE permission) fixed database role to execute this procedure.
Examples
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;
Related content
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho