With the availability of the new SQL Server code-named “Denali” CTP1 release, some of you will be moving existing SQL Server 2008 databases into the new server. In order to enable the new spatial features in Denali, you will need to update the database compatibility level for existing SQL Server 2008 databases. For Denali, the compatibility level is 110 and can be set with the following T-SQL:
--Set database compatibility level to SQL Server Code-Named "Denali"
ALTER DATABASE <database name>
SET COMPATIBILITY_LEVEL = 110;
You can get information on the compatibility level of all databases in a given SQL Server instance with the following stored procedure:
For more information on database compatibility levels please see: http://msdn.microsoft.com/en-us/library/bb510680.aspx