Rediger

sys.sp_remove_object_from_event_stream_group (Transact-SQL)

Applies to: SQL Server 2025 (17.x) Azure SQL Database

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) and Azure SQL Database.

Note

Change event streaming is currently in preview, and has differences in supportability across products. During preview, this feature is subject to change.

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, with no default, 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), with no default, 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.