sys.sp_change_feed_disable_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

Removes a table from the change feed.

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_disable_table
    @table_group_id
    , @table_id
GO

Arguments

@table_group_id

Required. Data type is uniqueidentifier.

The unique identifier of the change feed table group that the table belongs to. It's a GUID generated by the initial setup.

@table_id

Required. Data type is uniqueidentifier.

The unique identifier of the link table. It's the GUID generated by the setup flow and passed to the source publisher during provision.

Remarks

The last changes published and synchronized to Azure Synapse can't be guaranteed. To guarantee synchronization between source and target up to a certain time, verify the "last transaction commit time" on the target and then call this procedure.

Permissions

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

Share via