| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.sp_change_feed_disable_db (Transact-SQL) |
The sys.sp_change_feed_disable_db system stored procedure disables the SQL change feed at the database level. |
WilliamDAssafMSFT |
wiassaf |
imotiwala |
03/13/2024 |
fabric |
system-objects |
reference |
|
|
|
>=sql-server-ver16 || =azuresqldb-current || =azure-sqldw-latest || =fabric |
[!INCLUDE sqlserver2022-asdb-asa-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.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sys.sp_change_feed_disable_db
[ ; ]
A user with CONTROL database permissions, db_owner database role membership, or sysadmin server role membership can execute this procedure.
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.
- 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: