A system assertion check has failed. Check the SQL Server error log for details

Hi.
I'm using SQL Server 2005 Express with Win XP SP2 spanish version.
I have a table with 15 columns (13 primary keys) and 150 rows aprox. When i execute the query:

SELECT * FROM MyTable WHERE idIdioma=1034

i get the error:

A system assertion check has failed. Check the SQL Server error log for details

I look it in the log but it says that maybe network is wrong but the database is in my computer.

And if i execute first:
SELECT * FROMMyTable
and after that i execute:
SELECT * FROM MyTable WHERE idIdioma=1034

it works fine.
I readed the document:
http://support.microsoft.com/?scid=kb%3Ben-us%3B915050&x=17&y=14
but it does not work

My Table create script:

CREATE TABLEMyTable (
st INTEGER NOT NULL,
drvAutonomo BIT NOT NULL,
drvSupervisado BIT NOT NULL,
drvdriver BIT NOT NULL,
drvgateway BIT NOT NULL,
drvfw bit NOT NULL,
ceAccesos BIT NOT NULL,
cePresencia BIT NOT NULL,
ceDatosPlanta BIT NOT NULL,
ceAutonomo BIT NOT NULL,
ceSupervisado BIT NOT NULL,
stat BIT NOT NULL,
idIdioma INTEGER NOT NULL,
titulo VARCHAR(128) NOT NULL,
descrip TEXT NOT NULL,

PRIMARY KEY(st, drvAutonomo, drvSupervisado, drvdriver, drvgateway,

drvfw, ceAccesos, cePresencia, ceDatosPlanta, ceAutonomo,

ceSupervisado, stat, idIdioma),
FOREIGN KEY(st, drvAutonomo,

drvSupervisado, drvdriver, drvgateway, drvfw, ceAccesos, cePresencia,

ceDatosPlanta, ceAutonomo, ceSupervisado, stat)
REFERENCES

EventoConacc(st, drvAutonomo, drvSupervisado, drvdriver, drvgateway,

drvfw, ceAccesos, cePresencia, ceDatosPlanta, ceAutonomo,

ceSupervisado, stat)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
FOREIGN KEY(idIdioma)
REFERENCES Idioma(idIdioma)
ON DELETE NO ACTION
ON UPDATE NO ACTION
);

Thanks

[2643 byte] By [Kalay] at [2007-12-26]
# 1
Did you apply service pack 1 for sql2k5?

If yes, please post the entire error message here. Typically, a system assertion means a bug in the engine. You will need to contact Microsoft directly to get any hotfix (if one exists).

oj at 2007-9-4 > top of Msdn Tech,SQL Server,SQL Server Database Engine...
# 2
I downloaded the last version of SQL Server but it does not work....
Kalay at 2007-9-4 > top of Msdn Tech,SQL Server,SQL Server Database Engine...
# 3
Sorry now it works with SP1.
Kalay at 2007-9-4 > top of Msdn Tech,SQL Server,SQL Server Database Engine...
# 4
Now i have SP1 in SQL Server but i have lots of problems with this table, i can not delete all rows, create index, and sometimes i get the asertion chek fail error. I also get the error: "Fatal error 3624 on <date>"...
Kalay at 2007-9-4 > top of Msdn Tech,SQL Server,SQL Server Database Engine...

SQL Server

Site Classified