VC++6 skips breakpoints with MSSQL 7.0 sp3
Hello Alan,
Please refer to the following KB Article ,
INF: Tips for Debugging Stored Procedures from VC++ [sqlserver]
ID: Q156096
http://www.*-*-*.com/ ;en-us;Q156096
From the article,
"SQL Server must run under a user account, preferably the local
Administrator's user account. When run under the local account, the
breakpoints are ignored and the query is simply executed."
So, Please make sure that SQL Server Running under the LOCAL ADMIN account
( NT Acct ) instead of local-system account.
Also, for general Stroed PRocedure debugging issues please refer to
following articles,
INF: Advanced Debugging of SQL Server Procedures (Q163451)
This article describes the method of debugging a stored procedure that
invokes an extended stored procedure, while also debugging that extended
stored procedure.
PRB: SQL Server Debugging with Visual Studio Service Pack 5 Requires a
Non-System Account (Q281649)
With Visual Studio 6.0 Service Pack 5 or later, SQL Server debugging
cannot be performed when the SQL Server service is set to run under the
Local System account. This is true regardless of whether SQL Server is
local to the computer where
PRB: Debugging Stored Procedure Fails with "Cannot load the DLL
mssdi98.dll, or one of the DLLs it references" Error Message (Q291961)
When you debug a Microsoft SQL Server 7.0 stored procedure from the
Microsoft SQL Server 2000 Query Analyzer, you may receive the following
error message:
Thanks,
Vikrant Dalwale
Microsoft SQL Server Support Professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Get secure ! For info, please visit http://www.*-*-*.com/
Please reply to Newsgroups only.
--------------------
Quote:
>Content-Class: urn:content-classes:message
>Subject: VC++6 skips breakpoints with MSSQL 7.0 sp3
>Date: Tue, 6 Aug 2002 06:47:49 -0700
>Lines: 4
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcI9T9qSPAhdIQETQESlOg4I/F7cUg==
>Newsgroups: microsoft.public.vc.de{*filter*}
>NNTP-Posting-Host: TKMSFTNGXA06 10.201.232.165
>Path: cpmsftngxa08!tkmsftngxs01!cpmsftngxa07
>Xref: cpmsftngxa08 microsoft.public.vc.de{*filter*}:13867
>X-Tomcat-NG: microsoft.public.vc.de{*filter*}
>Are there any known issues that would cause the exact same
>code to halt at breakpoints when run under MSSQL 7.0 sp2
>to skip all breakpoints when this same stored procedure is
>run under MSSQL 7.0 sp3?
