Preskoči na glavni sadržaj

Ovaj preglednik više nije podržan.

Nadogradite na Microsoft Edge da iskoristite najnovije osobine, sigurnosna ažuriranja i tehničku podršku.

Preuzmite Microsoft Edge Dodatne informacije o preglednicima Internet Explorer i Microsoft Edge
Pročitaj na engleskom Uredi

Ledger documentation

Find documentation about ledger for SQL Server 2022 and Azure SQL

Ledger overview

Overview

  • What is ledger?

Ledger concepts

Concept

  • What is the database ledger?
  • Append-only ledger tables
  • Updatable ledger tables
  • Digest management
  • Database verification
  • Monitor digest uploads

Ledger quickstarts

Quickstart

  • Create an Azure SQL Database with ledger enabled

Using ledger

How-To Guide

  • Create append-only ledger tables
  • Create updatable ledger tables
  • Enable automatic digest storage
  • Migrate data from regular tables to ledger tables
  • Recover ledger database after tampering
  • Verify a ledger table to detect tampering
  • Configure Azure SQL Managed Instance NSG rules to work with Azure Confidential Ledger

Ledger references

Reference

  • Current ledger limitations
  • Ledger whitepaper

Ledger System Catalog Views

Reference

  • sys.database_ledger_blocks (Transact-SQL)
  • sys.database_ledger_transactions (Transact-SQL)
  • sys.database_ledger_digest_locations (Transact-SQL)
  • sys.ledger_table_history (Transact-SQL)
  • sys.ledger_column_history (Transact-SQL)

Ledger Store Procedures

Reference

  • sys.sp_generate_database_ledger_digest (Transact-SQL)
  • sys.sp_verify_database_ledger (Transact-SQL)
  • sys.sp_verify_database_ledger_from_digest_storage (Transact-SQL)
  • sys.sp_copy_data_in_batches (Transact-SQL)

Ledger video references

video

  • Bringing the power of blockchain to Azure SQL Database and SQL Server with ledger | Data Exposed
  • Learn how Lenovo reinforces trust using ledger in Azure SQL Database
bs-latn-ba
Vaši izbori privatnosti
  • Izjava o odricanju od odgovornosti za umjetnu inteligenciju
  • Prethodne verzije
  • Blog
  • Učestvujte u saradnji
  • Privatnost
  • Privatnost zdravstvenih podataka potrošača
  • Uslovi korištenja
  • Zaštićeni znakovi
  • © Microsoft 2026