In the Object Browser right click on the stored procedure you want to debug and select Debug from the Context menu. For details go to 'Transact-SQL Debugger window' and select 'Starting the Debugger' in the BOL.

>
>I would like to debug some code within SQL Query Analyser but I do not know how to activate the debugger.
>How do I access the debugger?
>