Using SQL Profiler You can find this tool Start Menu\Programs\Microsoft

How will u find the query which is running in some other
machine

Question Posted / krishna thamisetty

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

Please Help Members By Posting Answers For Below Questions

What is data set in report?

133

Can we do dml on views?

939

What is trigger and different types of Triggers?

1117

Explain about temporary stored procedure?

990

What are the High-Availability solutions in SQL Server and differentiate them briefly?

1123

Explain about Joins?

968

How to restore performance issues and how to check?

1983

What are the basic functions for master, msdb, model, tempdb databases?

1021

Can one drop a column from a table?

1001

Explain datetime2 data type in sal server 2008?

896

Give me any three differences between Truncate and Delete.

1083

Define msdb database?

999

What is db stored procedure?

854

What is difference between index and primary key?

1077

What is a trigger and its types?

962