Sept 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

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

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…
Read More

SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility

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…
Read More
Exit mobile version