A system assertion check has failed. Check the SQL Server error log for details
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: And if i execute first: it works fine. My Table create script: PRIMARY KEY(st, drvAutonomo, drvSupervisado, drvdriver, drvgateway, drvfw, ceAccesos, cePresencia, ceDatosPlanta, ceAutonomo, ceSupervisado, stat, idIdioma), drvSupervisado, drvdriver, drvgateway, drvfw, ceAccesos, cePresencia, ceDatosPlanta, ceAutonomo, ceSupervisado, stat) EventoConacc(st, drvAutonomo, drvSupervisado, drvdriver, drvgateway, drvfw, ceAccesos, cePresencia, ceDatosPlanta, ceAutonomo, ceSupervisado, stat) Thanks
I look it in the log but it says that maybe network is wrong but the database is in my computer.
and after that i execute:
SELECT * FROM MyTable WHERE idIdioma=1034
I readed the document:
http://support.microsoft.com/?scid=kb%3Ben-us%3B915050&x=17&y=14
but it does not work
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,
FOREIGN KEY(st, drvAutonomo,
REFERENCES
ON DELETE NO ACTION
ON UPDATE NO ACTION,
FOREIGN KEY(idIdioma)
REFERENCES Idioma(idIdioma)
ON DELETE NO ACTION
ON UPDATE NO ACTION
);

