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


Please Help Members By Posting Answers For Below Questions

How to delete a database in ms sql server?

557


Explain what are various ways to enhance the ssrs report?

568


Explain powershell included in sql server 2008?

609


Why truncate is ddl command?

512


How to disable stored procedure sql server?

957






What is cursor in ms sql server?

556


Define tool Manage Statistics in SQL Server 2000 query ?

524


how would you troubleshoot blocking? : Sql server database administration

518


what is the difference between openrowset and openquery?

585


What is the meaning of sql server?

526


What is normalization and what are the advantages of it?

512


If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

668


What is blocking?

567


Can we add a cpu to sql server?

514


Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

550