hi, I was hoping to find a way to capture/identify the object accessed that correlates to a particular spid.(sysprocesses) I know there are some new dynamic views in SQL2K5, but also need a method for 2000. (Please help w/both) For example, if I see a particular spid, I want to know what object it is accessing. Does this info exist in any system table or function? I know I can do a dbcc inputbuffer to get partial sql, but wanted to get the object name its running against (No profiler please) THX!!