Re: Debugging Stored Procedures with Query Analyzer
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 23 Aug 2006 22:10:07 +0000 (UTC)
Stephan Zaubzer (stephan.zaubzer@xxxxxxxxxx) writes:
I have the following problem:
When trying to debug a stored procedure with query analyzer it does not
stop at the first line of code. Instead it runs throug the whole
procedure and I cannot stop it! Am I missing something?
Without being able to interrupt the procedure I want to debug, the
debugger is useless...
Getting the debugger to work requires so much red tape that I have
essentially given up on it. The only exception is possibly if QA and
SQL Server is on the same machine.
First check in Help->About in Query Analyzer which version of QA you have.
Then compare that with @@version. If QA has less than 8.00.760 and
@@version is 8.00.760, you need to upgrade your client tools to SP3.
If you are running Windows XP SP2, with or without firewall enabled,
you need SP4 on both server and client, and configure your firewall
to permit the server to connect to you. (But I don't think you have
this problem, as you usually get an error message as I recall.)
Also, the service account under which SQL Server runs needs some
rights on your machine.
There is a section "Troubleshooting the Transact-SQL Debugger" on
Books Online that may give further tips.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
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
.
- References:
- Debugging Stored Procedures with Query Analyzer
- From: Stephan Zaubzer
- Debugging Stored Procedures with Query Analyzer
- Prev by Date: Re: ANSI Standards
- Next by Date: Re: Debugging Stored Procedures with Query Analyzer
- Previous by thread: Re: Debugging Stored Procedures with Query Analyzer
- Next by thread: Re: Debugging Stored Procedures with Query Analyzer
- Index(es):
Relevant Pages
|
