In SQL Server 2008 R2, connection strings require a different value for some provider names. The value for the SQL Server Native Client provider is now SQLNCLI10. The value for the OLE DB Provider for Analysis Services is now MSOLAP. To automatically update these provider names, use the Package Upgrade tool to upgrade SQL Server 2005 packages. You can also manually update these names in Business Intelligence Development Studio.
In SQL Server 2005, any subscription rules that generate notifications must insert the notifications into the notification ...
In SQL Server 2005, Notification Services applications cannot have two distributors with the same system name. For each application ...
In SQL Server 2005, syslockinfo and sp_lock may return unexpected values, and may return multiple rows where previous versions ...
In SQL Server 2005, with some exceptions, table hints are supported in the FROM clause of a query only when the hints are ...
In SQL Server 2008 R2, connection strings require a different value for some provider names. The value for the SQL Server ...
In SQL Server 2008 R2, Integration Services has changed its application programming interfaces (APIs). To be compatible with ...
In SQL Server 2008 R2, Integration Services uses Visual Studio Tools for Applications (VSTA) as its script environment. In ...
In SQL Server 2008 R2, the Lookup transformation includes additional capabilities, such as the ability to persist and share ...
In SQL Server 2008, global trace flags set by a session take effect in other sessions immediately. Also, some trace flags ...