Behavior Changes to SQL Server Features in SQL Server 2008 R2

This topic describes behavior changes in SQL Server. Behavior changes affect how features work or interact in SQL Server 2008 R2 as compared to earlier versions of SQL Server.

Behavior Changes in SQL Server 2008 R2


Because SQL Server 2008 R2 is a minor version upgrade of SQL Server 2008, we recommend that you also review the content in the SQL Server 2008 section.

Number of CPU for Enterprise edition is changing to 8 CPU

SQL Server 2008 R2 Enterprise supports a maximim of 8 CPUs. This is different from previous versions of SQL Server.

To continue using more than 8 processors, you must upgrade to SQL Server 2008 R2 Datacenter.

If you choose to upgrade to SQL Server 2008 R2 Enterprise, SQL Server uses a maximum of 8 processors.

For more information, see, Features Supported by the Editions of SQL Server 2008 R2.

Behavior Changes in SQL Server 2008

SQL Server Native Client

SQL Server 2008 includes SQL Server Native Client 10.0. For more information about differences in behavior between this version and earlier versions of SQL Server Native Client, see Updating an Application to SQL Server 2008 Native Client from SQL Server 2005 Native Client.

See Also