Information générale
Forum:
Microsoft SQL Server
Dear Friends,
I have problem with my sql-server 2000, when I running select statement with order by the messages always come up:
(Select * from Master order by sku)
Server: Msg 823, Level 24, State 12, Line 1
I/O error 2(The system cannot find the file specified.) detected during write at offset 0x0000000b540000 in file 'e:\SQLDB\MSSQL\data\tempdb.mdf'.
Connection Broken
but if I'm not using 'order by' statement, query it's normal, no error what's wrong !
Please Help me
Thanks in advance
Hendry Setiawan
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement