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
- 5132 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 an inner join?
Explain what is meant by replication of database?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What is spatial and temporal data?
What is dbcc command in sql server?
What is the use of “join” in sql server?
Tell me what do you understand by a view? What does the with check option clause for a view do?
How secure is sql server database?
What are date and time data types in ms sql server?
Can we use where clause with group by?
what are the new features introduced in sql server 2000? : Sql server database administration
What are the different acid properties?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is the largest component inside a field?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
