How will u find the query which is running in some other
machine
- 4 Answers
- 6032 Views
- CarrizalSoft Technologies, IBM, I also Faced
- E-Mail Answers
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 |
query processing
Is SET a SQL Keyword?
What is triggers and its types?
How can I change procedure name in sql server?
What is the difference between dataadapter and datareader?
What is public role in sql server?
How does clustered and non clustered index work?
Do you know what guidelines should be followed to help minimize deadlocks?
What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)
What is NOT NULL Constraint in sql server 2012?
What is RMS migrations?
How to create prepared statements using odbc_prepare()?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
