SmoothDesigners

Version of SQL Server database can be one of the following:

• 60 = SQL Server 6.0
• 65 = SQL Server 6.5
• 70 = SQL Server 7.0
• 80 = SQL Server 2000
• 90 = SQL Server 2005

The sp_dbcmptlevel stored procedure affects behaviors only for the specified database, not for the entire server. sp_dbcmptlevel provides only partial backward compatibility with earlier versions of SQL Server. A database containing an indexed view cannot be changed to a compatibility level lower than 80.

sp_dbcmptlevel
Sets certain database behaviors to be compatible with the specified version of SQL Server.

Example:
—-SQL Server 2005 database compatible level to SQL Server 2000
EXEC sp_dbcmptlevel SampleDB, 80;
GO
—-SQL Server 2000 database compatible level to SQL Server 2005
EXEC sp_dbcmptlevel SampleDB, 90;
GO