EXCEPTION_ACCESS_VIOLATION

• Nita Reddy

  SSCarpal Tunnel

  Points: 4177

  More actions

  January 20, 2005 at 8:56 am

  #183945

  Hi,

  I am getting this error below when I executive my store proc, my store proc is calling 10 cursur and the input file I am calling from xml file. some time it inserts 1 row and gives me this error. Is there any limitation of cursur

  ODBC: Msg 0, Level 19, State 1

  SqlDumpExceptionHandler: Process 94 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

  SQL 2000 on windows 2000

   

   

• gbn

  SSCertifiable

  Points: 6429

  More actions

  January 21, 2005 at 2:30 am

  #538453

  See the following KB articles.

  Hotifx 961 fixed our issues dating back 2+ years with a 3rd party app, large cursor, linked server. The first hotfix didn't do much.

  We're running HF961 acros all our SQL Servers - stable

  You could of course wait until SP4...

  http://support.microsoft.com/default.aspx?scid=kb;en-us;873446

  http://support.microsoft.com/default.aspx?scid=kb;en-us;837957