sys.sp_help_change_feed_table_groups (Transact-SQL)

Applies to: SQL Server 2022 (16.x) Azure SQL Database Microsoft 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 Microsoft Fabric mirrored databases (Preview).

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.

Permissions

A user with CONTROL database permissions, db_owner database role membership, or sysadmin server role membership can execute this procedure.

Related content

• 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:

• Microsoft Fabric mirrored databases (Preview)
• Microsoft Fabric mirrored databases monitoring
• Explore data in your Mirrored database using Microsoft Fabric

For Azure Synapse Link:

• What is Azure Synapse Link for SQL?

• Manage Azure Synapse Link for SQL Server and Azure SQL Database

• Troubleshoot: Azure Synapse Link for SQL initial snapshot issues