Cursor in sp_who and sp_lock

taker2001

I have a long-running transaction in my application which include "Cursor", the question is, I can not find out the exactly "Cursor" in the transation because it's provided by a third-party vendor.

So I ran sp_lock and sp_who, outout as below:

-- sp_lock
fid spid loid locktype table_id page row dbname class context
----------- ----------- ----------- -------- ----------- ----------- ----------- ------ ----- -------
0 435 870 Sh_intent 23 0 0 yest Non Cursor Lock
0 435 870 Sh_intent 24 0 0 yest Non Cursor Lock
0 435 870 Sh_intent 1533504690 0 0 yest Cursor Id 28508161
0 435 870 Sh_intent 1565504804 0 0 yest Cursor Id 28508161


-- sp_who

fid spid status loginame origname hostname blk_spid dbname cmd block_xloid
----------- ----------- ------ -------- -------- -------- -------- ------ --- -----------
0 435 running actuate actuate cs2 0 yest OPEN CURSOR 0



Is it possible to find out what's "Cursor Id 28508161"?

I've tried dbcc sqltext(435) but the result is not what I want, anybody help? Many thank!

chuxu

dbcc cursorinfo(NULL,<cursor id>,<spid of owner>)     12.5的版本试了，可以。

taker2001

谢谢!很好用!

但这个dbcc 命令好像不是官方的 我在Sybase网站,文档里都找不到这个命令. 会不会有不好的影响?