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

How to create indexed view?

1101

Which is faster statement or preparedstatement?

999

What is filter index?

989

What is the difference between a function and a trigger?

1119

What command must you use to include the not null constraint after a table has already been created?

1227

Explain what is lock escalation and what is its purpose?

978

What are the authentication modes in sql server? How can it be changed?

1185

Is truncate autocommit?

988

Can we call future method from trigger?

998

What is side by side migration in sql server?

1167

What is tcl in sql server?

1164

How to create user defined functions with parameters?

1289

Why we need to use secondry database file? though, we can do same work using primary database file also.

7001

explain different types of constraints? : Sql server database administration

996

How does recursive cte works in sql server?

1055