Interested to Buy Any Domain ? << Click Here >> for more details...
How can I know what query is executing by by a particural
user? (using sp id or any othe way.)
- 2 Answers
- 5262 Views
- I also Faced
- E-Mail Answers
Answer Posted / prem
DBCC INputbuffer(spid)- Displays the last statement sent
from a client to an instance of Microsoft SQL Server 2005.
First 256 characters only will be displayed.
SQL statements can also be captured by running a profiler.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How the authentication mode can be changed?
Why use “in” clause in sql server?
What are the main sources of data?
Explain filestream storage of sql server 2008?
How to use group functions in the select clause in ms sql server?
How does Report Builder support Analysis Services cubes?
Explain what is use of dbcc commands?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
How do you delete duplicate rows in sql server?
Explain an automatic checkpoint
Explain the etl (extraction, transformation, and loading)?
What are the various Operating system files that every SQL server 2005 database has and what is the purpose.
How do I find query history in sql server?
What are parameterized reports?
Explain can you implement data mining in ssrs?
