How will u find the query which is running in some other
machine
Answers were Sorted based on User's Feedback
Answer / baabhu
sp_who2 followed by DBCC inputbuffer(SPID) will give you
the answer.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / krishna thamisetty
Using SQL Profiler
You can find this tool
Start Menu\Programs\Microsoft SQL Server 2005\Performance
Tools\SQL Server Profiler
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / yogesh
Start Menu\Programs\Microsoft SQL Server 2005\Performance
Tools\SQL Server Profiler\newtrace
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / udhaya
with help of profiler we can find then hostname.
Is This Answer Correct ? | 0 Yes | 0 No |
what is the difference between openrowset and openquery?
If the job running very slow what is the action you do
HOW TO RENAME A COLUMN NAME
which table keeps the locking information? : Sql server administration
How to create an identity column?
How many types of TRIGGERS are there in MS SQL Server?
8 Answers CarrizalSoft Technologies, TCS, United Healthcare,
What function does a database engine serve in the sql server?
What is the need for indexing?
what is the query and condition to delete datas in sql server.
Explain what are db_options used for?
How to list all user defined functions in the current database?
is there a column to which a default can't be bound? : Sql server database administration