Need to 'view' the commands a user is running.

SQLBill · Jan 9, 2002

I am using SQL SERVER 2000 Enterprise Edition......

I need to be able to see and save the commands a user is running. DBCC INDEXBUFFER(<spid>) will only give me the last TSQL command the user ran. Is it possible to run a command/script to see all of the commands a user runs??

-Bill

fluteplr · Jan 9, 2002

Set up a trace using the sql profiler.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Need to 'view' the commands a user is running.

SQLBill

MIS

fluteplr

Programmer

Similar threads

Part and Inventory Search

Sponsor