MSDE server problem

[ejo]

I have a problem with msde. I cot the following in the eror log:

-------

2004-07-14 12:15:55.67 spid65 Using 'dbghelp.dll' version '4.0.5'
*Stack Dump being sent to C:\Programfiler\Microsoft SQL Server\MSSQL\log\SQLDump0027.txt
2004-07-14 12:15:55.75 spid65 Error: 0, Severity: 19, State: 0
2004-07-14 12:15:55.75 spid65 SqlDumpExceptionHandler: Process 65 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 07/14/04 12:15:55 spid 65
*
* Exception Address = 0044D906
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 327258B7
* Input Buffer 676 bytes -
* SELECT Tur.*, Eier.Navn as EierNavn, Sjåf r.Navn as Sjåf rNavn, Megler.N
* avn as MeglerNavn, Bil.Beskrivelse as BilBeskrivelse FROM Tur LEFT JOIN
* Eier ON Tur.EierNr = Eier.EierNr LEFT JOIN Sjåf r ON Tur.SjåF rNr = Sjå
* f r.Sjåf rNr LEFT JOIN Bil ON Tur.BilNr = Bil.BilNr LEFT JOIN Megler ON
* Tur.MeglerNr = Megler.MeglerNr Where TurNr = 93470
---------

ejo8210

 

[nigelrivett]

Well the innputbuffer shows the command on the spid that caused the problem.
Try running it manually.
If it still fails then run a dbcc checkdb to see if the database is corrupt - also scan the data pages of the tables involved.

If it is ok then it may be a transient problem - something else running that conflicts with sql server maybe.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.