How will u find the query which is running in some other
machine
Answer Posted / 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 |
Post New Answer View All Answers
Explain what are various ways to enhance the ssrs report?
Explain about builtinadministrator?
Which tcp/ip port does sql server run on? How can it be changed?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
Why should you use or avoid select * statements?
What is difference between inner join and join?
How to transfer a table from one schema to another?
Distinguish between nested subquery and correlated subquery?
can an automatic recovery be initiated by a user? : Sql server administration
Do you know how to make remote connection in database?
Explain system functions or built-in functions? What are different types of system functions?
How to assign new column names in a view?
what is the system function to get current user's user id? : Sql server database administration
What is 3nf normalization?
Explain filtered indexes benefits?