Microsoft SQL Server 2000/2005:Change Database compatibility Level When Restore Database Backup from lower version to higher version.
1.Check Database Compatibility Level. select name,compatibility_level from sys.databases where name like ' %DBNAME% ' Current version is sql server 2000 where compatibility_level=80 EXEC sp_dbcmptlevel DBNAME , 90;--Set SQL Version 2000 to 2005. GO Check Changes compatibility_level About Me