Explain the dirty pages?

0 Answers  

---

How to generate random numbers with the rand() function in ms sql server?

0 Answers  

---

What is the server name for sql management studio?

0 Answers  

---

Define right outer join in sql server joins?

0 Answers  

---

Explain optimistic and pessimistic concurrency?

0 Answers  

---

What is 'write-ahead log' in sql server 2000 ?

0 Answers  

---

What are the different types of triggers in SQL SERVER?

0 Answers  

---

What is fill factor and pad index?

0 Answers  

---

What type of locking occurs during the snapshot generation? : sql server replication

0 Answers  

---

How to get last system shutdown time in Sql server when restarted system?

1 Answers  

---

what is difference between Enterprise Manager and Query Analyer

6 Answers   CTS,

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---