sys.sp_help_change_feed_table (Transact-SQL)

Applies to: SQL Server 2022 (16.x) Azure SQL Database Azure Synapse Analytics Microsoft Fabric

Provides the provision or deprovision status and information of table group and table metadata.

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).

Syntax

Transact-SQL syntax conventions

EXECUTE sys.sp_help_change_feed_table;

Arguments

@table_group_id

The unique identifier of the table group

@table_id

The source table identifier

@source_schema

The source table schema name

@source_name

The source table name

Result set

Column name	Data type	Description
table_group_id	uniqueidentifier	The unique identifier of the table group.
table_group_name	nvarchar(140)	The name of the table group.
schema_name	sysname	The schema name of the original table
table_name	sysname	The name of the original table.
table_id	uniqueidentifier	The source table identifier.
destination_location	nvarchar(512)	URL string of the landing zone folder.
workspace_id	nvarchar(247)	The related Synapse workspace Azure resource ID.
state	nvarchar(50)	The current state of the table.
table_object_id	int	The object ID of the change feed table.

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_settings (Transact-SQL)
• sys.sp_help_change_feed_table_groups (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