only one that i know of.

thanks

select @@version respond with microsoft sql 20000 8.00.2039

select @@version

microsoft sql 2000 8.00

its running both sql200 and sql2005.

my current running databases are running under sql2005

compatibility mode is set to Sql server 2000 (80)

not to sound stupid or anything but can you direct me to a few links for the inplace upgrade? I just made a vmware image of the server and...

ok, i have sql studio 2005 running on my server and within that the instance of the database says I'm running sql server 8.0. ...

that query was within sql studio

microsoft sql server 2000 8.00.2039