Help us to see sqlserver7 Query error! ! ! ! !

Category: MS-SQL Server -> Foundation Classes Author: a13916582311 Date: 2004-10-27 16:31:17
 
a13916582311
2004-10-27 16:31:17
Previously been used properly, do not know how this will have the following questions!
query is:
select * from memorder where orderno = 'BC_000001'

error is:
Server: Msg 823 , Level 24, State 1, Line 1
I / O error 1453 (Insufficient quota to complete the requested service) detected during read of BUF ; pointer = 0x1172dac0, page ptr = 0x11f06000, pageid = (0x1: 0x531), dbid = 7, status = 0x801, file = C: \ MSSQL7 \ data \ goldcoin_Data.MDF.

Connection Broken

If you only write: select * from memorder not wrong!

Hope you master guiding instructions!

system environment: win2000 Chinese version, sqlserver7.0 English, win2000 locale is English (United States)
mokuiaaaaa
2004-10-27 16:49:24
DBCC SHOWCONTIG ('yourtable', ; 1) WITH FAST
JJJJAAD
2004-10-27 17:05:47
dbcc checktable (memorder)
eyedrops227
2004-10-27 17:17:38
statement now see that there is nothing wrong, reconnect and try again ; or for other conditions try.
still does not work, then you check the hard disk space is sufficient.
randabao
2004-10-27 17:26:19
try use:

sp_spaceused
detect your DATABASE space is inadequate.
there again CHECK your system swap file space PAGEFILE is inadequate.
dawnyboy
2004-10-27 17:44:00
"orderno" whether there is a change.
your database is not running out of space
w242381125
2004-10-27 17:59:10
dbcc checktable (memorder)
wdwsw
2004-10-27 18:18:00
statement now see that there is nothing wrong, reconnect and try again; or for other conditions try.
still does not work, then you check the hard disk space is sufficient.
zjmchn73
2004-10-27 18:21:09
it will not conditional!
sqlserver increment of space is not it?
lhlhlh3
2004-10-27 18:30:14
These commands read have not seen, so if you can write a detailed point then? For example, an example ah!
Thank
qwe1026852757
2004-10-27 18:42:43
These commands I have not read eh! Therefore I would like to see an example master name, okay?
is how to use, where to use ah?
Thank you!
mrtan258
2004-10-27 18:58:58
examination results are as follows, I do not know what is meant by the results!
dbcc checktable (memorder)

DBCC results for 'MEMORDER'.
There are 4942 rows in 276 pages for object 'MEMORDER'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

sp_spaceused

database_name ; ; ; ; database_size unallocated space ;
------------------------------------------- -------------------------------------------------- ------------------------------------------------ -----------------------
goldcoin ; ; ; ; ; 20.06 MB 7.68 ; MB

reserved data index_size unused
-------------------------------- ----------------------------------------
12680 KB 9464 KB 2232 KB 984 KB

And that pagefile how tea ah?
Thank