Export (0) Print
Expand All

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.

NoteNote

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft