What is Transaction in SQL Server

Question

What is Transaction in SQL Server. What are ACID properties of Transaction ?

Satyapriya Nayak · Answer

Hi Arun ACID (an acronymn for Atomicity Consistency Isolation Durability) is a concept that Database Professionals generally look for when evaluating databases and application architectures. For a reliable database all this four attributes should be achieved. Atomicity is an all-or-none proposition. Consistency guarantees that a transaction never leaves your database in a half-finished state. Isolation keeps transactions separated from each other until they're finished. Durability guarantees that the database will keep track of pending changes in such a way that the server can recover from an abnormal termination. Please refer the below links http://blog.sqlauthority.com/2007/12/09/sql-server-acid-atomicity-consistency-isolation-durability/ http://sqlserverpedia.com/wiki/Transaction_Overview Thanks