You need the following in order to use the debugger:
Permissions In order to use the debugger, you must either have DBA authority or be granted permissions in the SA_DEBUG group. This group is added to all databases when they are created.
Source code for Java classes The source code for your application must be available to the debugger. For Java classes, the source code is held on a directory on your hard disk. For stored procedures, the source code is held in the database.
Compilation options To debug Java classes, they must be compiled so that they
contain debugging information. For example, if you are using the Sun
Microsystems JDK compiler javac.exe, they must
be compiled using the -g command-line
option.
