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 


Comments

Popular posts from this blog

Agent Installation on Windows Server. SQL Server (Failover Cluster) target addition in OEM 12c

Oracle 10g/11g Linux:SMS the alert logs ORA- errors generated in timestamp

Oracle 11g: Install Instant Client 11.2.0.3.0 on Linux x86_64 Server.