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
- 5248 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
Tell me the use of keyword with encryption. Create a store procedure with encryption?
What is lookup override?
What is sql stored procedure?
What functions can a view be used to performed?
Explain the various types of concurrency problem?
How do you create a data source?
Explain database normalization?
What are commonly used odbc functions in php?
What is key set driven?
What is equi join with example?
How to remove duplicate rows from table except one?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What command is used to delete a table from the database in the sql server and how?
Why use view instead of a table?
What are null values in ms sql server?
