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
How to create indexed view?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
Does partitioning help performance?
What are the different types of collation sensitivity?
What is a trigger what are the advantages of trigger?
Explain linked server in sql?
What is the difference between push and pull subscription? : sql server replication
What do you understand by replication in sql server?
Show Practically Sql Server Views are updatable?
Explain having clause?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
can a database be shrunk with users active? : Sql server administration
How to Insert multiple rows with a single insert statement?
Explain the difference between primary keys and foreign keys?