sys.sp_change_feed_disable_db (Transact-SQL)

Applies to: SQL Server 2022 (16.x) Azure SQL Database Azure Synapse Analytics Microsoft Fabric

Disable the change feed at the database level, and then the metadata for all the associated tables for Azure Synapse Link for SQL. For more information, see Manage Azure Synapse Link for SQL Server and Azure SQL Database.

Syntax

Transact-SQL syntax conventions

sys.sp_change_feed_disable_db
[ ; ]

Permissions

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

Remarks

When the change feed is disabled with active table groups, all connections and schedulers are stopped immediately/forcefully without waiting for the current operations are completed. No new change feed table groups can be created for the database, and all the existing metadata describing the table groups will be deleted without waiting for the current operations to complete. Re-enabling change feed results in clean initializations of all table groups and reseeding of all the data.

You should only execute this stored procedure when unsupported actions or unexpected errors have occurred, that require the Mirroring feature to be disabled manually, and cannot be removed via the Synapse workspace or Fabric portal.

Related content

• sys.sp_help_change_feed (Transact-SQL)
• sys.sp_help_change_feed_table (Transact-SQL)
• sys.sp_change_feed_configure_parameters (Transact-SQL)
• sys.dm_change_feed_log_scan_sessions (Transact-SQL)
• sys.dm_change_feed_errors (Transact-SQL)

For Microsoft Fabric mirrored databases:

• Microsoft Fabric mirrored databases (Preview)
• Microsoft Fabric mirrored databases monitoring
• Explore data in your Mirrored database using Microsoft Fabric

For Azure Synapse Link:

• What is Azure Synapse Link for SQL?
• Manage Azure Synapse Link for SQL Server and Azure SQL Database
• Troubleshoot: Azure Synapse Link for SQL initial snapshot issues