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
Enables change event streaming at the database level for the current database context. What is change event streaming (preview)? was 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_enable_event_stream
[ ; ]
Arguments
None.
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.