Microsoft sql server 2008

Bug: #50003840 (SQL Hotfix) Microsoft distributes Microsoft SQL Server 2008 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release. Symptoms Consider the following scenario. You install the release version of one of the following editions: Microsoft SQL Server 2008 Standard x86 or x64 edition Microsoft SQL Server 2008 Developer x86, x64, or IA-64 edition Microsoft SQL Server 2008 Enterprise x86, x64, or IA-64 edition Microsoft SQL Server 2008 Workgroup x86 or x64 edition Microsoft SQL Server 2008 Web x86 or x64 edition You install the SQL Server 2008 Client Tools. However, you do not have SQL Server 2008 Integration Services installed. When you create and then execute a maintenance plan, you receive the following error message in the job history: The SQL Server Execute Package Utility requires Integration Services to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services. The package execution failed. The step failed. Resolution Service pack information To resolve this problem, obtain the latest service pack for SQL Server 2008. For more information, click the following article number to view the article in the Microsoft Knowledge Base: 968382How to obtain the latest service pack for SQL Server 2008 Cumulative update information The fix for this issue was first released in Cumulative Update 3. For more information about how to obtain this cumulative update package for SQL Server 2008, click the following article number to view the article in the Microsoft Knowledge Base: 960484 Cumulative update package 3 for SQL Server 2008Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base: 956909 The SQL Server 2008 builds that were released after SQL Server 2008 was released Workaround To work around this issue, install the Integration Services component from one of the following editions: SQL Server 2008 Standard x86 or x64 edition SQL Server 2008 Developer x86, x64, or IA-64 edition SQL Server 2008

