Merk
Tilgang til denne siden krever autorisasjon. Du kan prøve å logge på eller endre kataloger.
Tilgang til denne siden krever autorisasjon. Du kan prøve å endre kataloger.
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.