Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to:
SQL Server 2025 (17.x) Preview
Enables change event streaming at the database level for the current database context. Change event streaming (CES) was introduced in SQL Server 2025 (17.x) Preview.
Note
Change event streaming is currently in preview for SQL Server 2025 (17.x) Preview.
Transact-SQL syntax conventions
Syntax
sp_enable_event_stream
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.