To change compatibility level in SQL Server
To set compatibility for a DB in SQL Server 2005:
exec sp_dbcmptlevel dbname, {80|90|100}
To set compatibility for a DB in SQL Server 2000:
exec sp_dbcmptlevel dbname, {80|90|100}
To set compatibility for a DB in SQL Server 2000:
ALTER DATABASE AdventureWorks SET COMPATIBILITY_LEVEL = 90;
To set compatibility for a DB in SQL Server
No comments:
Post a Comment