November 14, 2007 at 1:36 pm
Hi we have migrated some server from SQL 2000 to SQL 2005.
How do I know that the database which I migrated to SQL 2005 is SQL 2000 compatibilty or SQL 2005 compatibility.
In SQL 2005 I still need to do the backward compatibility to SQL 80 compatibility can I do that if yes then how?
Even when I restore my database from SQL 2000 to SQL 2005 when I did select @@version it shows SQL 9.0 but it should say SQL 8.0 becuase I did not change the compatibility level?
Nita
November 14, 2007 at 1:39 pm
when you restore a 2000 database in a 2005 the compatibility level is automatically 8.0
to verifyit run :
exec sp_dbcmptlevel @dbname = name
* Noel
November 14, 2007 at 1:53 pm
Thanks, I got it 😛
Nita
November 14, 2007 at 2:39 pm
@@version shows an SQL Server version.
To see the version, use sp_dbcmptlevel
If name is specified without version, the SQL Server 2005 Database Engine returns a message displaying the current compatibility level of the specified database.
Syntax:
sys.sp_dbcmptlevel MyDatabaseName
The database that is upgraded from 2000 can have any compatibility level depending on its previous history. I have a database that was upgraded from 6.5 to 7.0 to 2000 to 2005
up to 2000, I kept the Compatibility Level at 6.5 because of the application that was working with this database. When I upgraded from 2000 to 2005 I got a vendor's permission to change the compatibility level to 2005.
Regards,Yelena Varsha
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply