SQL Server Compatibility Level Questions

1

Changing Compatability Level from 65 to 80
SQL 2000 (sp4) instance with databases at compatibility level of 65 and 80. Is changing the compatibility level from 65 to 80 actually upgrading the database to 80? What should be done before and after changing the Compatibility level?

Answer Question   |  January 11, 2009  6:06 PM
SQL Server 2000, SQL Server 2000 SP4, SQL Server Compatibility Level, SQL Server database
asked by:
5 pts.

1