none
devenv.exe APPCRASH while trying to debug SQL2005 SP in VS2008

    Question

  • Hi 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
    Friday, February 12, 2010 11:39 AM

All replies

  • Hi 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, February 15, 2010 3:38 AM
  • 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:

    - <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    - <System>
      <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>
    - <EventData>
      <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>

    - <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    - <System>
      <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>
    - <EventData>
      <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>

    - <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    - <System>
      <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>
    - <EventData>
      <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 SP1

    Installed Edition: Professional

    Microsoft Visual Basic 2008   91605-270-6567891-60684
    Microsoft Visual Basic 2008

    Microsoft Visual C# 2008   91605-270-6567891-60684
    Microsoft Visual C# 2008

    Microsoft Visual C++ 2008   91605-270-6567891-60684
    Microsoft Visual C++ 2008

    Microsoft Visual Studio 2008 Tools for Office   91605-270-6567891-60684
    Microsoft Visual Studio 2008 Tools for Office

    Microsoft Visual Web Developer 2008   91605-270-6567891-60684
    Microsoft Visual Web Developer 2008

    Crystal 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

    Monday, March 15, 2010 5:09 PM