sybase中查询进程当前执行的语句可以使用dbcc sqltext(spid)命令来执行。有时候执行该命令无法显示出语句，可以在之前先执行dbcc traceon(3604)。
1> dbcc traceon(3604)
2> dbcc sqltext(99)
3> go
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
SQL Text: COMMIT
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
阅读(3633) | 评论(0) | 转发(1) |
