FIX: Access Violation Occurs When You Execute DBCC SHOWCONTIG Followed by Any System Function (308749)

SYMPTOMS

After SQL Server executes a DBCC SHOWCONTIG statement, a SELECT statement from any SQL Server 2000 system function may generate an Access Violation.

The following Transact-SQL command executes DBCC SHOWCONTIG followed by a SELECT from the ::fn_helpcollations system function, which generates an Access Violation in SQL Server:

USE master
GO
DBCC SHOWCONTIG
GO
SELECT * FROM ::fn_helpcollations()
GO
				

The following error message displays if you execute the query in Query Analyzer: The following access violation stack dump appears in the SQL Server error log:

2001-05-30 16:19:13.32 spid51    Using 'sqlimage.dll' version '4.0.5'
Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL\log\SQL00022.dmp

2001-05-30 16:19:13.46 spid51    Error: 0, Severity: 19, State: 0

2001-05-30 16:19:13.46 spid51    SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..

				

Short Stack Dump

00800A9F Module(sqlservr+00400A9F) (RowsetSS::Init(class IMemObj *,class BaseXact *,int,int,int,struct IRowset *,class RowsetUsageDescriptor *,class RowsetExecContext const *,int)+000003E9)


0042794F Module(sqlservr+0002794F) (RowsetSS::WakeUp(class BaseXact *,class RowsetExecContext const *)+00000031)


00427919 Module(sqlservr+00027919) (CQScanRowset::WakeUp(void)+0000008E)


0042D8E9 Module(sqlservr+0002D8E9) (CQScanRowset::Open(unsigned long *)+0000002B)


004C0611 Module(sqlservr+000C0611) (CQScanTableScan::Open(unsigned long *)+0000000E)


00428749 Module(sqlservr+00028749) (CQueryScan::Startup(unsigned long *,class BaseXact *)+00000111)


0042703D Module(sqlservr+0002703D) (CStmtQuery::ErsqExecuteQuery(class CMsqlExecContext *,class CEsComp const *,class CEsComp const *,unsigned long *,int,int)const +000002B5)


00441A34 Module(sqlservr+00041A34) (CStmtSelect::XretExecute(class CMsqlExecContext *)const +0000021C)


004160DB Module(sqlservr+000160DB) (CMsqlExecContext::ExecuteStmts(class ExecutionContext *)+0000027E)


00415765 Module(sqlservr+00015765) (CMsqlExecContext::Execute(class CCompPlan *,class CParamExchange *)+000001C7)


00415410 Module(sqlservr+00015410) (CSQLSource::Execute(class CParamExchange *)+00000343)


00459A54 Module(sqlservr+00059A54) (language_exec(struct srv_proc *)+000003C8)


004175D8 Module(sqlservr+000175D8) (process_commands(struct srv_proc *)+000000E0)


410735D0 Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue *)+00000264)


4107382C Module(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
7800BEA1 Module(MSVCRT+0000BEA1) (_beginthread+000000CE)


77E837CD Module(KERNEL32+000037CD) (TlsSetValue+000000F0)

---------------------------------------------------------------------------