Answer / Rinku Rani

The SP_WHO2 or DBCC INPUTBUFFER command can be used to check locks in Microsoft SQL Server. The SP_WHO2 command displays information about all active processes, including those that hold locks on resources. The DBCC INPUTBUFFER command provides the text of the last executed command by a process holding a lock.

How to assign new column names in a view?

1 Answers  

---

What are the limitation of the Online Index Rebuild Operation?

1 Answers  

---

How to test values returned by a subquery with the in operator?

1 Answers  

---

How can u convert the Date to String?

6 Answers   Microsoft, TCS,

---

If a table does not have a unique index, can a cursor be opened on it?

1 Answers  

---

How to convert a table data in XML format in sql server?

1 Answers  

---

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,

---

How to get @@error and @@rowcount at the same time?

1 Answers  

---

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

1 Answers  

---

how can you check the level of fragmentation on a table? : Sql server administration

1 Answers  

---

What are the types of stored procedures in an sql server?

1 Answers  

---

how to change column into row in sql

4 Answers   ESS,

---