Follow-up (For those who might need to walk the same path ):

Scripting the SQL2000 database, through SQL Entreprise Manager :

Right click on MYDBASE, choose "All tasks", then "Generate SQL script"

On...

Ok Gail,

I'm gonna give a try...

Am I supposed to decrypt the SP :

- Before scripting them

- After scripting them

?

Yep, just reran check with ALL_ERRORMSGS, and output is the almost the same: Only difference, of course, is the additional line at the end :

CHECKDB found 0 allocation errors...

Forgot to say a few things :

Yes, Gail, data is critical.

Yes, we've been over it with the customer telling him to pay more attention the next time.

I also think the...

Hi Gail, and thank you,

I'm sure going to check on you link...

About the DBCC you're asking me for :

The series of errors on my first post is indeed the result...

Oups, sorry ! I've just realized I posted at the wrong place. Could some admin, please, put my post on the "data corruption" box ?

Thak you...