'Current database version not in valid format' error while upgrading a database

Lets not guess. I'd prefere if you find out whats wrong with this.

Fist things first. Make sure you have a valid backup (valid means test a restore somewhere).

Now run CheckDB on the database, or the database restored version. It should not matter.
For reference:
http://msdn.microsoft.com/en-us/library/ms176064(v=sql.100).aspx

Now report back what CheckDB output is, and well take it from there.

Regards Marten

@jimpen: Thanks.

Could you please say how to create installer package for a DB? It could be either Fresh DB install or Upgrade existing DB.

I was really  only on the deployment/upgrade team not the dev team. So take this with a block of salt.

From what I could tell they used the script DB from the SQL management studio, including the baseline data. That would be for a new DB. Then from the baseline the programmers would have to build the various SQL scripts to add/change an object.

Really it is a matter of getting the dev staff to figure out what are the DB changes and what are app changes and the changes needed on both sides.

I know it sounds like I'm hinting for a job. I'm not. I'm a production DBA and know how to  do troubleshooting. If you look in my profile you can find my personal e-mail address. I can forward the info to the developer and you two can figure out costs etc.

Thanks.