Answer Posted / raghu

Consider there are transcations going on 1 row, some one is
trying to update a column in that row while others are
trying to retrive data of same row,while update locks the
row for some period of time others cannot select it, hence
deadlock occurs.

To kill the process is solution. In sql server 2005 use sql
profiler to view the process, in that see the column named
transactions if its value is more than 1 right click and
kill the process.

What is the command to change the recovery model?

999

---

What are difference between Cluster index and Non-Cluster index?

1020

---

What is the order by used for?

965

---

Can I use sql azure as a backup with log shipping or database mirroring?

156

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

887

---

What are the differences between ms sql server & oracle?

992

---

Can you tell me about the concept of ER diagrams?

1018

---

What is the difference between getdate and sysdatetime?

941

---

Explain the architecture of ms sql reporting service?

872

---

How can we delete a table in sql server?

922

---

Explain tables in SQL Azure?

120

---

How do I install only the client tools of sql server 2000?

991

---

What is the report model project?

130

---

Call by value and call by reference in procedure and function, with NOCOPY.

1245

---

What are the tool windows in sql server management studio? : sql server management studio

1015

---