What stored procedure would you use to view lock information?

0 Answers  

---

Does sql server 2000 clustering support load balancing?

0 Answers  

---

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

3 Answers   RND Soft, Wipro,

---

A trigger can reference objects outside the current database? State true or false.

0 Answers  

---

what are triggers? : Sql server database administration

0 Answers  

---

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

0 Answers  

---

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

0 Answers   TCS,

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

0 Answers  

---

Do you know what is blocking?

0 Answers  

---

How many non clustered indexes there can be on table ?

0 Answers  

---

What is SubQuery in SQL Server 2008

0 Answers   HCL,

---

What is for xml in sql server?

0 Answers  

---