July 9, 2002 at 4:52 pm
I ran the following ALTER TABLE statement and it generated the following error. Does anyone know what this is? The strange thing is that I can run similar ALTER TABLE statements on other columns without any problems, but with this one specific column it gives me this error.
ALTER TABLE [dbo].[AdEnroll] ALTER COLUMN AdShiftID INT NULL
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
July 9, 2002 at 10:04 pm
What is the data type of the column, before the alter?
Andy
July 10, 2002 at 7:55 am
integer
July 10, 2002 at 10:43 am
So you're just letting the column be nullable?
Andy
July 10, 2002 at 11:43 am
Tupically there is dump information in the SQL Server logs. Can you post what information you find there related to the error?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
July 15, 2002 at 7:50 am
Sorry about the delay in posting....answers:
1. Yes, I'm just trying to make the column nullable.
2. Here is the dump information from the error log:
SqlDumpExceptionHandler: Process 57 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 07/15/02 09:41:52 spid 57
*
* Exception Address = 005B3371 (CDependList::PersistDependency + 00000011 Line 0+00000000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 0E003000
* Input Buffer 126 bytes -
* ALTER TABLE [dbo].[AdEnroll] ALTER COLUMN AdShiftID INT NULL
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B19FFF 0071a000
* ntdll 77F50000 77FF8FFF 000a9000
* kernel32 77E60000 77F44FFF 000e5000
* ADVAPI32 77DD0000 77E5AFFF 0008b000
* RPCRT4 77CC0000 77D34FFF 00075000
* USER32 77D40000 77DCCFFF 0008d000
* GDI32 77C70000 77CAFFFF 00040000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 77C10000 77C62FFF 00053000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 002A0000 002AFFFF 00010000
* sqlevn70 41080000 41086FFF 00007000
* NETAPI32 71C20000 71C6EFFF 0004f000
* wmi 76D30000 76D33FFF 00004000
* ole32 771B0000 772C9FFF 0011a000
* XOLEHLP 58CA0000 58CA5FFF 00006000
* MSDTCPRX 60DA0000 60DFAFFF 0005b000
* MSVCP60 76080000 760E0FFF 00061000
* MTXCLU 750F0000 75101FFF 00012000
* VERSION 77C00000 77C06FFF 00007000
* WSOCK32 71AD0000 71AD7FFF 00008000
* WS2_32 71AB0000 71AC4FFF 00015000
* WS2HELP 71AA0000 71AA7FFF 00008000
* COMRes 77050000 77114FFF 000c5000
* CLUSAPI 74FC0000 74FCFFFF 00010000
* OLEAUT32 77120000 771AAFFF 0008b000
* RESUTILS 750B0000 750C0FFF 00011000
* USERENV 52880000 52922FFF 000a3000
* mswsock 71A50000 71A8AFFF 0003b000
* DNSAPI 76F20000 76F44FFF 00025000
* winrnr 76FB0000 76FB6FFF 00007000
* WLDAP32 76F60000 76F8BFFF 0002c000
* rasadhlp 76FC0000 76FC4FFF 00005000
* SSNETLIB 42CF0000 42D05FFF 00016000
* SSNMPN70 410D0000 410D5FFF 00006000
* security 71F80000 71F83FFF 00004000
* SECUR32 76F90000 76F9FFFF 00010000
* wshtcpip 71A90000 71A97FFF 00008000
* SSmsLPCn 42CD0000 42CD6FFF 00007000
* ntdsapi 767A0000 767B2FFF 00013000
* CLBCATQ 76FD0000 77047FFF 00078000
* SQLOLEDB 75370000 753DDFFF 0006e000
* MSDART 74C50000 74C6EFFF 0001f000
* COMCTL32 77340000 773CAFFF 0008b000
* comdlg32 763B0000 763F4FFF 00045000
* SHLWAPI 772D0000 77332FFF 00063000
* SHELL32 69800000 69FEDFFF 007ee000
* MSDATL3 60E30000 60E44FFF 00015000
* comctl32 71950000 71A33FFF 000e4000
* oledb32 02BC0000 02C24FFF 00065000
* OLEDB32R 029A0000 029AFFFF 00010000
* xp_logattach 10000000 100D4FFF 000d5000
* ODBC32 02CB0000 02CE0FFF 00031000
* WINSPOOL 73000000 73022FFF 00023000
* odbcint 02DF0000 02E05FFF 00016000
* LMSQLProf 02FB0000 02FDCFFF 0002d000
* sqlsrv32 030F0000 03146FFF 00057000
* SQLUNIRL 5C1B0000 5C1DCFFF 0002d000
* NDDEAPI 75940000 75946FFF 00007000
* sqlsrv32 03150000 03165FFF 00016000
* odbccp32 03190000 031A7FFF 00018000
* DBNETLIB 6D4F0000 6D501FFF 00012000
* crypt32 762C0000 76349FFF 0008a000
* MSASN1 762A0000 762AEFFF 0000f000
* msv1_0 76D10000 76D2CFFF 0001d000
* DBmsLPCn 74CD0000 74CD6FFF 00007000
* xplog70 42EA0000 42EB1FFF 00012000
* xplog70 439D0000 439D3FFF 00004000
* xpstar 410F0000 41135FFF 00046000
* SQLRESLD 42AC0000 42AC6FFF 00007000
* SQLSVC 42C40000 42C56FFF 00017000
* odbcbcp 01790000 01795FFF 00006000
* W95SCM 41140000 4114BFFF 0000c000
* SHFOLDER 76780000 76787FFF 00008000
* SQLSVC 43970000 43975FFF 00006000
* xpstar 439E0000 439E8FFF 00009000
* dbghelp 72A00000 72A2CFFF 0002d000
*
* Edi: 001C0016: 00000000 20000010 02000000 20000000 01770000 EFFF0000
* Esi: 1A59001F: 00038F06 00000100 00003400 00004B00 00004500 00000000
* Eax: 005B336A: 0390EC81 8B560000 648D8D31 E8FFFFFC FFE4EC3F FC6485C7
* Ebx: 00000000:
* Ecx: 0E003000:
* Edx: 1A41D340: 1A41DB28 1A41D518 00000002 00000000 00000000 00000000
* Eip: 005B3371: 8D8D318B FFFFFC64 E4EC3FE8 6485C7FF D0FFFFFC 8300983E
* Ebp: 0299EFE0: 0299F7C8 005B2404 193B41E8 00038F06 00038F06 1A4F9250
* SegCs: 0000001B:
* EFlags: 00010206: 00680074 0043003D 005C003A 00490057 0044004E 0057004F
* Esp: 0299EC40: 1A59001F 00000000 19982030 0299E844 0299EFD8 004022B9
* SegSs: 00000023:
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
* 005B3371 Module(sqlservr+001B3371) (CDependList::PersistDependency+00000011)
* 005B2404 Module(sqlservr+001B2404) (CTableAlter::FAlter+00000A06)
* 005D800B Module(sqlservr+001D800B) (CStmtAlterTable::XretExecute+00000008)
* 0040F403 Module(sqlservr+0000F403) (CMsqlExecContext::ExecuteStmts+000002D9)
* 0040EA95 Module(sqlservr+0000EA95) (CMsqlExecContext::Execute+000001B6)
* 00410159 Module(sqlservr+00010159) (CSQLSource::Execute+00000331)
* 0053C498 Module(sqlservr+0013C498) (language_exec+000003E1)
* 00411099 Module(sqlservr+00011099) (process_commands+000000EC)
* 41073379 Module(UMS+00003379) (ProcessWorkRequests+0000024A)
* 41073071 Module(UMS+00003071) (ThreadStartRoutine+000000BD)
* 77C37E53 Module(MSVCRT+00027E53) (endthread+000000AA)
* 77E802ED Module(kernel32+000202ED) (OpenConsoleW+000000B8)
* -------------------------------------------------------------------------------
July 15, 2002 at 8:03 am
What version of SQL and SP are you running? If 7 and SP 1 or no SP then try SP2 or better, I believe there was a known issue that was corrected in SP2.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
July 15, 2002 at 8:06 am
I am running SP2. (version 8.00.534)
July 15, 2002 at 8:17 am
If this has occurred every time (and not just a one-time anomaly), you may want to contact Microsoft. This may be a genuine bug. I'm not seeing anything in the Knowledge Base akin to this error.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
July 15, 2002 at 8:27 am
FIrst try the action of the change thru EM Table designer to be sure it is not something about your syntax (if EM doesn't work the problem is bigger). Also if problem is consistent try reinstall SP2 before you make a bug report, they will have you do this anyway.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Edited by - antares686 on 07/15/2002 08:32:41 AM
July 15, 2002 at 9:52 am
The error occurs every time I try the statement, and it happens through EM as well. I will try to reinstall SP2 and then contact Microsoft if that doesn't work.
Thanks, guys, for the responses!
SB
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply