Post reply

SqlDumpExceptionHandler

  • July 13, 2005 at 7:56 am

    #109996

    Hi,

    I was debugging a stored procedure on my local sql server

    and when the second sp was called I got an error:

    SqlDumpExceptionHandler: Process 2608 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server

    I searched the Internet for explanation and found an article at

    http://support.microsoft.com/default.aspx/kb/309435

    They recommended to:

    start SQL Server 2000 in minimal configuration mode by using Sqlservr.exe with the -c -f

    and in Query Analyzer run:

    sp_configure 'locks ', 0

    go

    reconfigure with override

    go

    When I ran this last command it showed an error message:

    'locks' option does not exist. It maybe an advanced option...

    Did anybody have the same problems?

    Thanks,

    Robert

  • July 14, 2005 at 10:38 am

    #574485

    If you want to turn advanced options on use this:

    USE master

    go

    Exec sp_configure 'show advanced option', '1'

    go

    You should get a message saying that the option changed from 0 to 1.

    Then try running sp_configure by itself and see if your connection info is listed.  You should be able to change the setting if this works.

    Another way to change the connections property easily is using Enterprise Manager.  Just right click on the instance, select, Properties and go to the Connections tab.  You can set the maximum concurrent connections in the upper right box.  Hope this helps. 

    My hovercraft is full of eels.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply