Skip to content

sp-help-change-feed-table.md

Latest commit

 

History

History
88 lines (66 loc) · 3.8 KB

sp-help-change-feed-table.md

File metadata and controls

88 lines (66 loc) · 3.8 KB
title sys.sp_help_change_feed_table (Transact-SQL)
description The sys.sp_help_change_feed_table system stored procedure provides the provision or deprovision flow status of Azure Synapse Link for SQL or Fabric Mirrored Databases.
author WilliamDAssafMSFT
ms.author wiassaf
ms.reviewer imotiwala, ajayj, randolphwest
ms.date 06/23/2025
ms.service fabric
ms.subservice system-objects
ms.topic reference
ms.custom
ignite-2025
f1_keywords
sys.sp_help_change_feed_table_TSQL
sys.sp_help_change_feed_table
sp_help_change_feed_table_TSQL
sp_help_change_feed_table
helpviewer_keywords
sp_help_change_feed_table
dev_langs
TSQL
monikerRange >=sql-server-ver16 || =azuresqldb-current || =azuresqldb-mi-current || =fabric || =fabric-sqldb || =azure-sqldw-latest

sys.sp_help_change_feed_table (Transact-SQL)

[!INCLUDE sqlserver2022-asdb-asdbmi-asa-fabricmirroredsqldb-fabricsqldb]

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

This system stored procedure is used for:

Syntax

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: 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 tinyint The current state of the table. Valid state values:

1 - Enabled.
2 - Exporting.
3 - Exported.
4 - Active.
5 - Disabled.
6 - Pending Disablement.
7 - Reseeding.
8 - Reseed Notified.
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