Breaking Changes to SQL Server Features in SQL Server 2008 R2

This topic describes breaking changes in SQL Server. These changes might break applications, scripts, or functionalities that are based on earlier versions of SQL Server. You might encounter these issues when you upgrade. For more information, see Using Upgrade Advisor to Prepare for Upgrades.

Breaking 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.

New Installation parameter required for un-attended installations in SQL Server 2008 R2

Unattended installations using the /Q or /QS parameters must include the /IAcceptSQLServerLicenseTerms parameter. This parameter confirms acceptance of SQL Server license terms. For more information, see How to: Install SQL Server 2008 R2 from the Command Prompt.

Breaking Changes in SQL Server 2008

SMO has been reversioned in SQL Server 2008

Code developed for SQL Server 2005 SMO might not build against SQL Server 2008 without minor modifications. For more information, see Backward Compatibility in SMO.

See Also