Software developers can use to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2008 Analysis Services. This provider implements both the OLE DB specification and the specification’s extensions for online analytical processing (OLAP) and data mining.Note: Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider requires Microsoft Core XML Services (MSXML) 6.0, also available on this page.X86 Package(SQLServer2008_ASOLEDB10.msi) X64 Package (SQLServer2008_ASOLEDB10.msi)Microsoft SQL Server 2008 Command Line Utilities The SQLCMD utility allows users to connect to, send Transact-SQL batches from, and output rowset information from SQL Server 7.0, SQL Server 2000, SQL Server 2005, and SQL Server 2008 instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server 2008 and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.Note: This component requires both Windows Installer 4.5 and Microsoft SQL Server Native Client (which is another component available from this page). X86 Package(SqlCmdLnUtils.msi)X64 Package (SqlCmdLnUtils.msi)Microsoft Connector 1.0 for SAP BI The Microsoft Connector for SAP BI is a set of managed components for transferring data to or from an SAP NetWeaver BI version 7.0 system. The component is designed to be used with the Enterprise and Developer editions of SQL Server 2008 Integration Services. To install the component, run the platform-specific installer for x86, x64, or Itanium computers respectively. For more information see the Readme and the installation topic in the Help file.X86 Package(SapBI.msi) X64 Package (SapBI.msi) Microsoft SQL Server 2008 Management ObjectsThe SQL Server Management Objects (SMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer SQL Server objects and services. This object model will work with SQL Server 2000, SQL Server 2005 and SQL Server 2008.Note: Microsoft SQL Server 2008 Management Objects Collection requires Microsoft Core XML Services (MSXML) 6.0, Microsoft SQL Server Native Client, and Microsoft SQL Server System CLR Types. These are available on this page. X86 Package (SharedManagementObjects.msi) X64 Package (SharedManagementObjects.msi) SQL

2005, and SQL Server 2008 instances. The bcp utility bulk copies data between an instance of Microsoft SQL Server 2008 and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files.Note: This component requires both Windows Installer 4.5 and Microsoft SQL Server Native Client (which is another component available from this page). X86 Package(SqlCmdLnUtils.msi)X64 Package (SqlCmdLnUtils.msi)Microsoft Connector 1.0 for SAP BI The Microsoft Connector for SAP BI is a set of managed components for transferring data to or from an SAP NetWeaver BI version 7.0 system. The component is designed to be used with the Enterprise and Developer editions of SQL Server 2008 Integration Services. To install the component, run the platform-specific installer for x86, x64, or Itanium computers respectively. For more information see the Readme and the installation topic in the Help file.X86 Package(SapBI.msi) X64 Package (SapBI.msi) Microsoft SQL Server 2008 Management ObjectsThe SQL Server Management Objects (SMO) is a .NET Framework object model that enables software developers to create client-side applications to manage and administer SQL Server objects and services. This object model will work with SQL Server 2000, SQL Server 2005 and SQL Server 2008.Note: Microsoft SQL Server 2008 Management Objects Collection requires Microsoft Core XML Services (MSXML) 6.0, Microsoft SQL Server Native Client, and Microsoft SQL Server System CLR Types. These are available on this page. X86 Package (SharedManagementObjects.msi) X64 Package (SharedManagementObjects.msi) SQL Server Remote Blob StoreThe SQL Server Remote Blob Store is a method for storing blobs of unstructured data in an external Content Addressable data store. The component consists of a client-side DLL that is linked into a user application, as well as a set of stored procedures to be installed on SQL Server. Run the self-extracting download package to create an installation folder. The setup program contained there will install RBS on X86, X64, and Itanium-based computers. X86 Package (RBS.msi) X64 Package (RBS.msi) Microsoft SQL Server 2008 Native Client Microsoft SQL Server 2008 Native Client (SQL Server Native Client) is a single dynamic-link library (DLL) containing both the SQL OLE DB provider and SQL ODBC driver. It contains run-time support for applications using native-code APIs (ODBC, OLE DB and ADO) to connect to Microsoft SQL Server 2000, 2005, or 2008. SQL Server Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2008 features. This redistributable installer for SQL Server Native Client installs the client components needed during run time to take advantage of new SQL Server 2008 features, and optionally installs the header files needed to

Applies ToSQL Server 2008 R2 Datacenter SQL Server 2008 R2 Developer SQL Server 2008 R2 Enterprise SQL Server 2008 R2 Express SQL Server 2008 R2 Express with Advanced Services SQL Server 2008 R2 Standard SQL Server 2008 R2 Standard Edition for Small Business SQL Server 2008 R2 Web SQL Server 2008 R2 Workgroup SQL Server 2012 Business Intelligence SQL Server 2012 Developer SQL Server 2012 Enterprise SQL Server 2012 Standard SQL Server 2012 Web SQL Server 2012 Enterprise Core Microsoft distributes Microsoft SQL Server 2008 R2 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release. Symptoms When you run a SELECT statement that contains a LIKE operator and an ESCAPE clause in SQL Server 2008 R2 or in SQL Server 2012, SQL Server may use an inefficient query plan for the statement. Additionally, the performance of the statement is low. Cause This issue occurs because the number of rows that is estimated for the SELECT statement is much larger than the actual number of rows. Resolution Cumulative update information Cumulative update package 1 for SQL Server 2012 Service Pack 1 The fix for this issue was first released in Cumulative Update 1. For more information about how to obtain this cumulative update package for SQL Server 2012 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base: 2765331 Cumulative update package 1 for SQL Server 2012 Service Pack 1Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2012 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base: 2772858 The SQL Server 2012 builds that were released after SQL Server 2012 Service Pack 1 was released SQL Server 2012 The fix for this issue was first released in Cumulative Update 3 for SQL Server 2012. For more information about this cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base: 2723749 Cumulative update package 3 for SQL Server 2012Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2012 fix release. Microsoft recommends that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge

Enterprise x86, x64, or IA-64 edition If you are running one of the editions that are listed here, you only have to rerun the Setup program and then select Add Features to an Existing Installation. However, if you are running a SQL Server 2008 Web edition or a SQL Server 2008 Workgroup edition, you cannot work around this issue directly by using the Setup program. To work around this issue, you must install a new instance of SQL Server 2008 by using one of the editions that are listed here or install the hotfix. Status Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in SQL Server 2008 Service Pack 1. More Information This hotfix removes the requirement that maintenance plans can only be executed on servers where SQL Server 2008 Integration Services are installed. After you install this hotfix, maintenance plans can be executed even when SQL Server 2008 Integration Services are not installed on the server.For more information about a similar issue in SQL Server 2005, click the following article number to view the article in the Microsoft Knowledge Base: 909036 Error message when you create a new maintenance plan in SQL Server 2005: "Create maintenance plan failed"For more information about how to install SQL Server 2008, visit the following Microsoft Web site: more information about features that are supported by the editions of SQL Server 2008, visit the following Microsoft Web site: more information about what files are changed, and for information about any prerequisites to apply the cumulative update package that contains the hotfix that is described in this Microsoft Knowledge Base article, click the following article number to view the article in the Microsoft Knowledge Base: 960484 Cumulative update package 3 for SQL Server 2008 References For more information about the list of builds that are available after the release of SQL Server 2008, click the following article number to view the article in the Microsoft Knowledge Base: 956909 The SQL Server 2008 builds that were released after SQL Server 2008 was releasedFor more information about the Incremental Servicing Model for SQL Server, click the following article number to view the article in the Microsoft Knowledge Base: 935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problemsFor more information about the