Bemærk
Adgang til denne side kræver godkendelse. Du kan prøve at logge på eller ændre mapper.
Adgang til denne side kræver godkendelse. Du kan prøve at ændre mapper.
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.