Hi there.

Our ASP.Net application ran into difficulties at the weekend with a strange SQL Server exception. I have copied the first part of the dump text and was wondering if anyone has any ideas what might have caused such an error?

Restarting the SQL Server service cured the problems, but this initial error caused other strange errors in the server log, before a restart, even so far as to fail the integrity check performed as part of our maintenance plan (which worked perfectly fine once the service was restarted!).

We are running on Windows Server 2003 with SQL Server 2000 SP3.

Thanks in advance.
Regards,
Mark

-------------------- start of dump text --------------------
================================================== ===================
BugCheck Dump
================================================== ===================

This file is generated by Microsoft SQL Server 8.00.760
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.

Computer type is AT/AT COMPATIBLE.
Bios Version is IntelR - 42302e31
Phoenix - AwardBIOS v6.00PG
Current time is 16:31:42 10/03/04.
2 Intel x86 level 15, 2806 Mhz processor(s).
Windows NT 5.2 Build 3790 CSD .


Memory
MemoryLoad = 90%
Total Physical = 1023 MB
Available Physical = 93 MB
Total Page File = 1187 MB
Available Page File = 579 MB
Total Virtual = 2047 MB
Available Virtual = 936 MB

*Stack Dump being sent to D:\MSSQL\Data\MSSQL\log\SQLDump0001.txt
* ************************************************** ***************************
**
*
* BEGIN STACK DUMP:
* 10/03/04 16:31:42 spid 53
*
* Exception Address = 0042A86F (RowsetSS::GetColumns + 00000539 Line 0+000000
00)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 595DA000
* Input Buffer 8184 bytes -
* SET CONCAT_NULL_YIELDS_NULL OFF SELECT ToAccounts.Organisation AS ToAcco
* untOrganisation,Transactions.StoredAsFileName,Tran sactions.ToAccountGUid
* ,Transactions.RowGUid,Transactions.Description,Tra nsactions.TransactionD
* ate,Transactions.ObjectType,Transactions.ObjectGUi d,1 as TransactionType
* ,Accounts.Organisation as TransactionFrom,Accounts.Forename+' '+Accounts
* .Surname as ContactName,Accounts.TownCity as TransactionTownCity,Orders.
* OrderNo as Reference,Orders.Status,Transactions.OriginalFilen ame,Transac
* tions.DataFormat,Transactions.DataMessage,Transact ions.DataVersion,Trans
* actions.StatusText,Transactions.ForwardError FROM Transactions WITH (NOL
* OCK,READUNCOMMITTED) INNER JOIN Accounts WITH (NOLOCK,READUNCOMMITTED) O
* N Transactions.SenderAccountGUid = Accounts.RowGUid LEFT JOIN Accounts T
* oAccounts WITH (NOLOCK,READUNCOMMITTED) ON Transactions.ToAccountGUid =
* ToAccounts.RowGUid INNER JOIN Orders WITH (NOLOCK,READUNCOMMITTED) ON Tr
* ansactions.ObjectGUid=Orders.RowGUid WHERE Transactions.ObjectType=1 UNI
* ON SELECT ToAccounts.Organisation AS ToAccountOrganisation,Transactions.
* StoredAsFileName,Transactions.ToAccountGUid,Transa ctions.RowGUid,Transac
* tions.Description,Transactions.TransactionDate,Tra nsactions.ObjectType,T
* ransactions.ObjectGUid,2 as TransactionType,Accounts.Organisation as Tra
* nsactionFrom,Accounts.Forename+' '+Accounts.Surname as ContactName,Accou
* nts.TownCity as TransactionTownCity,Invoices.InvoiceNo AS Reference,Invo
* ices.Status,Transactions.OriginalFilename,Transact ions.DataFormat,Transa
* ctions.DataMessage,Transactions.DataVersion,Transa ctions.StatusText,Tran
* sactions.ForwardError FROM Transactions WITH (NOLOCK,READUNCOMMITTED) IN
* NER JOIN Accounts WITH (NOLOCK,READUNCOMMITTED) ON Transactions.SenderAc
* countGUid = Accounts.RowGUid LEFT JOIN Accounts ToAccounts WITH (NOLOCK,
* READUNCOMMITTED) ON Transactions.ToAccountGUid = ToAccounts.RowGUid INNE
* R JOIN Invoices WITH (NOLOCK,READUNCOMMITTED) ON Transactions.ObjectGUid
* =Invoices.RowGUid WHERE Transactions.ObjectType=2 AND Invoices.Status<>-
* 7 UNION SELECT ToAccounts.Organisation AS ToAccountOrganisation,Transact
* ions.StoredAsFileName,Transactions.ToAccountGUid,T ransactions.RowGUid,Tr
* ansactions.Description,Transactions.TransactionDat e,Transactions.ObjectT
* ype,Transactions.ObjectGUid,3 as TransactionType,Accounts.Organisation a
* s TransactionFrom,Accounts.Forename+' '+Accounts.Surname as ContactName,
* Accounts.TownCity as TransactionTownCity,OrderConfirmations.Confirmatio n
* No AS Reference,OrderConfirmations.Status,Transactions.O riginalFilename,
* Transactions.DataFormat,Transactions.DataMessage,T ransactions.DataVersio
* n,Transactions.StatusText,Transactions.ForwardErro r FROM Transactions WI
* TH (NOLOCK,READUNCOMMITTED) INNER JOIN Accounts WITH (NOLOCK,READUNCOMMI
* TTED) ON Transactions.SenderAccountGUid = Accounts.RowGUid LEFT JOIN Acc
* ounts ToAccounts WITH (NOLOCK,READUNCOMMITTED) ON Transactions.ToAccount
* GUid = ToAccounts.RowGUid INNER JOIN OrderConfirmations WITH (NOLOCK,REA
* DUNCOMMITTED) ON Transactions.ObjectGUid=OrderConfirmations.RowGUid WHER
* E Transactions.ObjectType=3 AND OrderConfirmations.Status<>-7 UNION SELE
* CT ToAccounts.Organisation AS ToAccountOrganisation,Transactions.StoredA
* sFileName,Transactions.ToAccountGUid,Transactions. RowGUid,Transactions.D
* escription,Transactions.TransactionDate,Transactio ns.ObjectType,Transact
* ions.ObjectGUid,Transactions.ObjectType as TransactionType,Accounts.Orga
* nisation as TransactionFrom,Accounts.Forename+' '+Accounts.Surname as Co
* ntactName,Accounts.TownCity as TransactionTownCity,Transactions.Original
* FileName as Reference,Transactions.Status,Transactions.Origina lFilename,
* Transactions.DataFormat,Transactions.DataMessage,T ransactions.DataVersio
* n,Transactions.StatusText,Transactions.ForwardErro r FROM Transactions WI
* TH (NOLOCK,READUNCOMMITTED) INNER JOIN Accounts WITH (NOLOCK,READUNCOMMI
* TTED) ON Transactions.SenderAccountGUid = Accounts.RowGUid LEFT JOIN Acc
* ounts ToAccounts WITH (NOLOCK,READUNCOMMITTED) ON Transactions.ToAccount
* GUid = ToAccounts.RowGUid WHERE Transactions.ObjectGUid='00000000-0000-
* 0000-0000-000000000000' ORDER BY Transactions.TransactionDat
*
*
<snip>