sys.sp_remove_object_from_event_stream_group (Transact-SQL)

2025-06-23

Applies to: SQL Server 2025 (17.x) Preview

Removes an object (that is, a table) from the stream group for the change event streaming (CES) feature introduced in SQL Server 2025 (17.x) Preview.

Note

Change event streaming is currently in preview for SQL Server 2025 (17.x) Preview.

Transact-SQL syntax conventions

Syntax

sys.sp_remove_object_from_event_stream_group
    [ @stream_group_name = ] N'stream_group_name'
    , [ @object_name ] = N'schema_name_dot_object_name'

Arguments

[ @stream_group_name = ] N'stream_group_name'

Specifies the name of the event stream group from which you want to remove the table. @stream_group_name is sysname, and can't be NULL.

[ @object_name ] = N'schema_name_dot_object_name'

Specifies the name of the table you want to remove from the specified stream group. @object_name is nvarchar(512), and can't be NULL.

Return code values

0 (success) or 1 (failure).

Permissions

A user with CONTROL database permissions, db_owner database role membership, or sysadmin server role membership can execute this procedure.

Share via