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

Answer Posted / baabhu

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

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to count groups returned with the group by clause in ms sql server?

735


What is acid properties?

771


Explain contrast amongst grouped and non-bunched records?

708


How to return the date part only from a sql server datetime datatype?

768


What does normalization do to data?

720






What is a document index?

765


What is page-level compression?

717


Can foreign key be deleted?

679


What is optimization and its types?

701


Which sql server table is used to hold the stored procedure script?

658


What does null mean?

753


What are the options which must be set to allow the usage of optimistic models?

701


What is a unique index?

673


Is BCNF better than 2NF & 3NF? Why?

796


how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

732