Edit

Share via


sys.sp_enable_event_stream (Transact-SQL)

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.