General information
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only