Muokkaa

sys.sp_enable_event_stream (Transact-SQL)

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, and has differences in supportability across products. During preview, this feature is subject to change.

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.

Related content

  • Last updated on