| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.sp_help_change_feed_table_groups (Transact-SQL) |
The sys.sp_help_change_feed_table_groups_groups system stored procedure returns the table group information for Fabric Mirrored Databases. |
WilliamDAssafMSFT |
wiassaf |
imotiwala |
03/12/2024 |
fabric |
system-objects |
reference |
|
|
|
>=sql-server-ver16 || =azuresqldb-current || =fabric || =azure-sqldw-latest |
[!INCLUDE sqlserver2022-asdb-fabric]
Returns metadata that is used to configure change feed table groups.
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?
| Column name | Data type | Description |
|---|---|---|
table_group_id |
uniqueidentifier | Unique identifier of the change feed table group. |
table_group_name |
nvarchar(140) | The name of the table group. |
destination_location |
nvarchar(512) | URL string of the landing zone folder. |
destination_credential |
sysname | The credential name to access the landing zone. |
workspace_id |
nvarchar(247) | The related workspace Azure resource ID. |
synapse_workgroup_name |
nvarchar(50) | The related workspace name. |
enabled |
bit | Tracks if the table group is enabled for change feed. 1 - Yes, 0 - No. |
destination_type |
int | 0 = Azure Synapse Link. 2 = Fabric mirroring. |
A user with CONTROL database permissions, db_owner database role membership, or sysadmin server role membership can execute this procedure.
- sys.sp_help_change_feed (Transact-SQL)
- sys.sp_help_change_feed_table (Transact-SQL)
- sys.sp_help_change_feed_settings (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: