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

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

Question Posted / chaithanya

4 Answers
6911 Views
CarrizalSoft Technologies, IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / baabhu

sp_who2 followed by DBCC inputbuffer(SPID) will give you
the answer.

Is This Answer Correct ?

4 Yes

0 No

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

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

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

Answer / yogesh

Start Menu\Programs\Microsoft SQL Server 2005\Performance
Tools\SQL Server Profiler\newtrace

Is This Answer Correct ?

1 Yes

0 No

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

Answer / udhaya

with help of profiler we can find then hostname.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More SQL Server Interview Questions

what is the importence of the trigger in sqlserver2000?

1 Answers ATI,

How do I partition a table in sql server?

0 Answers

How do you know which index a table is using?

4 Answers

hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end

0 Answers

what is performance tunning in sql server ? explain.

1 Answers Thomson Reuters,

what is maximum size of temp db?

4 Answers iSoft,

What is the correct order of the logical query processing phases?

0 Answers

What is table level trigger?

0 Answers

what is database replication? : Sql server database administration

0 Answers

What is clustered vs nonclustered index?

0 Answers

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

0 Answers

What should be the fill factor for indexes created on tables? : sql server database administration

0 Answers

For more SQL Server Interview Questions Click Here