Did you try to shutdown and restart SQL Server? The temdb'll be recreated on restart.
>
>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 !
>
--sb--