SQL Server 2008 compatibility with SQL Server 2005

What is the most effective means to make use of SQL Server 2008 as a growth database, yet make certain that the database works with SQL Server 2005?

0
2019-05-18 22:21:44
Source Share
Answers: 1

This can be done using SQL Enterprise Manager or similar to this:

ALTER DATABASE <database> 
SET COMPATIBILITY_LEVEL = { 80 | 90 | 100 }

Use 90 for 2005 compatibility.

This changes the capability made use of for previous launches, the saved procedure sp_dbcmptlevel .

0
2019-05-21 06:21:55
Source