Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 create indexed view?

985


What is the minimum recommended amount of ram for sql server 2012 enterprise?

886


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

1063


Does partitioning help performance?

886


What are the different types of collation sensitivity?

1054


What is a trigger what are the advantages of trigger?

912


Explain linked server in sql?

1145


What is the difference between push and pull subscription? : sql server replication

1148


What do you understand by replication in sql server?

994


Show Practically Sql Server Views are updatable?

1054


Explain having clause?

908


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?

890


can a database be shrunk with users active? : Sql server administration

950


How to Insert multiple rows with a single insert statement?

999


Explain the difference between primary keys and foreign keys?

943