"Erland Sommarskog" wrote:

> JL (J*@discussions.microsoft.com) writes:
> > I am trying to debug an SP in Query Analyzer but after I've specified the
> > input values, as soon as I click on the "debug" button, the debugger will
> > skip all my breakpoints and finish the SP.
> >
> > I would like to debug my SP step-by-step at the breakpoints.  Is there a
> > solution to this?
>
> Yes, but there are so much hassle to get this working, that I've more or
> less given up on using the SQL debugger. PRINT and SELCTs do just as
> well for me.
>
> There is a topic "Troubleshooting the Transact-SQL Debugger" in Books
> Online, but since that text was written the XP SP2 firewall and other
> things have appeared that could complicate matters.
>
> Exactly which version of SQL Server to you have on the server, which
> version of the tools on the client? And which version of Windows do
> you have on the machines? And is the firewall active? In this case, you
> could try opening port 135 on your client for the SQL Server machine.
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>