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 can't 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:
- What is Mirroring in Fabric?
- Monitor Fabric mirrored database replication
- Explore data in your Mirrored database using Microsoft Fabric
For Azure Synapse Link: