| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.sp_MSchange_feed_ddl_event (Transact-SQL) |
The sys.sp_MSchange_feed_ddl_event internal system stored procedure handles data definition language events. |
WilliamDAssafMSFT |
wiassaf |
imotiwala |
08/21/2024 |
fabric |
system-objects |
reference |
|
|
|
>=sql-server-ver16 || =azuresqldb-current || =fabric || =azure-sqldw-latest |
[!INCLUDE sqlserver2022-asdb-asa-fabric]
Internal procedure that handles data definition language events.
Note
This internal 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:
- The Azure Synapse Link feature for SQL Server instances and Azure SQL Database. For more information, see Manage Azure Synapse Link for SQL Server and Azure SQL Database.
- The Fabric Mirrored Database feature for Azure SQL Database. For more information, see What is Mirroring in Fabric?
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sys.sp_MSchange_feed_ddl_event
@EventData xml
Internal use only.
0 (success) or 1 (failure).
A user with CONTROL database permissions, db_owner database role membership, or sysadmin server role membership can execute this procedure.
- sys.sp_change_feed_enable_db (Transact-SQL)
- 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: