Debug a single connection

[MCMartin]

It is possible to restrict the debugging in Sybase Central to one user.

What I am looking for, to use it on a productive system, is to restrict the debugging just to one connection. Is that possible? I am looking for a way to debug only the procedures called by a single connection ignoring all calls to these procedures which come from other connections.

[Former Member]

To use the debugger requires either DBA privilege or SA_DEBUG authority, which is how you would restrict the set of users who can use the debugger.

There is no built-in mechanism to limit debugger connections that I am aware of. You could use the IsDebugger connection property to test to see if another connection is already using the debugger - for example, you could execute an event periodically to see if more than one such connection exists, and then report the existence of more than one connection as a message in the console window.

[MCMartin]

Thanks for the answer, but I haven't meant a way to prevent multiple debugger sessions. I am looking for a way to debug only the procedures called by a single connection ignoring all calls to these procedures which come from other connections. Sorry for that.

[Breck_Carter]

Can you set a breakpoint &&SPID = n where n is the connection number?

http://dcx.sybase.com/index.html#1201/en/dbusage/editing-breakpoints-procdebug.html