Check Database Error (HELP!!!!)

I am trying to process a stocktake, I get to the calculate screen, press commit and it keeps coming up with timeout error (after only 5-6 mins) and quitting out of Store operations manager, so I tried reindexing it, and that completed fine and backed up database which also completed fine so then I then did Store operations admin check database facility and I got the following error Error -2147212540: Table error: Object ID 453576654, index ID 1, partition ID 72057594041925632, alloc unit ID 71805844660813824 (type LOB data). The off-row data node at page (1:2840), slot 18, text ID 235971674112 is not referenced.

I
Reply to
Kirsten
Loading thread data ...

Run the statement

DBCC CHECKDB 'YourDatabase' WITH ALL_ERRORMSGS

cod

Reply to
cod

ops .. this statement is only for check.. before run check, try to make a database backup, and set database in single user mode (no users must be connected to database).. You can loss data from database, or this can be an I/O error from disk ...

cod

Reply to
cod

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.