February 17, 2003 at 1:58 am
Query Analyzer's Debugger opens fine for stored procedures on SQL Server 7, but the debugger ignores all breakpoints and always executes the SP completely.
I am puzzled, because the Helpfile says the debugger supports SQL Server 7. I get no error messages either. Maybe I am doing something wrong ?
Is there anything to be installed on the Server-Side to make the debugger work on SQL Server 7 ? Maybe it's a matter of just adding a few system stored procs ???
February 18, 2003 at 8:40 am
What service pack has been applied to the SQL Server 7 installation? Also, is it running under the context of a Windows user (not LocalSystem)?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
February 19, 2003 at 4:08 am
The Server runs 7.00.1077 (i.e.Service Pack 4 plus hot fix 7.00.1077).
The SQLServer Service uses "system account", my client logs in as SA. I have also tried different user log-ins, but none works. The debugger keeps ignoring all breakpoints.
Any thoughts ?
February 19, 2003 at 4:35 am
I just tried myself on SQL 7 SP2, 3 and 4 and none stop. But on SQL 2000 works as should. I checked and found no report of this but being new it may not fully support SQL 7, unfortunately could not test 6.5 for the curious.
Update here but I haven't had a chance to test what is being stated. But open Event Viewer on the box where SQL Server 7 is installed and see if a message from SQLDebugging98 is in the Application log.
If so get the details of what it says.
Edited by - antares686 on 02/19/2003 04:47:08 AM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply