SQL 2005 - compatiblity mode

[SJohnson4611]

Does anyone know how to set SQL 2005 to 2000 compatibility mode?

Scott

 

[robsuttonjr]

If you just upgraded to 2005 the default compatibility mode is set to 8.0 (2000) but you can change to 9.0 (2005) if you are sure all your T-Sql is compatible. They do this on purpose so you can verify that your converted database is ready for the new 9.0 engine.
(SQL Server 2000 is 8.0 and 2005 is 9.0)

Read this before making any changes:
SQL SERVER 2005 UPGRADE HANDBOOK:

http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

Here is the stored procedure syntax use at your own risk:

http://msdn2.microsoft.com/en-us/library/ms178653(SQL.90).aspx

Regards,

Rob

 

[icemel]

yes, in management studie, right click the database name > properties > options > compatibility level