How will u find the query which is running in some other
machine
Answer Posted / udhaya
with help of profiler we can find then hostname.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of “join” in sql server?
where the connection string store in the database
What are the key configuration files for sql server reporting services ?
When would you use it?
Explain indexed views and partitioned view with their syntax.
What is set nocount on and what is set nocount off?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
Difference between 2NF &3NF ?
How to compare the top two records using sql?
What is raid, and how it can influence database performance?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What are the restrictions while creating batches in sql server?
What is the difference between deallocate cursor and close cursor?
What are the acid properties?
Why are you getting errors when creating a new odbc dsn?