sp-change-feed-create-table-group.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs	monikerRange
sys.sp_change_feed_create_table_group (Transact-SQL)	The sys.sp_change_feed_create_table_group system stored procedure enables the creation of new change feed table group within the current database.	WilliamDAssafMSFT	wiassaf	imotiwala	03/18/2024	fabric	system-objects	reference	sys.sp_change_feed_create_table_group_TSQL sys.sp_change_feed_create_table_group sp_change_feed_create_table_group_TSQL sp_change_feed_create_table_group	sp_change_feed_create_table_group	TSQL	>=sql-server-ver16 || =azuresqldb-current || =fabric || =azure-sqldw-latest

sys.sp_change_feed_create_table_group (Transact-SQL)

[!INCLUDE sqlserver2022-asdb-asa-fabric]

Creates a source to maintain metadata specific to each table group. A table group represents the container for all the individual tables that will be replicated.

Note

This 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?

Syntax

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

EXECUTE sys.sp_change_feed_create_table_group
    @table_group_id
    , @table_group_name
    , @workspace_id
    , @destination_location
    , @destination_credential
[ ; ]

Arguments

@table_group_id

The unique identifier of the table group.

@table_group_name

The name of the table group.

@workspace_id

Azure resourceID for the workspace requesting creation of the new table group.

@destination_location

URL string of the landing zone folder.

@destination_credential

The credential name to access the landing zone.

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

• 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