SQL Server Q&A

As a software engineer, I focus on .NET, especially asp.net, C#, WCF and so on, and I am also very interested in Search Engine Optimization.

Entries Tagged ‘SMO’

Cumulative update package 3 for SQL Server 2005 Service Pack 2

Symptoms
Microsoft SQL Server 2005 hotfixes are created for specific SQL Server service packs. You must apply a SQL Server 2005 Service Pack 2 hotfix to an installation of SQL Server 2005 Service Pack 2. By default, any hotfix that is provided in a SQL Server service pack is included in the next SQL Server service pack.
Cumulative Update 3 contains hotfixes for SQL Server 2005 issues that have been fixed since the release of Service Pack 2.
Note This build of the cumulative update package is also known as build 3186.
We recommend that you test hotfixes before you deploy them in a production environment. 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 2005 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:
937137?(http://support.microsoft.com/kb/937137/) The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released
Important notes about the cumulative update packageSQL Server 2005 hotfixes are now multilanguage. Therefore, there is only one cumulative hotfix package for all languages.One cumulative hotfix package includes all the component packages. The cumulative update package updates only those components that are installed on the system.You must enable the SQL Server Management Object (SMO) extended stored procedures and the SQL Server Distributed Management Object (SQL-DMO) extended stored procedures before you apply the cumulative update package. For more information about the SMO and DMO XPs option, see SQL Server 2005 Books Online.
Note SQL Server 2005 Books Online notes that the default setting of these stored procedures is 0 (off). However, this value is incorrect. By default, the setting is 1 (on).
Resolution
How to obtain Cumulative Update 3 for SQL Server 2005 Service Pack 2 A supported cumulative update package is now available from Microsoft. However, it is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems. This cumulative update package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for the next SQL Server 2005 service pack that contains the hotfixes in this cumulative update package.
If the cumulative update is available for download, there is a “Hotfix download available” section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package.
Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific cumulative update package. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:
http://support.microsoft.com/contactus/?ws=support(http://support.microsoft.com/contactus/?ws=support)Note The “Hotfix Download Available” form displays the languages for which the cumulative update is available. If you do not see your language, it is because a cumulative update package is not available for that language.
Known issuesFor more information about the issue that occurs when Cumulative Update 3 for SQL Server 2005 Service Pack 2 unregisters the Dts.dll file on a computer that has a 64-bit processor, click the following article number to view the article in the Microsoft Knowledge Base:
919224?(http://support.microsoft.com/kb/919224/) On a computer that has a 64-bit processor, you receive an error message in SQL Server Management Studio when you connect to SQL Server 2005 Integration Services or when you create or edit a maintenance plan
SQL Server 2005 post-SP2 hotfixes that are included in Cumulative Update 3 for SQL Server 2005 Service Pack 2Microsoft Knowledge Base articles that discuss these hotfixes will be released as they become available.
For more information about the SQL Server bugs, click the following article numbers to view the articles in the Microsoft Knowledge Base:
Collapse this tableExpand this table
SQL bug numberKB article numberDescription50000872936252?(http://support.microsoft.com/kb/936252/)The file name of Cumulative Update 3 for SQL Server 2005 Service Pack 2 is incorrectly associated with Microsoft Knowledge Base article 93625250001109940948?(http://support.microsoft.com/kb/940948/)FIX: Error message when you use Database Engine Tuning Advisor to tune a database in SQL Server 2005 Service Pack 2: “An unhandled win32 exception occurred in dtaengine90.exe [4308]“50001164936081?(http://support.microsoft.com/kb/936081/)FIX: Error message when you connect to an instance of SQL Server 2008 Analysis Services by using the AMO library that is included with SQL Server 2005 Service Pack 2 Analysis Services: “Cannot connect to Analysis Services version ‘10.0.1600.22′”50001224937100?(http://support.microsoft.com/kb/937100/)FIX: Error message when you run a SQL Server 2005 Integration Services package that contains a Script Component transformation:”Insufficient memory to continue the execution of the program”50001351940370?(http://support.microsoft.com/kb/940370/)FIX: The event information that is generated by a child package does not have a “User:” prefix in Integration Services in SQL Server 2005 Service Pack 250001365940371?(http://support.microsoft.com/kb/940371/)FIX: Error message when you run a query that selects many columns and that joins many tables in SQL Server 2005 Service Pack 2: “The query processor could not produce a query plan”50001368940372?(http://support.microsoft.com/kb/940372/)FIX: The performance of an MDX query that contains subselect queries and calculated members is much slower in SQL Server 2005 Analysis Services Service Pack 2 than in the earlier versions of SQL Server 2005 Analysis Services50001382940373?(http://support.microsoft.com/kb/940373/)FIX: The performance of an MDX query in SQL Server 2005 Analysis Services Service Pack 2 is much slower than the performance of the same query in earlier builds of SQL Server 2005 Analysis Services50001396940149?(http://support.microsoft.com/kb/940149/)FIX: In SQL Server 2005 Service Pack 2, the toolbar of a Reporting Services report turns gray when you click “View Report”50001412940375?(http://support.microsoft.com/kb/940375/)FIX: Error message when you use the Copy Database Wizard to move a database from SQL Server 2000 to SQL Server 200550001414940376?(http://support.microsoft.com/kb/940376/)FIX: Error message when you use the Bcp.exe utility together with the queryout option in Microsoft SQL Server 2005: “BCP host-files must contain at least one column”50001415940377?(http://support.microsoft.com/kb/940377/)FIX: Error message when you process cubes for one of the named instances of SQL Server 2005 Analysis Services: “Error opening file”50001416940287?(http://support.microsoft.com/kb/940287/)FIX: Error message when you use Service Broker in SQL Server 2005: “An error occurred while receiving data: ‘64(The specified network name is no longer available.)’”50001433940378?(http://support.microsoft.com/kb/940378/)FIX: A cursor uses the incorrect transaction isolation level after you change the transaction isolation level for the cursor in SQL Server 200550001435940269?(http://support.microsoft.com/kb/940269/)FIX: Error message when you try to edit a SQL Server Agent job or a maintenance plan by using SQL Server Management Studio in SQL Server 2005: “String or binary data would be truncated”50001436940379?(http://support.microsoft.com/kb/940379/)FIX: Error message when you back up a database to a tape device in Microsoft SQL Server 2005 SP2: “Operation on device ‘TAPE0(\\.\Tape0)’ exceeded retry count” or “BackupTapeFile::UnloadTape: PrepareTape failure on backup device ‘\\.\Tape0′”50001447940220?(http://support.microsoft.com/kb/940220/)FIX: Error message when you run a SQL Server 2005 Integration Services package that contains an FTP task: “An error occurred in the requested FTP operation”50001448940221?(http://support.microsoft.com/kb/940221/)FIX: Error message when you try to create an Oracle publication by using the New Publication Wizard in SQL Server 2005 Service Pack 2: “OLE DB Provider ‘OraOLEDB.ORACLE’ for Linked server <LinkedServerName> returned message”50001449940210?(http://support.microsoft.com/kb/940210/)FIX: Error message when you try to insert more than 3 megabytes of data into a distributed partitioned view in SQL Server 2005: “A system assertion check has failed”50001451940223?(http://support.microsoft.com/kb/940223/)FIX: Error message when you synchronize a subscription by using Windows Synchronization Manager in SQL Server 2005: “The merge process failed to get correct information about the Interactive Resolver component from the Registry”50001461When some MDX queries are executed at the same for the same role or for the same user in SQL Server 2005 Analysis Services, the CPU usage is very high50001475940382?(http://support.microsoft.com/kb/940382/)FIX: The calendar control in a SQL Server 2005 Reporting Services report may display incorrect values50001479940384?(http://support.microsoft.com/kb/940384/)FIX: You receive a System.InvalidCastException exception when you run an application that calls the Server.JobServer.Jobs.Contains method on a computer that has SQL Server 2005 Service Pack 2 installed50001494940386?(http://support.microsoft.com/kb/940386/)FIX: You cannot install the SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies on a computer that is running a beta version of Windows Server 200850001499938962?(http://support.microsoft.com/kb/938962/)FIX: You may receive an access violation or error 942 when you drop a database in SQL Server 200550001511940126?(http://support.microsoft.com/kb/940126/)FIX: Error 9003 is logged in the SQL Server error log file when you use log shipping in SQL Server 200550001517940160?(http://support.microsoft.com/kb/940160/)FIX: Error message when you deploy a SQL Server 2005 Analysis Service project that contains many cubes, and the cubes contain linked measure groups: “Unexpected internal error”50001520940389?(http://support.microsoft.com/kb/940389/)FIX: Error message when you display a report that uses SAP Business Information Warehouse 3.5 as the data source in SQL Server 2005 Service Pack 2 Reporting Services: “Can’t find object <Object ID>”50001522939562?(http://support.microsoft.com/kb/939562/)FIX: Error message when you run a query that fires an INSTEAD OF trigger in SQL Server 2005 Service Pack 2: “Internal Query Processor Error The query processor could not produce a query plan”50001523938363?(http://support.microsoft.com/kb/938363/)FIX: Data is not replicated to a subscriber in a different partition by using parameterized row filters in SQL Server 200550001524939563?(http://support.microsoft.com/kb/939563/)FIX: Error message when you synchronize a merge replication in Microsoft SQL Server 2005: “MSmerge_del_<GUID>, Line 42 String or binary data would be truncated”50001525938086?(http://support.microsoft.com/kb/938086/)FIX: A SQL Server Agent job fails when you run the SQL Server Agent job in the context of a proxy account in SQL Server 200550001526938086?(http://support.microsoft.com/kb/938086/)FIX: A SQL Server Agent job fails when you run the SQL Server Agent job in the context of a proxy account in SQL Server 200550001529940945?(http://support.microsoft.com/kb/940945/)FIX: Performance is very slow when the same stored procedure is executed at the same time in many connections on a multiple-processor computer that is running SQL Server 200550001567940281?(http://support.microsoft.com/kb/940281/)FIX: An access violation may occur, and you may receive an error message, when you query the sys.dm_exec_sessions dynamic management view in SQL Server 200550001573940949?(http://support.microsoft.com/kb/940949/)FIX: You receive an error message when you run an UPDATE CUBE statement to update a cube in SQL Server 2005 Analysis Services50001576940962?(http://support.microsoft.com/kb/940962/)FIX: Error message when you process a database in SQL Server 2005 Analysis Services: “Failed generate and process of Olap object(s): Internal error: The operation terminated unsuccessfully”50001578939285?(http://support.microsoft.com/kb/939285/)FIX: Error message when you run a stored procedure that starts a transaction that contains a Transact-SQL statement in SQL Server 2005: “New request is not allowed to start because it should come with valid transaction descriptor”50001579939564?(http://support.microsoft.com/kb/939564/)FIX: You receive an incorrect result when you use a SQL Native Client provider to read the data on the client computer in SQL Server 200550001580Memory leak of the TokenAndPermAccessCheckResult entries occurs in SQL Server 200550001581938243?(http://support.microsoft.com/kb/938243/)FIX: Error message when you run a full-text query against a catalog in SQL Server 2005: “The execution of a full-text query failed. The content index is corrupt.”50001582939942?(http://support.microsoft.com/kb/939942/)FIX: You receive an error message when you try to access a report after you configure SQL Server 2005 Reporting Services to run under the SharePoint integrated mode50001583940128?(http://support.microsoft.com/kb/940128/)FIX: When you run a complex query in SQL Server 2005, the query performance is slow if the execution plan of the query contains semi join operators50001585938712?(http://support.microsoft.com/kb/938712/)FIX: Some records in the fact table may not be processed when you process a dimension that contains many attributes or many members in SQL Server 200550001586940129?(http://support.microsoft.com/kb/940129/)FIX: An MDX query does not return results when you execute the query against a cube that contains an unnatural hierarchy in a dimension in SQL Server 2005 Analysis Services50001589940935?(http://support.microsoft.com/kb/940935/)FIX: Error message when you run a query that is associated with a parallel execution plan in SQL Server 2005: “SQL Server Assertion: File: <lckmgr.cpp>, line=10850 Failed Assertion = ‘GetLocalLockPartition () == xactLockInfo->GetLocalLockPartition ()’”50001595940390?(http://support.microsoft.com/kb/940390/)FIX: You cannot roll back changes in a transaction after you call the ITransactionLocal::Abort method by setting the fRetaining flag to TRUE in a SQL Server 2005-based application that uses the SQL Native Client OLE DB provider50001598941184?(http://support.microsoft.com/kb/941184/)FIX: An application that is included in SQL Server 2005 may stop responding when you specify a network protocol that is not valid in the application50001599940937?(http://support.microsoft.com/kb/940937/)FIX: Error message when you try to update the index key columns of a non-unique clustered index in SQL Server 2005: “Cannot insert duplicate key row in object ‘ObjectName’ with unique index ‘IndexName’”50001602940545?(http://support.microsoft.com/kb/940545/)FIX: The performance of insert operations against a table that contains an identity column may be slow in SQL Server 200550001609940939?(http://support.microsoft.com/kb/940939/)FIX: When you roll back a transaction that contains a writeback operation, SQL Server does not roll back the writeback operation in SQL Server 2005 Analysis Services50001629940942?(http://support.microsoft.com/kb/940942/)FIX: Error message when you run a stored procedure that references tables after you upgrade a database from SQL Server 2000 to SQL Server 2005: “A time-out occurred while waiting for buffer latch”50001639940943?(http://support.microsoft.com/kb/940943/)FIX: The performance of a query that performs an insert operation or an update operation is much slower in SQL Server 2005 SP2 than in earlier versions of SQL Server 2005
Cumulative update package informationPrerequisitesMicrosoft SQL Server 2005 Service Pack 2
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
913089?(http://support.microsoft.com/kb/913089/LN/) How to obtain the latest service pack for SQL Server 2005 Restart informationYou may have to restart the computer after you apply this cumulative update package.Registry informationTo use one of the hotfixes in this package, you do not have to make any changes to the registry.Cumulative update package file informationThis cumulative update package may not contain all the files that you must have to fully update a product to the latest build. This cumulative update package contains only the files that you must have to correct the issues that are listed in this article.
The English version of this cumulative update package has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.SQL Server 2005 Database Engine, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformBcp.exe2005.90.3186.068,97611-Aug-0710:19×86Chsbrkr.dll12.0.7822.01,684,84022-Jun-079:22×86Chtbrkr.dll12.0.7822.06,112,61622-Jun-079:22×86Databasemailprotocols.dll9.0.3186.046,44811-Aug-0710:19×86Dts.dll2005.90.3186.01,102,19211-Aug-0710:19×86Dtsconn.dll2005.90.3186.0250,73611-Aug-0710:19×86Fteref.dll12.0.7822.0446,46422-Jun-079:22×86Infosoft.dll12.0.7822.0468,32822-Jun-079:22×86Korwbrkr.dll12.0.7822.071,01622-Jun-079:22×86Langwrbk.dll12.0.7822.0136,55222-Jun-079:22×86Microsoft.analysisservices.dll9.0.3186.01,217,90411-Aug-0710:19×86Microsoft.sqlserver.dtstransferprovider.dll9.0.3186.0116,08011-Aug-0710:19×86Microsoft.sqlserver.maintenanceplantasks.dll9.0.3186.0296,30411-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0710:19×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0710:19×86Msfte.dll12.0.7822.02,430,31222-Jun-079:22×86Msftefd.exe12.0.7822.066,92022-Jun-079:22×86Msftepxy.dll12.0.7822.095,59222-Jun-079:22×86Msftesql.exe12.0.7822.095,59222-Jun-079:22×86Msir5jp.dll5.0.2130.03,159,91222-Jun-079:22×86Msmdlocal.dll9.0.3186.015,955,31211-Aug-0710:19×86Nlhtml.dll12.0.7822.0124,26422-Jun-079:22×86Nls400.dll5.0.4217.012,240,74422-Jun-079:22×86Odsole70.dll2005.90.3186.059,24811-Aug-0710:19×86Query.dll12.0.7822.048,48822-Jun-079:22×86Rdistcom.dll2005.90.3186.0644,97611-Aug-0710:19×86Replmerg.exe2005.90.3186.0320,88011-Aug-0710:19×86Replrec.dll2005.90.3186.0785,26411-Aug-0710:19×86Sqlaccess.dll2005.90.3186.0350,57611-Aug-0710:19×86Sqlagent90.exe2005.90.3186.0349,55211-Aug-0710:19×86Sqlservr.exe2005.90.3186.029,202,80011-Aug-0710:20×86Sqlwep.dll2005.90.3186.090,99211-Aug-0710:20×86Sqsrvres.dll2005.90.3186.070,51211-Aug-0710:20×86Thawbrkr.dll12.0.7822.0206,18422-Jun-079:22×86Xmlfilt.dll12.0.7822.0197,99222-Jun-079:22×86Xpstar90.dll2005.90.3186.0298,86411-Aug-0710:20×86SQL Server 2005 Analysis Services, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformMicrosoft.analysisservices.dll9.0.3186.01,217,90411-Aug-0710:19×86Microsoft.datawarehouse.dll9.0.3186.01,279,34411-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0710:19×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0710:19×86Msadomdx.dll9.0.3186.0502,64011-Aug-0710:19×86Msmdlocal.dll9.0.3186.015,955,31211-Aug-0710:19×86Msmdspdm.dll9.0.3186.0202,09611-Aug-0710:19×86Msmdsrv.exe9.0.3186.014,923,63211-Aug-0710:19×86Msmgdsrv.dll9.0.3186.06,045,55211-Aug-0710:19×86Msolap90.dll9.0.3186.04,299,12011-Aug-0710:19×86SQL Server 2005 Reporting Services, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformMicrosoft.analysisservices.dll9.0.3186.01,217,90411-Aug-0710:19×86Microsoft.reportingservices.dataextensions.sapbw.dll9.0.3186.042,35211-Aug-0710:19×86Microsoft.reportingservices.dataextensions.xmlaclient.dll9.0.3186.0558,44811-Aug-0710:19×86Microsoft.reportingservices.diagnostics.dll9.0.3186.0800,11211-Aug-0710:19×86Microsoft.reportingservices.htmlrendering.dll9.0.3186.0308,59211-Aug-0710:19×86Microsoft.reportingservices.imagerendering.dll9.0.3186.0288,11211-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0710:19×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0710:19×86Msadomdx.dll9.0.3186.0502,64011-Aug-0710:19×86Msmdlocal.dll9.0.3186.015,955,31211-Aug-0710:19×86Msmgdsrv.dll9.0.3186.06,045,55211-Aug-0710:19×86Reportingserviceslibrary.dll9.0.3186.01,119,60011-Aug-0710:19×86Reportingservicesservice.exe9.0.3186.017,26411-Aug-0710:19×86Reportingserviceswebserver.dll9.0.3186.01,725,80811-Aug-0710:19×86Reportingserviceswebuserinterface.dll9.0.3186.01,332,59211-Aug-0710:19×86SQL Server 2005 Notification Services, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformMicrosoft.analysisservices.dll9.0.3186.01,217,90411-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0710:19×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0710:19×86Nsservice.exe9.0.3186.021,87211-Aug-0710:19×86SQL Server 2005 Integration Services, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDts.dll2005.90.3186.01,102,19211-Aug-0710:19×86Dtsconn.dll2005.90.3186.0250,73611-Aug-0710:19×86Flatfiledest.dll2005.90.3186.0256,36811-Aug-0710:19×86Flatfilesrc.dll2005.90.3186.0265,07211-Aug-0710:19×86Microsoft.analysisservices.dll9.0.3186.01,217,90411-Aug-0710:19×86Microsoft.sqlserver.dmquerytask.dll9.0.3186.0333,16811-Aug-0710:19×86Microsoft.sqlserver.dtstransferprovider.dll9.0.3186.0116,08011-Aug-0710:19×86Microsoft.sqlserver.maintenanceplantasks.dll9.0.3186.0296,30411-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0710:19×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0710:19×86Msdtssrvr.exe9.0.3186.0206,19211-Aug-0710:19×86Msmdlocal.dll9.0.3186.015,955,31211-Aug-0710:19×86Txmergejoin.dll2005.90.3186.0141,16811-Aug-0710:20×86SQL Server 2005 Tools, 32-bit version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformAutoadmin90.dll2005.90.3186.0902,00011-Aug-0710:19×86Bcp.exe2005.90.3186.068,97611-Aug-0710:19×86Dts.dll2005.90.3186.01,102,19211-Aug-0710:19×86Dtsconn.dll2005.90.3186.0250,73611-Aug-0710:19×86Flatfiledest.dll2005.90.3186.0256,36811-Aug-0710:19×86Flatfilesrc.dll2005.90.3186.0265,07211-Aug-0710:19×86Microsoft.analysisservices.controls.dll9.0.3186.02,766,19211-Aug-0710:19×86Microsoft.analysisservices.dll9.0.3186.01,217,90411-Aug-0710:19×86Microsoft.datawarehouse.dll9.0.3186.01,279,34411-Aug-0710:19×86Microsoft.reportingservices.dataextensions.sapbw.dll9.0.3186.042,35211-Aug-0710:19×86Microsoft.reportingservices.dataextensions.xmlaclient.dll9.0.3186.0558,44811-Aug-0710:19×86Microsoft.reportingservices.diagnostics.dll9.0.3186.0800,11211-Aug-0710:19×86Microsoft.reportingservices.htmlrendering.dll9.0.3186.0308,59211-Aug-0710:19×86Microsoft.reportingservices.imagerendering.dll9.0.3186.0288,11211-Aug-0710:19×86Microsoft.sqlserver.dmquerytask.dll9.0.3186.0333,16811-Aug-0710:19×86Microsoft.sqlserver.dtstransferprovider.dll9.0.3186.0116,08011-Aug-0710:19×86Microsoft.sqlserver.maintenanceplantasks.dll9.0.3186.0296,30411-Aug-0710:19×86Microsoft.sqlserver.maintenanceplantasksui.dll9.0.3186.0722,28811-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0710:19×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0710:19×86Msadomdx.dll9.0.3186.0502,64011-Aug-0710:19×86Msmdlocal.dll9.0.3186.015,955,31211-Aug-0710:19×86Msmgdsrv.dll9.0.3186.06,045,55211-Aug-0710:19×86Msolap90.dll9.0.3186.04,299,12011-Aug-0710:19×86Replrec.dll2005.90.3186.0785,26411-Aug-0710:19×86Reportingserviceslibrary.dll9.0.3186.01,119,60011-Aug-0710:19×86Sqlwb.exe2005.90.3186.0824,17611-Aug-0710:20×86Txmergejoin.dll2005.90.3186.0141,16811-Aug-0710:20×86SQL Server 2005 Database Engine, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformBcp.exe2005.90.3186.088,43211-Aug-0712:35×64Chsbrkr.dll12.0.7822.01,694,05622-Jun-0710:51×64Chtbrkr.dll12.0.7822.06,109,03222-Jun-0710:51×64Databasemailprotocols.dll9.0.3186.046,44811-Aug-0712:35×86Dts.dll2005.90.3186.01,891,18411-Aug-0712:35×64Dtsconn.dll2005.90.3186.0408,43211-Aug-0712:35×64Fteref.dll12.0.7822.0433,15222-Jun-0710:51×64Infosoft.dll12.0.7822.0621,41622-Jun-0710:51×64Korwbrkr.dll12.0.7822.0101,73622-Jun-0710:51×64Langwrbk.dll12.0.7822.0236,90422-Jun-0710:51×64Microsoft.analysisservices.dll9.0.3186.01,217,90411-Aug-0710:19×86Microsoft.sqlserver.dtstransferprovider.dll9.0.3186.0116,08011-Aug-0712:35×86Microsoft.sqlserver.maintenanceplantasks.dll9.0.3186.0296,30411-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0712:35×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0712:35×86Msfte.dll12.0.7822.03,808,10422-Jun-0710:51×64Msftefd.exe12.0.7822.099,17622-Jun-0710:51×64Msftepxy.dll12.0.7822.0127,33622-Jun-0710:51×64Msftesql.exe12.0.7822.0158,56822-Jun-0710:51×64Msir5jp.dll5.0.2130.03,421,54422-Jun-0710:51×64Msmdlocal.dll9.0.3186.015,955,31211-Aug-0710:19×86Nlhtml.dll12.0.7822.0191,84822-Jun-0710:51×64Nls400.dll5.0.4217.014,101,35222-Jun-0710:51×64Odsole70.dll2005.90.3186.090,48011-Aug-0712:35×64Query.dll12.0.7822.068,45622-Jun-0710:51×64Rdistcom.dll2005.90.3186.0828,78411-Aug-0712:35×64Replmerg.exe2005.90.3186.0417,64811-Aug-0712:35×64Replrec.dll2005.90.3186.01,012,08011-Aug-0712:35×64Sqlaccess.dll2005.90.3186.0357,74411-Aug-0712:35×86Sqlagent90.exe2005.90.3186.0429,42411-Aug-0712:35×64Sqlservr.exe2005.90.3186.039,557,48811-Aug-0712:35×64Sqlwep.dll2005.90.3186.090,99211-Aug-0710:20×86Sqlwep.dll2005.90.3186.0123,76011-Aug-0712:35×64Sqsrvres.dll2005.90.3186.083,31211-Aug-0712:35×64Thawbrkr.dll12.0.7822.0209,76822-Jun-0710:51×64Xmlfilt.dll12.0.7822.0271,20822-Jun-0710:51×64Xpstar90.dll2005.90.3186.0550,25611-Aug-0712:35×64SQL Server 2005 Analysis Services, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformMicrosoft.analysisservices.dll9.0.3186.01,217,90411-Aug-0710:19×86Microsoft.datawarehouse.dll9.0.3186.01,279,34411-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0712:35×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0712:35×86Msadomdx.dll9.0.3186.0502,64011-Aug-0710:19×86Msmdlocal.dll9.0.3186.015,955,31211-Aug-0710:19×86Msmdlocal.dll9.0.3186.032,202,60811-Aug-0712:35×64Msmdspdm.dll9.0.3186.0202,09611-Aug-0712:35×86Msmdsrv.exe9.0.3186.031,589,74411-Aug-0712:35×64Msmgdsrv.dll9.0.3186.06,045,55211-Aug-0710:19×86Msmgdsrv.dll9.0.3186.09,802,60811-Aug-0712:35×64Msolap90.dll9.0.3186.04,299,12011-Aug-0710:19×86Msolap90.dll9.0.3186.05,928,81611-Aug-0712:35×64SQL Server 2005 Reporting Services, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformMicrosoft.analysisservices.dll9.0.3186.01,217,90411-Aug-0710:19×86Microsoft.reportingservices.dataextensions.sapbw.dll9.0.3186.042,35211-Aug-0712:35×86Microsoft.reportingservices.dataextensions.xmlaclient.dll9.0.3186.0558,44811-Aug-0712:35×86Microsoft.reportingservices.diagnostics.dll9.0.3186.0800,11211-Aug-0712:35×86Microsoft.reportingservices.htmlrendering.dll9.0.3186.0308,59211-Aug-0712:35×86Microsoft.reportingservices.imagerendering.dll9.0.3186.0288,11211-Aug-0712:35×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0712:35×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0712:35×86Msadomdx.dll9.0.3186.0502,64011-Aug-0710:19×86Msmdlocal.dll9.0.3186.032,202,60811-Aug-0712:35×64Msmgdsrv.dll9.0.3186.09,802,60811-Aug-0712:35×64Reportingserviceslibrary.dll9.0.3186.01,119,60011-Aug-0712:35×86Reportingservicesservice.exe9.0.3186.017,26411-Aug-0712:35×86Reportingserviceswebserver.dll9.0.3186.01,725,80811-Aug-0712:35×86Reportingserviceswebuserinterface.dll9.0.3186.01,332,59211-Aug-0712:35×86SQL Server 2005 Notification Services, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformMicrosoft.analysisservices.dll9.0.3186.01,217,90411-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0712:35×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0710:19×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0712:35×86Nsservice.exe9.0.3186.021,87211-Aug-0712:35×86SQL Server 2005 Integration Services, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDts.dll2005.90.3186.01,891,18411-Aug-0712:35×64Dtsconn.dll2005.90.3186.0408,43211-Aug-0712:35×64Flatfiledest.dll2005.90.3186.0421,23211-Aug-0712:35×64Flatfilesrc.dll2005.90.3186.0430,96011-Aug-0712:35×64Microsoft.analysisservices.dll9.0.3186.01,217,90411-Aug-0710:19×86Microsoft.sqlserver.dmquerytask.dll9.0.3186.0333,16811-Aug-0710:19×86Microsoft.sqlserver.dtstransferprovider.dll9.0.3186.0116,08011-Aug-0712:35×86Microsoft.sqlserver.maintenanceplantasks.dll9.0.3186.0296,30411-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0712:35×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0712:35×86Msdtssrvr.exe9.0.3186.0202,09611-Aug-0712:35×64Msmdlocal.dll9.0.3186.032,202,60811-Aug-0712:35×64Txmergejoin.dll2005.90.3186.0235,88811-Aug-0712:35×64SQL Server 2005 Tools, x64-based version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformAutoadmin90.dll2005.90.3186.0902,00011-Aug-0710:19×86Bcp.exe2005.90.3186.088,43211-Aug-0712:35×64Dts.dll2005.90.3186.01,102,19211-Aug-0710:19×86Dtsconn.dll2005.90.3186.0250,73611-Aug-0710:19×86Flatfiledest.dll2005.90.3186.0256,36811-Aug-0710:19×86Flatfilesrc.dll2005.90.3186.0265,07211-Aug-0710:19×86Microsoft.analysisservices.controls.dll9.0.3186.02,766,19211-Aug-0710:19×86Microsoft.analysisservices.dll9.0.3186.01,217,90411-Aug-0710:19×86Microsoft.datawarehouse.dll9.0.3186.01,279,34411-Aug-0710:19×86Microsoft.reportingservices.dataextensions.sapbw.dll9.0.3186.042,35211-Aug-0710:19×86Microsoft.reportingservices.dataextensions.xmlaclient.dll9.0.3186.0558,44811-Aug-0710:19×86Microsoft.reportingservices.diagnostics.dll9.0.3186.0800,11211-Aug-0710:19×86Microsoft.reportingservices.htmlrendering.dll9.0.3186.0308,59211-Aug-0710:19×86Microsoft.reportingservices.imagerendering.dll9.0.3186.0288,11211-Aug-0710:19×86Microsoft.sqlserver.dmquerytask.dll9.0.3186.0333,16811-Aug-0710:19×86Microsoft.sqlserver.dtstransferprovider.dll9.0.3186.0116,08011-Aug-0710:19×86Microsoft.sqlserver.maintenanceplantasks.dll9.0.3186.0296,30411-Aug-0710:19×86Microsoft.sqlserver.maintenanceplantasksui.dll9.0.3186.0722,28811-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0712:35×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0710:19×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0712:35×86Microsoft.visualstudio.templatewizardinterface.dll8.0.50727.4215,87223-Sep-056:56×86Msadomdx.dll9.0.3186.0502,64011-Aug-0710:19×86Msmdlocal.dll9.0.3186.015,955,31211-Aug-0710:19×86Msmdlocal.dll9.0.3186.032,202,60811-Aug-0712:35×64Msmgdsrv.dll9.0.3186.06,045,55211-Aug-0710:19×86Msmgdsrv.dll9.0.3186.09,802,60811-Aug-0712:35×64Msolap90.dll9.0.3186.04,299,12011-Aug-0710:19×86Msolap90.dll9.0.3186.05,928,81611-Aug-0712:35×64Replrec.dll2005.90.3186.0785,26411-Aug-0710:19×86Replrec.dll2005.90.3186.01,012,08011-Aug-0712:35×64Reportingserviceslibrary.dll9.0.3186.01,119,60011-Aug-0710:19×86Sqlwb.exe2005.90.3186.0824,17611-Aug-0710:20×86Txmergejoin.dll2005.90.3186.0141,16811-Aug-0710:20×86SQL Server 2005 Database Engine, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformBcp.exe2005.90.3186.0157,04011-Aug-0715:06ia64Chsbrkr.dll12.0.7822.01,883,49622-Jun-0710:06ia64Chtbrkr.dll12.0.7822.06,153,57622-Jun-0710:06ia64Databasemailprotocols.dll9.0.3186.046,44811-Aug-0715:06×86Dts.dll2005.90.3186.03,511,66411-Aug-0715:06ia64Dtsconn.dll2005.90.3186.0725,36011-Aug-0715:06ia64Fteref.dll12.0.7822.0433,15222-Jun-0710:06ia64Infosoft.dll12.0.7822.01,915,24022-Jun-0710:06ia64Korwbrkr.dll12.0.7822.0182,63222-Jun-0710:06ia64Langwrbk.dll12.0.7822.0333,16022-Jun-0710:06ia64Microsoft.analysisservices.dll9.0.3186.01,217,90411-Aug-0710:19×86Microsoft.sqlserver.dtstransferprovider.dll9.0.3186.0116,08011-Aug-0715:07×86Microsoft.sqlserver.maintenanceplantasks.dll9.0.3186.0296,30411-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0715:07×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0715:07×86Msfte.dll12.0.7822.07,072,10422-Jun-0710:06ia64Msftefd.exe12.0.7822.0173,41622-Jun-0710:06ia64Msftepxy.dll12.0.7822.0135,52822-Jun-0710:06ia64Msftesql.exe12.0.7822.0294,76022-Jun-0710:06ia64Msir5jp.dll5.0.2130.03,824,48822-Jun-0710:06ia64Msmdlocal.dll9.0.3186.049,938,28811-Aug-0715:07ia64Nlhtml.dll12.0.7822.0295,78422-Jun-0710:06ia64Nls400.dll5.0.4217.014,750,05622-Jun-0710:06ia64Odsole70.dll2005.90.3186.0179,56811-Aug-0715:07ia64Query.dll12.0.7822.0123,24022-Jun-0710:06ia64Rdistcom.dll2005.90.3186.01,885,55211-Aug-0715:07ia64Replmerg.exe2005.90.3186.0957,29611-Aug-0715:07ia64Replrec.dll2005.90.3186.02,147,69611-Aug-0715:07ia64Sqlaccess.dll2005.90.3186.0352,11211-Aug-0715:07×86Sqlagent90.exe2005.90.3186.01,254,25611-Aug-0715:07ia64Sqlservr.exe2005.90.3186.072,821,61611-Aug-0715:07ia64Sqlwep.dll2005.90.3186.090,99211-Aug-0710:20×86Sqlwep.dll2005.90.3186.0221,04011-Aug-0715:07ia64Sqsrvres.dll2005.90.3186.0147,31211-Aug-0715:07ia64Thawbrkr.dll12.0.7822.0253,28822-Jun-0710:06ia64Xmlfilt.dll12.0.7822.0445,80022-Jun-0710:06ia64Xpstar90.dll2005.90.3186.0966,00011-Aug-0715:07ia64SQL Server 2005 Analysis Services, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformFile nameFile versionFile sizeDateTimePlatformMicrosoft.analysisservices.dll9.0.3186.01,217,90411-Aug-0710:19×86Microsoft.datawarehouse.dll9.0.3186.01,279,34411-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0715:07×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0715:07×86Msadomdx.dll9.0.3186.0502,64011-Aug-0710:19×86Msmdlocal.dll9.0.3186.015,955,31211-Aug-0710:19×86Msmdlocal.dll9.0.3186.049,938,28811-Aug-0715:07ia64Msmdspdm.dll9.0.3186.0202,09611-Aug-0715:07×86Msmdsrv.exe9.0.3186.048,889,71211-Aug-0715:07ia64Msmgdsrv.dll9.0.3186.06,045,55211-Aug-0710:19×86Msmgdsrv.dll9.0.3186.013,168,49611-Aug-0715:07ia64Msolap90.dll9.0.3186.04,299,12011-Aug-0710:19×86Msolap90.dll9.0.3186.07,908,72011-Aug-0715:07ia64SQL Server 2005 Reporting Services, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformMicrosoft.analysisservices.dll9.0.3186.01,217,90411-Aug-0710:19×86Microsoft.reportingservices.dataextensions.sapbw.dll9.0.3186.042,35211-Aug-0715:07×86Microsoft.reportingservices.dataextensions.xmlaclient.dll9.0.3186.0558,44811-Aug-0715:07×86Microsoft.reportingservices.diagnostics.dll9.0.3186.0800,11211-Aug-0715:07×86Microsoft.reportingservices.htmlrendering.dll9.0.3186.0308,59211-Aug-0715:07×86Microsoft.reportingservices.imagerendering.dll9.0.3186.0288,11211-Aug-0715:07×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0715:07×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0715:07×86Msadomdx.dll9.0.3186.0502,64011-Aug-0710:19×86Msmdlocal.dll9.0.3186.049,938,28811-Aug-0715:07ia64Msmgdsrv.dll9.0.3186.013,168,49611-Aug-0715:07ia64Reportingserviceslibrary.dll9.0.3186.01,119,60011-Aug-0715:07×86Reportingservicesservice.exe9.0.3186.017,26411-Aug-0715:07×86Reportingserviceswebserver.dll9.0.3186.01,725,80811-Aug-0715:07×86Reportingserviceswebuserinterface.dll9.0.3186.01,332,59211-Aug-0715:07×86SQL Server 2005 Notification Services, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformMicrosoft.analysisservices.dll9.0.3186.01,217,90411-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0715:07×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0710:19×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0715:07×86Nsservice.exe9.0.3186.021,87211-Aug-0715:07×86SQL Server 2005 Integration Services, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDts.dll2005.90.3186.03,511,66411-Aug-0715:06ia64Dtsconn.dll2005.90.3186.0725,36011-Aug-0715:06ia64Flatfiledest.dll2005.90.3186.0908,65611-Aug-0715:06ia64Flatfilesrc.dll2005.90.3186.0934,76811-Aug-0715:06ia64Microsoft.analysisservices.dll9.0.3186.01,217,90411-Aug-0710:19×86Microsoft.sqlserver.dmquerytask.dll9.0.3186.0333,16811-Aug-0710:19×86Microsoft.sqlserver.dtstransferprovider.dll9.0.3186.0116,08011-Aug-0715:07×86Microsoft.sqlserver.maintenanceplantasks.dll9.0.3186.0296,30411-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0715:07×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0715:07×86Msdtssrvr.exe9.0.3186.0202,09611-Aug-0715:07ia64Msmdlocal.dll9.0.3186.049,938,28811-Aug-0715:07ia64Txmergejoin.dll2005.90.3186.0523,63211-Aug-0715:07ia64SQL Server 2005 Tools, Itanium architecture version
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformAutoadmin90.dll2005.90.3186.0902,00011-Aug-0710:19×86Bcp.exe2005.90.3186.0157,04011-Aug-0715:06ia64Dts.dll2005.90.3186.01,102,19211-Aug-0710:19×86Dtsconn.dll2005.90.3186.0250,73611-Aug-0710:19×86Flatfiledest.dll2005.90.3186.0256,36811-Aug-0710:19×86Flatfilesrc.dll2005.90.3186.0265,07211-Aug-0710:19×86Microsoft.analysisservices.controls.dll9.0.3186.02,766,19211-Aug-0710:19×86Microsoft.analysisservices.dll9.0.3186.01,217,90411-Aug-0710:19×86Microsoft.datawarehouse.dll9.0.3186.01,279,34411-Aug-0710:19×86Microsoft.reportingservices.diagnostics.dll9.0.3186.0800,11211-Aug-0710:19×86Microsoft.sqlserver.dmquerytask.dll9.0.3186.0333,16811-Aug-0710:19×86Microsoft.sqlserver.dtstransferprovider.dll9.0.3186.0116,08011-Aug-0710:19×86Microsoft.sqlserver.maintenanceplantasks.dll9.0.3186.0296,30411-Aug-0710:19×86Microsoft.sqlserver.maintenanceplantasksui.dll9.0.3186.0722,28811-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0710:19×86Microsoft.sqlserver.smo.dll9.0.3186.01,598,83211-Aug-0715:07×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0710:19×86Microsoft.sqlserver.sqlenum.dll9.0.3186.0906,60811-Aug-0715:07×86Microsoft.visualstudio.templatewizardinterface.dll8.0.50727.4215,87223-Sep-056:56×86Msadomdx.dll9.0.3186.0502,64011-Aug-0710:19×86Msmdlocal.dll9.0.3186.015,955,31211-Aug-0710:19×86Msmdlocal.dll9.0.3186.049,938,28811-Aug-0715:07ia64Msmgdsrv.dll9.0.3186.06,045,55211-Aug-0710:19×86Msmgdsrv.dll9.0.3186.013,168,49611-Aug-0715:07ia64Msolap90.dll9.0.3186.04,299,12011-Aug-0710:19×86Msolap90.dll9.0.3186.07,908,72011-Aug-0715:07ia64Replrec.dll2005.90.3186.0785,26411-Aug-0710:19×86Replrec.dll2005.90.3186.02,147,69611-Aug-0715:07ia64Sqlwb.exe2005.90.3186.0824,17611-Aug-0710:20×86Txmergejoin.dll2005.90.3186.0141,16811-Aug-0710:20×86Removal informationTo uninstall the cumulative update package, follow these steps:In Control Panel, open Add or Remove Programs.In Add or Remove Programs, click Change or Remove Programs.To see all the updates for the SQL Server 2005 installation, click to select the Show Updates check box.Uninstall the cumulative hotfix package.

How to use the new functionalities of the SQL Server 2008 version of SMO in an application that uses the SQL Server 2005 version of SMO

Symptoms
In Microsoft SQL Server 2008, new functionalities are added to SQL Server Management Objects (SMO). An application that uses the SQL Server 2005 version of SMO cannot be compiled by using the SQL Server 2008 version of SMO. You must make some changes to the application, and then you must recompile the application. Then, you can use the new functionalities in the SQL Server 2008 version of SMO.
Resolution
This article describes what you must do to use the new functionalities of the SQL Server 2008 version of SMO in an application that uses the SQL Server 2005 version of SMO.

FIX: You cannot use the SQL Server 2008 version of SMO to manage certificates in SQL Server 2005 and in SQL Server 2000

Symptoms
You try to manage certificates in Microsoft SQL Server 2005 and in SQL Server 2000 by using the SQL Server 2008 version of SQL Server Management Objects (SMO). An exception is raised, and SMO does not let you manage the certificates.
Resolution
This problem occurs because SQL Server 2008 has a specific property that SMO looks for when you try to manage certificates. However, SMO does not verify which version of SQL Server owns the certificates, and when it tries to initialize this SQL Server 2008 specific property, SMO raises the exception.