通过应用访问“流程信息”

I am working with sql 2000

我正在使用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.

我试图从微软访问访问所有“当前活动>进程信息”。我想,下面链接中的sproc代码会给我它,但它没有。我没有问题基于sp_lock2上的数据集并读取信息,但它不会在企业管理器下的流程信息视图中提取所有数据。

http://support.microsoft.com/kb/255596

I am new to sql server, but have a few years exp as an access/ excel developer..

我是sql server的新手,但有几年exp作为访问/ excel开发人员..

any help is much appreciated..

任何帮助深表感谢..

i have already posted this on sqlteam. please reply on the sqlteam thread: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=119037

我已经在sqlteam上发布了这个。请回复sqlteam主题:http://www.sqlteam.com/forums/topic.asp?TOPTIC_ID = 119037

1 个解决方案

#1

have you tried this?

你试过这个吗?

exec sp_who2