hi thanks for all the replies. I did the dbcc on production db yesterday, didn't find any error....and no errors from the reboot of yesterday till today.... I think I'll...

Hi jima,

Thanks a lot for your posts. I am loading the last night's db dump to a development server to run dbcc there. I took the dump of production db...

should I apply SQL 'Server 2000 (32-bit) Security Patch MS03-031' or the lasted SP3a??

but on the MS site, it says: If customers have applied SP3, they do not need to...

are there something in english? couldn't read it..........

no, the table was pretty fragmented before re-index. And the db on testing was the same as the 'prod', because I used the dump file of 'prod' to build the...

Yes, it's a batch file. or you can call it command file. simply a text file, but you can name it as test.bat or test.cmd, and run it. the content...

thank you, Steve.

Can you tell me how to get more info? is there a table which you can find user defined errors?

It's a sql application, and the above are the...