sys.sp_change_feed_disable_db (Transact-SQL)
Applies to: 
SQL Server 2022 (16.x)
Azure SQL Database
Azure Synapse Analytics
Warehouse in Microsoft Fabric
SQL database in 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, Microsoft Fabric mirrored databases, and SQL database in Microsoft Fabric.
Note
This system stored procedure is used internally and is not recommended for direct administrative use. Use Synapse Studio or the Fabric portal instead. Using this procedure could introduce inconsistency.
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.