Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 tracing transaction of an appliaction or user

Author  Topic 

Mehdi
Yak Posting Veteran

64 Posts

Posted - 2010-03-13 : 00:36:22
Hi,
I want to trace queries run by the user or application

for example
Transaction1 :Insert,Insert,Update,Select,Select.
Transaction2:SElect,Select,Delete,Update
Transaction3:delete,update,select.
....

I need to get the sequence of transactions including the four operations for a specific user or program,
thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-03-13 : 01:16:39
you can do that via SQL profiler

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

Mehdi
Yak Posting Veteran

64 Posts

Posted - 2010-03-13 : 05:32:38
hi,i need to get the insert select,update and delete operation of transactions...which events I should take

i need to get Insert,update,.. of transactions...however i just tried sqlprofilerexpress edittion..
Go to Top of Page
   

- Advertisement -