Monday, June 18, 2012

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.
Check Changes compatibility_level