Pages

Monday, September 16, 2013

SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility | Journey to SQL Authority with Pinal Dave

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 AdventureWorks, 80; GO ----SQL Server 2000 database compatible level to SQL Server 2005 EXEC sp_dbcmptlevel AdventureWorks, 90; GO Version of SQL Server database can be one of… Continue Reading...

Source: SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility | Journey to SQL Authority with Pinal Dave