Answer / suvendu

SELECT *
FROM Master.dbo.sysprocesses
WHERE DBID NOT IN (1,2,3,4) -- Master, Tempdb, Model, MSDB
AND spid > 50
ORDER BY spid DESC

Answer / prem

DBCC INputbuffer(spid)- Displays the last statement sent
from a client to an instance of Microsoft SQL Server 2005.

First 256 characters only will be displayed.


SQL statements can also be captured by running a profiler.

What is difference between index and primary key?

0 Answers  

---

what is syntex second or third highest salary. thanks & Regards Dhirendra sinha

7 Answers  

---

How many types of Outer Joins?What are they?

1 Answers  

---

What is stored procedures?

0 Answers  

---

what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

---

Find first and last day of current month in sql server

0 Answers  

---

I have student marks in a student table. I need second highest mark .Then what will the query for this?

37 Answers   NetCore, Patni, SAP Labs, Temenos, Wipro,

---

What is Transaction?

2 Answers  

---

How do you know which index a table is using?

4 Answers  

---

Is sql different from sql server?

0 Answers  

---

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,

---

Does windows server 2016 come with sql server?

0 Answers  

---