sys.sp_help_change_feed_settings (Transact-SQL)

Applies to: Azure SQL Database 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.

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.

For Microsoft Fabric mirrored databases:

For Azure Synapse Link: