Answer Posted / srivas

A transaction is a logical unit of work in which, all the
steps must be performed or none. ACID stands for Atomicity,
Consistency, Isolation, Durability. These are the properties
of a transaction.

What is the maximum size of column in sql server?

885

---

How to use clusters?

933

---

List all types of constraints in sql server?

1005

---

what is a transaction? : Sql server database administration

986

---

How to download and install sql server 2005 books online?

1170

---

What are the requirements on sql server network connections?

964

---

how can you attach more than 20 ldf files in sql server

1991

---

What are data resources?

903

---

How to call stored procedure using http soap?

1065

---

where can you add custom error messages to sql server? : Sql server administration

1102

---

Explain the difference between functions and stored procedures in sql server?

972

---

How to create a scrollable cursor with the scroll option?

991

---

what information is maintained within the msdb database? : Sql server administration

954

---

Explain trigger classes i.e. Instead of and after trigger?

870

---

Why should one not prefix user stored procedures with ‘sp_’?

1035

---