Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL - Select error
Message
From
26/05/2005 08:32:35
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
SQL - Select error
Miscellaneous
Thread ID:
01017775
Message ID:
01017775
Views:
59
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
Map
View

Click here to load this message in the networking platform