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 use user defined functions in expressions?

1089

Can two different columns be merged into single column? Show practically?

1064

How are the unique and primary key constraints different?

1073

what do you understand by change data capture?

1013

What is an indice?

1034

What is shared lock?

901

What are the types of dml?

978

What is an entity-relationship diagram (erd)?

1210

What do you understand by physical_only option in dbcc checkdb?

979

Explain can you implement data mining in ssrs?

158

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

914

Do you know what are pages and extents? : SQL Server Architecture

993

How do I edit a procedure in sql server?

954

Tell me what is sql profiler?

1026

how to overcome kernel isssues

1625