devenv.exe APPCRASH while trying to debug SQL2005 SP in VS2008
-
Friday, February 12, 2010 11:39 AMHi all
I'm trying to debug a (SQL2005) stored procedure from VS2008. When I enable SQL Server debugging and breakpoint the SP I want, then start debugger after some loading of the application I get an Internal Error from VS and it closes.
I've had limited success in that if I try and debug another SP that gets called very early on it will indeed breakpoint a few times then die, so the breakpointing appears to be working but also by enabling debugging and breakpointing other SPs it appears to be crashing VS2008. If I turn off "SQL Server" debug option (or leave it on with no breakpoints set) then it doesn't cause an internal error.
Is this a know problem or are there any workarounds?
Thanks
---
Description
Faulting Application Path: C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\devenv.exe
Problem signature
Problem Event Name: APPCRASH
Application Name: devenv.exe
Application Version: 9.0.30729.1
Application Timestamp: 488f2b50
Fault Module Name: sqlde.dll
Fault Module Version: 9.0.21022.8
Fault Module Timestamp: 47316195
Exception Code: c0000005
Exception Offset: 00027c1f
OS Version: 6.1.7600.2.0.0.256.4
Locale ID: 2057
Extra information about the problem
LCID: 1033
Bucket ID: 886808976
All Replies
-
Monday, February 15, 2010 3:38 AMModeratorHi Reg,
I can't find any known issue similar to this one.
The exception code of the crash indicates that it is caused by an access violation error, which is too generic to troubleshoot.
The only thing special here is the locale id and LCID are different in the error log. 2057 is for UK and 1033 is for US. Have you installed different locales components in Visual Studio?
Can you test if the same error occurs when you debugging on other machine?
Here are some suggestions:
Install same locale to avoid conflicts
Apply latest SP on SQL server and VS
Hope it helps.
Hongye Sun [MSFT]
MSDN Subscriber Support in Forum
If you have any feedback on our support, please contact msdnmg @ microsoft.com
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
See what's happening in MSDN forum? Follow us at Twitter. -
Monday, March 15, 2010 5:09 PM
At last I found someone with the same exasperating issues!
I've been having the .NET crash for some time (requiring devenv.exe to be killed manually and restarted) when trying to debug with breakpoints. I did a complete Windows Update the other day, and now I'm getting the sqlde.dll errors - previously only the .NET error would be seen.
I didn't realize this might be an SQL breakpoint problem, as far as I know I am only setting breakpoints in the C# code. Now I'll check to ensure that only C# breakpoints are present, and play around with disabling SQL debugging.
I had trouble gettting T-SQL debugging via VS2008 to work due to domain permissions issues (it wouldn't find the domain name server), so I am logged in remotely by RDP as a local user instead.
Event Log:<Provider Name="Application Error" /><EventID Qualifiers="0">1000</EventID><Level>2</Level><Task>100</Task><Keywords>0x80000000000000</Keywords><TimeCreated SystemTime="2010-03-15T16:43:55.000Z" /><EventRecordID>137954</EventRecordID><Channel>Application</Channel><Computer>xxx</Computer><Security /></System><Data>devenv.exe</Data><Data>9.0.30729.1</Data><Data>488f2b50</Data><Data>sqlde.dll</Data><Data>9.0.21022.8</Data><Data>47316195</Data><Data>c0000005</Data><Data>00027c1f</Data><Data>8ec</Data><Data>01cac45424787d26</Data></EventData></Event>
<Provider Name="Application Error" /><EventID Qualifiers="0">1000</EventID><Level>2</Level><Task>100</Task><Keywords>0x80000000000000</Keywords><TimeCreated SystemTime="2010-03-15T16:44:01.000Z" /><EventRecordID>137955</EventRecordID><Channel>Application</Channel><Computer>xxx</Computer><Security /></System><Data>devenv.exe</Data><Data>9.0.30729.1</Data><Data>488f2b50</Data><Data>sqlde.dll</Data><Data>9.0.21022.8</Data><Data>47316195</Data><Data>c0000005</Data><Data>00027c1f</Data><Data>8ec</Data><Data>01cac45424787d26</Data></EventData></Event>
<Provider Name=".NET Runtime" /><EventID Qualifiers="0">1023</EventID><Level>2</Level><Task>0</Task><Keywords>0x80000000000000</Keywords><TimeCreated SystemTime="2010-03-15T16:44:20.000Z" /><EventRecordID>137960</EventRecordID><Channel>Application</Channel><Computer>xxx</Computer><Security /></System><Data>.NET Runtime version 2.0.50727.3603 - Fatal Execution Engine Error (735B10D2) (0)</Data></EventData></Event>
Windows System Information is:
OS Name Microsoft® Windows Server® 2008 Standard
Version 6.0.6001 Service Pack 1 Build 6001
Other OS Description Not Available
OS Manufacturer Microsoft Corporation
System Name GM-VOD1
System Manufacturer VMware, Inc.
System Model VMware Virtual Platform
System Type x64-based PC
Processor Intel(R) Xeon(R) CPU E5405 @ 2.00GHz, 1995 Mhz, 1 Core(s), 1 Logical Processor(s)
Processor Intel(R) Xeon(R) CPU E5405 @ 2.00GHz, 1995 Mhz, 1 Core(s), 1 Logical Processor(s)
BIOS Version/Date Phoenix Technologies LTD 6.00, 1/30/2008
SMBIOS Version 2.31
Windows Directory C:\Windows
System Directory C:\Windows\system32
Boot Device \Device\HarddiskVolume1
Locale United States
Hardware Abstraction Layer Version = "6.0.6001.18000"
User Name xxx
Time Zone Eastern Daylight Time
Installed Physical Memory (RAM) 3.99 GB
Total Physical Memory 3.75 GB
Available Physical Memory 500 MB
Total Virtual Memory 7.67 GB
Available Virtual Memory 4.47 GB
Page File Space 4.04 GB
Page File C:\pagefile.sys
VS2008 version info is:
Microsoft Visual Studio 2008
Version 9.0.30729.1 SP
Microsoft .NET Framework
Version 3.5 SP1Installed Edition: Professional
Microsoft Visual Basic 2008 91605-270-6567891-60684
Microsoft Visual Basic 2008Microsoft Visual C# 2008 91605-270-6567891-60684
Microsoft Visual C# 2008Microsoft Visual C++ 2008 91605-270-6567891-60684
Microsoft Visual C++ 2008Microsoft Visual Studio 2008 Tools for Office 91605-270-6567891-60684
Microsoft Visual Studio 2008 Tools for OfficeMicrosoft Visual Web Developer 2008 91605-270-6567891-60684
Microsoft Visual Web Developer 2008Crystal Reports AAJ60-G0MSA4K-68000CF
Crystal Reports Basic for Visual Studio 2008
Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB944899) KB944899
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/944899.Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB945282) KB945282
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/945282.Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946040) KB946040
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946040.Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946308) KB946308
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946308.Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946344) KB946344
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946344.Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB946581) KB946581
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946581.Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947171) KB947171
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947171.Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947173) KB947173
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947173.Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947180) KB947180
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947180.Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947540) KB947540
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947540.Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB947789) KB947789
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947789.Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB948127) KB948127
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/948127.Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB953256) KB953256
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/953256.Hotfix for Microsoft Visual Studio 2008 Professional Edition - ENU (KB958502) KB958502
This hotfix is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/958502.Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB945140) KB945140
This service pack is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/945140.Microsoft Visual Studio 2008 Professional Edition - ENU Service Pack 1 (KB947888) KB947888
This service pack is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947888.Update for Microsoft Visual Studio 2008 Professional Edition - ENU (KB956453) KB956453
This update is for Microsoft Visual Studio 2008 Professional Edition - ENU.
If you later install a more recent service pack, this update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/956453.
SQL Server version info is:
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 8.0.6001.18882
Microsoft .NET Framework 2.0.50727.3603
Operating System 6.0.6001
