Sybase, How to check statement which currently executed by spid

Hi,
In sql server dbcc inputbuffer / sql profiler will tell me what currently specific spid does, I will able to know in details what is current statement being executed.
How about in Sybase ?? sp_who is not enough information
motioneyeAsked:
Who is Participating?
 
IncisiveOneConnect With a Mentor Commented:
(Sybase ASE is a much bigger, more feature-rich beast that runs on a variety of plaforms ... quite different to MS SQL.)

It depends on the version, and what options you have installed in the server.

Try, this works on all versions:
> dbcc sqltext (spid)

I trust you know to first exec:
> dbcc traceon (3604)

The SQL buffer size that will be displayed is subject to config parms

Cheers
0
 
shru_0409Commented:
http://www.sybase.com/detail?id=20450
this link may be useful for u
0
 
motioneyeAuthor Commented:
dbcc sqltext new to me :), okay let me try to find out, hmm I'm running on 15.0.2
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
IncisiveOneConnect With a Mentor Commented:
In that case, you can also use:

> sp_showplan <spid>, null, null, null

Cheers

0
 
motioneyeAuthor Commented:
Thanks IncisiveOne, I know sometimes my questions are too  simple for you guys, but this the matter of me to get quick answer as the company direction go with sybase...u will hear more soon.. anyway I have downloadedmost pdf doc from syabse for day learning... thank again for support me
0
 
IncisiveOneCommented:
My pleasure
0
 
aimsupportCommented:
nice.

that is working gud for sybase.
0
All Courses

From novice to tech pro — start learning today.