Database Guide › SQL Server Guidelines › Upgrading SQL Server › Upgrading to SQL Server 2005 › Set the Compatibility Level

Previous Topic: Upgrading to SQL Server 2005

Next Topic: Support for Snapshot Isolation Locking
Set the Compatibility Level

After upgrading your database engine to SQL Server 2005, you must set the compatibility level for your CA DLP databases. By default, these are left at the ‘SQL Server 2000’ compatibility level.

To set the compatibility level, you need to edit the properties of the CA DLP database. For example, in the SQL Server Enterprise Manager, go to the Database Properties screen set the Compatibility Level to ‘SQL Server 2005 (90)’.

More information:

Controlling Disk Space Usage