sys.database_ledger_digest_locations (Transact-SQL)

Applies to: SQL Server 2022 (16.x) and later versions 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

• Digest Management
• Configure automatic database digests
• Ledger Overview