How will u find the query which is running in some other
machine
Answer Posted / yogesh
Start Menu\Programs\Microsoft SQL Server 2005\Performance
Tools\SQL Server Profiler\newtrace
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can you manage sql azure security?
What is clustered index
What is the difference between char and varchar2 datatype in sql?
What is a user-defined function in the sql server and what is its advantage?
What is set nocount on and what is set nocount off?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What is rtm version in sql server?
What does REVERT do in SQL Server 2005?
Why does sql studio use a single registered database repository? : sql server management studio
What is the difference between a local and a global temporary table?
Why do you need a sql server?
What is meant by dirty read?
Explain the various types of concurrency problem?
What is a transact-sql statement?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration