hi, when i execute a store procedure, the sql server return a access eorror,
like:
2003-08-11 15:48:29.04 spid23 Using 'sqlimage.dll' version '4.0.5'
Stack Dump being sent to C:\MSSQL7\log\SQL00012.dmp
2003-08-11 15:48:31.07 spid23 Error: 0, Severity: 19, State: 0
2003-08-11 15:48:31.07 spid23 SqlDumpExceptionHandler: Process 23
generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
terminating this process.
.
****************************************************************************
***
*
* BEGIN STACK DUMP:
* 08/11/03 15:48:31 spid 23
*
* Exception Address = 0041395A (CXVariant::CopyDeep + 59)
* Exception Code = c0000005 E
* Access Violation occurred reading address 00000000
* Input Buffer 1090 bytes -
* d e c l a r e @. P 1 v a r c h a r ( 2 5 5 )
* s e t @. P 1 = ' '
* d e c l a r e @. P 2 v a r c h a r ( 2 5 5 )
* s e t @. P 2 = ' '
* d e c l a r e @. P 3 v a r c h a r ( 2 5 5 )
* s e t @. P 3 = ' '
* d e c l a r e @. P 4 i n t
* s e t @. P 4 = 0
* e x e c s p _ ...
does anyone know why and how? thank a lot.
lee.Acess violations are generally caused by bugs in SQL Server code... Ensure
you are up to date on service packs, then open a call to MS PSS...
"lee" <freesearcher18@.hotmail.com> wrote in message
news:#pJwoqHYDHA.1280@.tk2msftngp13.phx.gbl...
> hi, when i execute a store procedure, the sql server return a access
eorror,
> like:
> 2003-08-11 15:48:29.04 spid23 Using 'sqlimage.dll' version '4.0.5'
> Stack Dump being sent to C:\MSSQL7\log\SQL00012.dmp
> 2003-08-11 15:48:31.07 spid23 Error: 0, Severity: 19, State: 0
> 2003-08-11 15:48:31.07 spid23 SqlDumpExceptionHandler: Process 23
> generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is
> terminating this process.
> .
>
****************************************************************************
> ***
> *
> * BEGIN STACK DUMP:
> * 08/11/03 15:48:31 spid 23
> *
> * Exception Address = 0041395A (CXVariant::CopyDeep + 59)
> * Exception Code = c0000005 E
> * Access Violation occurred reading address 00000000
> * Input Buffer 1090 bytes -
> * d e c l a r e @. P 1 v a r c h a r ( 2 5 5 )
> * s e t @. P 1 = ' '
> * d e c l a r e @. P 2 v a r c h a r ( 2 5 5 )
> * s e t @. P 2 = ' '
> * d e c l a r e @. P 3 v a r c h a r ( 2 5 5 )
> * s e t @. P 3 = ' '
> * d e c l a r e @. P 4 i n t
> * s e t @. P 4 = 0
> * e x e c s p _ ...
> does anyone know why and how? thank a lot.
> lee.
>
>|||Also search the MS web site... I found this ( perhaps it applies)
http://support.microsoft.com/default.aspx?scid=kb;en-us;174512
"lee" <freesearcher18@.hotmail.com> wrote in message
news:#pJwoqHYDHA.1280@.tk2msftngp13.phx.gbl...
> hi, when i execute a store procedure, the sql server return a access
eorror,
> like:
> 2003-08-11 15:48:29.04 spid23 Using 'sqlimage.dll' version '4.0.5'
> Stack Dump being sent to C:\MSSQL7\log\SQL00012.dmp
> 2003-08-11 15:48:31.07 spid23 Error: 0, Severity: 19, State: 0
> 2003-08-11 15:48:31.07 spid23 SqlDumpExceptionHandler: Process 23
> generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server
is
> terminating this process.
> .
>
****************************************************************************
> ***
> *
> * BEGIN STACK DUMP:
> * 08/11/03 15:48:31 spid 23
> *
> * Exception Address = 0041395A (CXVariant::CopyDeep + 59)
> * Exception Code = c0000005 E
> * Access Violation occurred reading address 00000000
> * Input Buffer 1090 bytes -
> * d e c l a r e @. P 1 v a r c h a r ( 2 5 5 )
> * s e t @. P 1 = ' '
> * d e c l a r e @. P 2 v a r c h a r ( 2 5 5 )
> * s e t @. P 2 = ' '
> * d e c l a r e @. P 3 v a r c h a r ( 2 5 5 )
> * s e t @. P 3 = ' '
> * d e c l a r e @. P 4 i n t
> * s e t @. P 4 = 0
> * e x e c s p _ ...
> does anyone know why and how? thank a lot.
> lee.
>
>
No comments:
Post a Comment