#907: Session Manager - selecting a session, add option to display the SQL Text of the session (In Sybase, you can get this with dbcc sqltext (spid) command)

NielsGron reported 2008-01-19T00:17:08Z · last modified 2013-08-09T22:37:28Z

Session Manager - selecting a session, add option to display the SQL Text of the session (In Sybase, you can get this with dbcc sqltext (spid) command)

Dev	ivangron
QA	tariqrahiman

Priority	Major
Complexity	Unknown

Component	DBA-T - Sybase - Session Mngr
Version	14.0

Session Manager - selecting a session, add option to display the SQL Text of the session (In Sybase, you can get this with dbcc sqltext (spid) command)

1 attachment

Screen Shot 2013-07-10 at 11.09.07 AM.png

2013-07-10T18:04:50Z

81 KB

All Comments (5) Change History

NielsGron 2009-10-29T02:00:09Z

dbcc traceon(3604)
dbcc sqltext(15)

SachinPrakash 2013-05-22T20:38:50Z

Ivan - pls investigate and see whether you can get this to work.

ivangron 2013-05-28T14:52:45Z · (edited)

The following commands will be used to extract the last sql command executed by an spid.

dbcc traceon(3604)

dbcc sqltext(spid)

dbcc traceoff(3604)

Restrictions:

a.) User must be 'sa' or 'sa_role' in order to run these commands.

b.) Sybases built in function may truncate the query if its to long.

ivangron 2013-05-28T17:45:17Z

supported added

tariqrahiman 2013-07-10T18:05:17Z

Verified in 14.0.0-beta-62

Search Tips

Aqua Data Studio / nhilam

Session Manager - selecting a session, add option to display the SQL Text of the session (In Sybase, you can get this with dbcc sqltext (spid) command)

1 attachment

Issue #907

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Session Manager - selecting a session, add option to display the SQL Text of the session (In Sybase, you can get this with dbcc sqltext (spid) command)

1 attachment

Issue #907

Completion