sys.sp_change_feed_enable_table (Transact-SQL)
Applies to: 
SQL Server 2022 (16.x)
Azure SQL Database
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.
Note
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:
- The Azure Synapse Link feature for SQL Server instances and Azure SQL Database. For more information, see Manage Azure Synapse Link for SQL Server and Azure SQL Database.
- The Fabric Mirrored Database feature for Azure SQL Database. For more information, see Microsoft Fabric mirrored databases.
- SQL database in Microsoft Fabric. For more information, see SQL database in Microsoft Fabric.
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.