Changing Compatibility Mode of MSSQL2005

EXEC sp_dbcmptlevel Northwind, 80;

Changing the compatibility mode of database to the earlier version will prevent you from using the new features of MSSQL2005 such as ranking functions, recursive queries, and etc. In order to change back to MSSQL2005 do following:

EXEC sp_dbcmptlevel Northwind, 90;