Database Compatible Level Archives - Page 2 of 2

SQL SERVER – 2005 – Change Compatibility Level – T-SQL Procedure

January 12, 2008

Six months ago I wrote article about SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility. Yesterday I received an email asking that one of my blog reader is not able to use the sp_dbcmptlevel command with error that database is in use. He has asked me to…

SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility – Part 2 – Management Studio

May 31, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database Compatible Level, SQL Server Management Studio

I have received quite a few request about post I have two days ago SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility, if this can be done using SQL Server Management Studio. It is very simple to do this using Management Studio as well but I still…

SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility

May 29, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database Compatible Level, SQL Scripts, SQL Stored Procedure

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…