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
- 5347 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
What is difference between equi join and natural join?
what is package and it uses and how can u call a package
What is the cpu pressure?
What does it mean to manipulate data?
Write a SQL command to insert and update only a particular field?
How do we know if any query is retrieving a large amount of data or very little data?
What are the differences between stored procedure and the dynamic sql?
What is the filtered index?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
Where sql server user names and passwords are stored in sql server? : sql server database administration
ow to bring suspect mode datbase online from scratch
What are sub reports?
What is dknf in normalization form?
Explain the commands in sql server?
What are the main differences between #temp tables and @table variables and which one is preferred?
