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  General SQL Server Forums  New to SQL Server Programming  Accessing "Process Info" via an app

Author  Topic  winshent Starting Member 1 Post Posted - 2009-02-02 : 09:19:40 I am working with sql 2000 I am trying to access all of the "current activity>process info" from microsoft access. I thought, the sproc code in the link below would give me it but it doesnt. I have no problem basing a dataset on sp_lock2 and reading the info, but it doesnt pull all of the data in the process info view under enterprise manager. http://support.microsoft.com/kb/255596 I am new to sql server, but have a few years exp as an access/ excel developer.. any help is much appreciated..