---
title: "What is ACID property of transaction in SQL Server?"  
description: "What is ACID property of transaction in SQL Server?"  
author: "Ashutosh Kumar Verma"  
published: 2021-11-15  
updated: 2021-11-15  
canonical: https://www.mindstick.com/forum/156833/what-is-acid-property-of-transaction-in-sql-server  
category: "mssql server"  
tags: ["sql server", "sql"]  
reading_time: 1 minute  

---

# What is ACID property of transaction in SQL Server?

What is [ACID](https://www.mindstick.com/forum/34725/what-is-acid-properties) [property](https://www.mindstick.com/blog/205/property-notification-in-c-sharp) of [transaction](https://www.mindstick.com/blog/175/transactions-in-database) in [SQL Server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server)?

## Replies

### Reply by Steilla Mitchel

**ACID Property of Transaction in [SQL](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database) [Server](https://www.mindstick.com/articles/43769/what-is-serverless-architecture-is-it-worth-switching-over):**

## Transaction:

A transaction is a group of operations that are treated as just one logical operation.

Example: When we withdraw money from our bank account or deposit money in the bank account.

**ACID Properties:** Transaction has four properties which we call ACID Properties.

1- Atomicity.

2- Consistency.

3- Isolation.

4- Durability.

**Atomicity:** When the transaction is completed in a single step then the transaction is atomic.

**Consistency:** When the transaction takes place, the database is consistence from one state to another.

**Isolation:** When two or more transactions are executed simultaneously, then one transaction does not affect the other transaction.

**Durability:** When a transaction is completely completed then the changes that take place stay in the system permanently. That is, the transaction should be durable.

\


---

Original Source: https://www.mindstick.com/forum/156833/what-is-acid-property-of-transaction-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.