sp_who2 followed by DBCC inputbuffer(SPID) will give you the answer.

How will u find the query which is running in some other
machine

Question Posted / baabhu

Answer Posted / baabhu

sp_who2 followed by DBCC inputbuffer(SPID) will give you
the answer.

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is database mirroring?

1117

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

987

Do you know what is openxml in sql server?

1068

What are the types of joins in sql?

1127

Explain Geometry datatype in sql server 2008 with example

989

How to download and install sql server 2005 books online?

1191

what is a transaction and what are acid properties? : Sql server database administration

1024

What are the built in functions in sql server?

985

What do you mean by an execution plan?

1117

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1130

Why can there be only one clustered index and not more than one?

1005

what stored procedure would you use to view lock information? : Sql server administration

973

Which language is supported by sql server?

1013

Why main is user defined function?

1011

Difference between aggregate functions of sql?

1103