How will u find the query which is running in some other
machine
- 4 Answers
- 5546 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 |
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
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
