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 for:
- SQL Server 2025 (preview feature database scoped configuration required).
- Azure SQL Database (preview feature database scoped configuration not required).
- Azure SQL Managed Instance (with the SQL Server 2025 or Always-up-to-date update policy, preview feature database scoped configuration not required). During preview, this feature is subject to change. For current supportability, see Limitations.
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.