sys.database_ledger_digest_locations (Transact-SQL)

Applies to: SQL Server 2022 (16.x) Azure SQL Database Azure SQL Managed Instance

Captures the current and the historical ledger digest storage endpoints for the ledger feature.

For more information on database ledger, see Ledger.

Column name Data type Description
path nvarchar(4000) The location of storage digests. For example, a path for a container in Azure Blob storage.
last_digest_block_id bigint The block ID for the last digest uploaded.
is_current bit Indicates whether this is the current path or a path used in the past.

Permissions

Requires the VIEW LEDGER CONTENT permission.

See also