Edit

Share via

sys.sp_help_change_feed_settings (Transact-SQL)

Applies to: SQL Server 2022 (16.x) and later versions Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Warehouse in Microsoft Fabric SQL database in Microsoft Fabric

Provides the provision or deprovision status and information of the Fabric Mirrored Database feature.

This system stored procedure is used for:

Syntax

Transact-SQL syntax conventions

EXECUTE sys.sp_help_change_feed_settings;

Arguments

None

Result set

Column name Data type Description
maxtrans int Maximum transactions to process in each cycle. The default is 10000.
seqno binary(10) Log Sequence Number (LSN) marker to track the last published LSN (log record).
schema_version int Tracks current schema version of database. Determines whether a schema needs to be updated or not on startup.
pollinterval int The frequency that the log is scanned for any new changes in seconds.
reseed_state tinyint Applies to: Fabric Mirrored Database only.

0 = Normal.
1 = The database has started the process of reinitializing to Fabric. Transitionary state.
2 = The database is being reinitialized to Fabric and remains in this state until complete.
destination_type sysname Change event streaming destination type. AzureEventHubsAmqp
AzureEventHubsKafka

Introduced in SQL Server 2025 (17.x) Preview
partition_scheme tinyint Change event streaming partition scheme.

0 = None
1 = Table group.
2 = Table
3 = Column

Introduced in SQL Server 2025 (17.x) Preview
encoding tinyint Change event streaming message encoding.
0 = JSON
1 = Avro Binary

Introduced in SQL Server 2025 (17.x) Preview

Permissions

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

Remarks

If Fabric Mirroring, the source SQL database transaction log is monitored. If the transaction log is observed to be full and the log reuse reason is REPLICATION, the database will automatically be reinitialized to Fabric to allow the transaction log to be truncated. During this special reseed state, a database snapshot is sent to Fabric again, then incremental replication resumes. The reseed_state column in sys.sp_help_change_feed_settings indicates the reseed state.

Related content