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

Tell about MOM Tool(Microsoft Operator Manager)?

1896

What are different types of statement?

990

How to select some specific columns from a table in a query in ms sql server?

987

How to change the name of a database user?

945

Do you know concepts and capabilities of sql server?

1042

What is SQL Azure Data sync?

119

What are the acid properties?

988

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

938

Can a rule be bound to any column of any data type?

945

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1891

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

951

Explain the benefits of user-defined functions?

1039

what is a traditional network library for sql servers? : Sql server database administration

925

Which tcl commands are available on the sql server?

1059

Write a program using SQL queries to find a unique entry in a table.

974