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 command used to recompile the stored procedure at run time?
What is the Control Flow in SSIS
What are the steps you will take to improve the performance of a poor performing query?
What is sql server english query?
what is the information that can be stored inside a bit column? : Sql server database administration
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What are page splits?
find the 3rd max salary
difference between Clustered index and non clustered index ?
What are the advantages of using a stored procedure?
Can store procedure call by user define function in SQL server?
What is xml datatype?