RE: SQL2k debugging broken/problem

Hello,

I have tested the issue on a Windows server 2003 SP1 machine which has SQL
server 2000 SP4 installed. I can use Transact-SQL Debugger to debug the
stored procedure both on local SQL instance and remote instance. So I am
unable to reproduce the issue.

To narrow down the issue, I suggest that you check if you can reproduce the
issue on a known working Windows server 2003 SP1 machine instead of a
virtual PC.

Also, you can follow the steps in the "Troubleshooting the Transact-SQL
Debugger" topic in SQL Books Online(BOL) to troubleshoot the issue.

Please refer to the following article:

280101 INF: Transact-SQL Debugger Limitations and Troubleshooting Tips for
SQL
http://support.microsoft.com/?id=280101

This article describes the limitations of Transact-SQL Debugger in SQL
Server 2000. This article also provides guidelines and directions to
troubleshoot basic problems related to Transact-SQL Debugger. However,
this is not an exhaustive list, and some problems may be specific to your
environment.

I hope the information is helpful.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.





.

Relevant Pages

  • RE: Strange Backup problem
    ... Windows Server 2003 after you install Microsoft SQL Server 2005 CTP ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: High Paging
    ... Windows Server 2003/2000/NT ... > You've done a lot with this system, upgrading the SQL database and the OS ... > Windows Server 2003/2000/NT ...
    (microsoft.public.windows.server.general)
  • Re: SQL 2000 on Win 2003 Server memory limits
    ... Andrew J. Kelly SQL MVP "Scott Riehl" wrote in message ... > I assume this means I still need to enable AWE in SQL 2000 EE to address> more than 4GB?? ... >> Windows Server 2003, Enterprise Edition ...
    (microsoft.public.sqlserver.server)
  • Re: Backup error on Microsoft CMS 2002 SP1A Database
    ... Agent Service Account is the account that will finally run the job, ... General Network Error When You Try to Back up or Restore a SQL Server ... Database on a Computer That Is Running Windows Server 2003 (also apply to ... Then you could use the SQL Agent starting service account to run the backup ...
    (microsoft.public.sqlserver.server)
  • Re: Windows 2003 clustering & SQL Server 2005 clustering
    ... Windows Server Enterprise Edition and SQL Server 2000 Enterprise Edition. ... SQL does not support NLB, do that with your web farm front-end, Cluster SQL ... MVP - Windows Server - Clustering ...
    (microsoft.public.windows.server.clustering)