To use the debugger, you need:
Permissions—You must either have DBA authority or be granted permissions in the SA_DEBUG group. This group is automatically 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, the Java classes must be compiled using the -g command-line option.