sys.sp_change_feed_enable_table (Transact-SQL)

2025-05-19

Applies to: SQL Server 2022 (16.x) and later versions Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Warehouse in Microsoft Fabric SQL database in Microsoft Fabric

Stored procedure to enable the creation of a new table to an existing table group.

Caution

This system stored procedure is used internally and isn't recommended for direct administrative use. Use Synapse Studio or the Fabric portal instead. Using this procedure could introduce inconsistency.

This system stored procedure is used for:

Syntax

Transact-SQL syntax conventions

sys.sp_change_feed_enable_table
    @table_group_id
    , @table_id
    , @source_schema
    , @source_name
[ ; ]

Arguments

@table_group_id

The unique identifier of the table group.

@table_id

The unique identifier for the change feed table generated during setup workflow.

@source_schema

The source table schema name.

@source_name

The source table name.

Permissions

A user with CONTROL database permissions, db_owner database role membership, or sysadmin server role membership can execute this procedure.

Share via