Compatibility Level in SQL Server 2008

Compatibility Level is a very nice feature which decides the nature of the database. Considering am having a SQL Server 2000 database. I want this database to be work as a SQL Server 2005 in 2005 environment. Is it possible with out doing actual big migration work?
 
 Yes, it's possible with this option -> Compatibility Level
 
Compatibility Levels in SQL Serve 2008:
     SQL will support 3 versions of database at their each releases. SQL Server 2005 supports (SQL Server 7.0/2000 and 2005). Now, SQL Server 2008 is supporting 3 versions (2000/2005/2008).
****************************************
     Versions          Compatibility Level
****************************************
  SQL Server 2000                 80
  SQL Server 2005                 90
  SQL Server 2008                100
****************************************
 
Right Click on the database -> Properties -> Options -> Compatibility Level
 
Cheers,
Ebook Download
View all
Learn
View all