.NET Questions and Solutions

Symptoms
Consider the following scenario. A server is running Microsoft SQL Server 2005 Integration Services (SSIS). From a client computer, you use SQL Server Management Studio to connect to Integration Services on the server. To connect to Integration Services on the server, you use auser account that is not a member of the Administrators group on the server. In this scenario, you receive the following error message:

Cannot connect to SSISServer
Additional information:Failed to retrieve data for this request (Microsoft.SqlServer.SmoEnum)
Connect to SSIS Service on machine “SSISServer” failed: Access is denied.Note In this error message, SSISServer is a placeholder for the name of the server or for the IP address of the server.
However, you can successfully connect to Integration Services on the server locally by using the same user account that you used to connect to Integration Services from the client computer.
Resolution
To work around this problem, follow these steps:On the client computer, enable Windows Management Instrumentation (WMI) for remote administration. To do this, follow these steps:Click Start, click Run, type gpedit.msc, and then click OK.In the Group Policy Object Editor, expand Computer Configuration, expand Administrative Templates, and then expand Network.Expand Network Connections, expand Windows Firewall, and then click Domain Profile.Right-click Windows Firewall: Allow remote administration exception, and then click Properties.
Note In Windows Vista, right-click Windows Firewall: Allow inbound remote administration exception.In the Windows Firewall: Allow remote administration exception Properties dialog box, click Enabled, and then click OK.
Note In Windows Vista, the dialog box is the Windows Firewall: Allow inbound remote administration exception dialog box.On the server and on the client computer, specify that DCOM is available for all Microsoft COM applications. To do this, follow these steps:Click Start, click Run, type dcomcnfg, and then click OK.In the Component Services dialog box, expand Component Services, expand Computers, right-click My Computer, and then click Properties.In the My Computer Properties dialog box, click the Default Properties tab.On the Default Properties tab, click to select the Enable Distributed COM on this computer check box, and then click OK.On the server, add the user account to the Distributed COM Users group. To do this, follow these steps:Click Start, click Run, type lusrmgr.msc, and then click OK.In the Local Users and Groups dialog box, click Groups, and then double-click Distributed COM Users.In the Distributed COM Users Properties dialog box, click Add.In the Select Users dialog box, type the user name under Enter the object names to select, and then click OK two times.On the server, grant theappropriate permissions for the MsDtsServer DCOM application. To do this, follow these steps:Click Start, click Run, type dcomcnfg, and then click OK.In the Component Services dialog box, expand Component Services, expand Computers, and then expand My Computer.Expand DCOM Config, right-click the MsDtsServer object, and then click Properties.In the MsDtsServer Properties dialog box, click the Security tab.Under Launch and Activation Permissions, click Customize, and then click Edit.In the Launch Permission dialog box, click Add.In the Select Users or Groups dialog box, type the user name under Enter the object names to select, and then click OK.In the Launch Permission dialog box, click the user name under Group or user names.Under Permissions for UserName, click to select the Allow check box for the following permissions:Local LaunchRemote LaunchLocal ActivationRemote ActivationNote UserName is a placeholder for the user name that you clicked in step h.Click OK.In the MsDtsServer Properties dialog box, click Customize under Access Permissions, and then click Edit.In the Access Permission dialog box, click Add.In the Select Users or Groups dialog box, type the user name under Enter the object names to select, and then click OK.In the Access Permission dialog box, click the user name under Group or user names.Under Permissions for UserName, click to select the Allow check box for the following permissions:Local AccessRemote AccessClick OK two times.Restart the SQL Server Integration Services service.

Symptoms
Cumulative Update 1 contains hotfixes for the Microsoft SQL Server 2008 issues that have been fixed since the release of SQL Server 2008.
Note This build of the cumulative update package is also known as build 10.00.1763.00.
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 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?(http://support.microsoft.com/kb/956909/) The SQL Server 2008 builds that were released after SQL Server 2008 was released
Important notes about the cumulative update packageSQL Server 2008 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.
Resolution
How to obtain Cumulative Update 1 for SQL Server 2008A 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 2008 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 package is available. If you do not see your language, it is because a cumulative update package is not available for that language.
SQL Server 2008 hotfixes that are included in Cumulative Update 1 for SQL Server 2008
Microsoft 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 Hotfix bug numberKnowledge Base article numberDescription50003171When you use a SAP client computer to view a SQL Server database, the database may be smaller than expected50003196957810?(http://support.microsoft.com/kb/957810/)FIX: In SQL Server 2008, a query returns incorrect results for the Date data type when you run the query on a partitioned table that uses data compression on only one of the partitions50003200957375?(http://support.microsoft.com/kb/957375/)FIX: A mirror server cannot fail over to a principal server in a SQL Server 2008 failover cluster50003202957811?(http://support.microsoft.com/kb/957811/)FIX: You receive an error message that states that the broker GUIDs do not match when you try to establish database mirroring in SQL Server 2008 or in SQL Server 200550003203957205?(http://support.microsoft.com/kb/957205/)FIX: An XML query that contains the @Table variable or the @XML variable takes a long time to complete in SQL Server 200850003224926292?(http://support.microsoft.com/kb/926292/)FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2008, the result is still returned in random order 50003238957814?(http://support.microsoft.com/kb/957814/)FIX: The result for the Sum or Count function returns an empty value when you query a SQL Server 2008 Analysis Services cube50003241957101?(http://support.microsoft.com/kb/957101/)FIX: Some lists that use visibility toggles may not work as expected when you upgrade to SQL Server 2008 Reporting Services50003242955719?(http://support.microsoft.com/kb/955719/)FIX: Some text characters are displayed as square glyphs in a report that you design or view by using SQL Server 2008 Reporting Services50003243958745?(http://support.microsoft.com/kb/958745/)FIX: Error message when you try to run or preview a very large report in Microsoft SQL Server 2008 Reporting Services: “Exception of type System.OutOfMemoryException was thrown”50003244957103?(http://support.microsoft.com/kb/957103/)FIX: Error message when you try to view a report in SQL Server 2008 Reporting Services: “Object reference not set to an instance of an object. (rsRuntimeErrorInExpression)”50003245FIX: SQL Server 2008 Reporting Services stops responding when you try to render a report in the Image format50003246957104?(http://support.microsoft.com/kb/957104/)FIX: When you try to run a report that has recursive hierarchy and that uses toggles in the hierarchy, you may receive unpredictable results in SQL Server 2008 Reporting Services50003247957107?(http://support.microsoft.com/kb/957107/)FIX: A dump file may be generated in the Reporting Services Logfiles folder and you may receive an error message when you try to render a report in SQL Server 2008 Reporting Services50003248957108?(http://support.microsoft.com/kb/957108/)FIX: The Gauge report item uses only one point after you add multiple points to the item in SQL Server 2008 Reporting Services50003249FIX: Some items are split over two pages when you export a report to a PDF in SQL Server 2008 Reporting Services and you set the KeepTogether property50003250The embedded Tablix row and column size is not 100% for cells that contain data when a Tablix is embedded inside another Tablix in SQL Server 2008 Reporting Services50003251FIX: An image that is nested in a Tablix cell in SQL Server 2008 Reporting Services is displayed incorrectly when the Sizing property of the image is set to AutoSize50003252957118?(http://support.microsoft.com/kb/957118/)FIX: Images in rows are not displayed correctly for static Tablix members in a SQL Server 2008 Reporting Services report50003253957111?(http://support.microsoft.com/kb/957111/)FIX: You receive an error message when you use the LoadReportDefinition API to view a drillthrough report or a subreport report in Report Builder in SQL Server 2008 Reporting Services50003254957120?(http://support.microsoft.com/kb/957120/)FIX: SQL Server 2008 Reporting Services interprets the Slant property as a positive slope50003255957112?(http://support.microsoft.com/kb/957112/)FIX: SQL Server 2008 Reporting Services may stop responding when you move a history snapshot or a linked report to a new folder location50003256957113?(http://support.microsoft.com/kb/957113/)FIX: Error message when you try to create a query against a Hyperion Essbase cube database: “OLAP error (1260046): Unknown Member PARENT_UNIQUE_NAME used in query”50003315956039?(http://support.microsoft.com/kb/956039/)FIX: Error message when you run an MDX query that uses the CREATE GLOBAL CUBE statement to create a local cube in SQL Server 2008 Analysis Services or in SQL Server 2005 Analysis Services: “The syntax for ‘<MDXFunctionName>’ is incorrect”50003316956376?(http://support.microsoft.com/kb/956376/)FIX: The SQL Server 2005 Distribution Agent and the SQL Server 2008 Distribution Agent do not skip error 20598 when you configure a SQL Server 2000 transactional publication to skip error 2059850003320954831?(http://support.microsoft.com/kb/954831/)FIX: In SQL Server 2008 or in SQL Server 2005, the session that runs the TRUNCATE TABLE statement may stop responding, and you cannot end the session50003325955896?(http://support.microsoft.com/kb/955896/)FIX: You cannot edit a component that has multiple inputs in a SQL Server 2008 or SQL Server 2005 Integration Services package50003330955372?(http://support.microsoft.com/kb/955372/)FIX: An incorrect aggregate value is returned when you run an MDX query against a parent/child dimension that has the HideMemberIf property set to ParentIsBlankSelfOrMissing in SQL Server 2008 or in SQL Server 200550003334FIX: Error message when you run an INSERT statement in SQL Server: “Cannot insert an explicit value into a timestamp column”50003336FIX: You cannot view calculated members in an Excel 2007 pivot table that references an OLAP table in SQL Server 2005 Analysis Services Service Pack 2 or in SQL Server 2008 Analysis Services50003339FIX: Error message when you run an MDX query in SQL Server 2008 Analysis Services: “The MDX function failed because the coordinate for the ‘<AttributeName>’ attribute contains a set”50003341955975?(http://support.microsoft.com/kb/955975/)FIX: Error message when you update a table at the subscriber in a transactional replication in SQL Server 2008: “Updateable Subscriptions: Rows do not match between Publisher and Subscriber” 50003342955958?(http://support.microsoft.com/kb/955958/)FIX: No rows are returned when you use the sp_replqueuemonitor stored procedure to list the queued messages for a queue-updating subscription in SQL Server50003344957872FIX: When you update rows by using a cursor in SQL Server 2008, the update may take a long time to finish50003345956036?(http://support.microsoft.com/kb/956036/)FIX: Error message when you process a partition from SQL Server 2005 Analysis Services Cumulative Update 7 or from the release version of SQL Server 2008 Analysis Services: “Detected inconsistency between User define slice and detected slice of partition”50003346FIX: You receive a “Current session is no longer valid” error message or an access violation occurs when you process a cube in SQL Server 2008 Analysis Services50003349FIX: Error message when you run an UPDATE statement against a table that has a DML trigger in SQL Server 2008: “An inconsistency was detected during an internal operation”50003350Analysis Services may stop responding when a NonEmpty clause causes many cell errors50003351957819?(http://support.microsoft.com/kb/957819/)FIX: A SQL Server 2008 Analysis Services server may stop responding when you try to run an MDX query that uses cell security50003352957820?(http://support.microsoft.com/kb/957820/)FIX: The mining model opens a blank task editor window when you try to deploy the Data Mining Model Training task in a SQL Server 2008 Integration Services project in Business Intelligence Development Studio50003360956718?(http://support.microsoft.com/kb/956718/)FIX: A MERGE statement may not enforce a foreign key constraint when the statement updates a unique key column that is not part of a clustering key and there is a single row as the update source in SQL Server 200850003364957277?(http://support.microsoft.com/kb/957277/)FIX: The IntelliSense feature does not work correctly for a database that uses the Turkish collation and that uses the case-insensitive collation sort order in SQL Server 200850003365956218?(http://support.microsoft.com/kb/956218/)FIX: A NullReferenceException error for T-SQL Debugger occurs when you use the SET SHOWPLAN_XML ON option in a Transact-SQL statement on an instance of SQL Server 200850003367957278?(http://support.microsoft.com/kb/957278/)FIX: The IntelliSense feature incorrectly completes the logical operators in the CASE WHEN clause in SQL Server 200850003368957239?(http://support.microsoft.com/kb/957239/)FIX: You receive an error message when you click the View Single Column Profile By Column button in the Data Profile Viewer in SQL Server 2008: “Unhandled Exception”50003369957279?(http://support.microsoft.com/kb/957279/)FIX: The IntelliSense feature stops working when you type a query that has a specific lexical combination in SQL Server Management Studio in SQL Server 200850003371957803?(http://support.microsoft.com/kb/957803/)FIX: You cannot start the Data Profile Viewer (DataProfileViewer.exe) in SQL Server 200850003373957281?(http://support.microsoft.com/kb/957281/)FIX: In SQL Server 2008, the IntelliSense feature may become unavailable when you type Transact-SQL statements in the Query Editor in SQL Server Management Studio50003382FIX: Error message when you start the SQL Server 2008 Reporting Services Configuration Manager: “Invalid namespace”50003383FIX: The SimSun font is not displayed correctly when you view a SQL Server 2008 Report Services report50003386957330?(http://support.microsoft.com/kb/957330/)FIX: Clients cannot connect to the Report Server Web service in SQL Server 2008 Reporting Services50003387FIX: Error message when you render a report in SQL Server 2008 Reporting Services: “A generic error occurred in GDI+”50003388957332?(http://support.microsoft.com/kb/957332/)FIX: Data disappears from a report that contains an inner group that is set to an initial state of “Hidden” in SQL Server 2008 Reporting Services50003389957333?(http://support.microsoft.com/kb/957333/)FIX: A SQL Server 2008 Reporting Services report may repaginate continually and consume 100% of CPU resources50003391957387?(http://support.microsoft.com/kb/957387/)FIX: No records may be returned when you call the SQLExecute function to execute a prepared statement and you use the SQL Native Client ODBC Driver in SQL Server 200850003393955814?(http://support.microsoft.com/kb/955814/)FIX: Error message when you install SQL Server 2008 Express edition on a domain controller that is running Windows Server 2003 SP2 or Windows Small Business Server 2003 SP1: “Exception has been thrown by the target of invocation”50003399956138?(http://support.microsoft.com/kb/956138/)You cannot upgrade a non-English instance of SQL Server 2000 Reporting Services to SQL Server 2008 Reporting Services50003400957805?(http://support.microsoft.com/kb/957805/)FIX: When you try to run SQL Server 2008 database engine repair from a DVD, the repair fails, and you may receive error messages50003401957453?(http://support.microsoft.com/kb/957453/)FIX: When you install SQL Server 2008, the installation fails, and the “Attributes do not match” error message is logged in the Summary.txt file50003402957804?(http://support.microsoft.com/kb/957804/)FIX: SQL Server Setup does not use the instance name that you provide in the modified Config.ini file when you try to install SQL Server 2008 Express50003407Data warehousing may stop collecting data when many time-outs occur50003409You receive a memory error message when you try to run SQL Server Setup from a network resource50003410You may be unable to uninstall a prepared instance of SQL Server 200850003411955949?(http://support.microsoft.com/kb/955949/)FIX: Cluster upgrade to SQL Server 2008 fails when SQL Server 2005 cluster nodes have different installed features50003412955948?(http://support.microsoft.com/kb/955948/)FIX: When you install a clustered instance of SQL Server 2008, account validation fails even though you have specified the correct domain account and password50003414957806?(http://support.microsoft.com/kb/957806/)FIX: The CompleteFailoverCluster action does not detect the correct SKU that is prepared by using the PrepareFailoverCluster action in SQL Server 200850003415957459?(http://support.microsoft.com/kb/957459/)FIX: Error message when you try to add a second node to a SQL Server 2008 failover cluster: “The current SKU is invalid”50003419957357?(http://support.microsoft.com/kb/957357/)FIX: You receive an error message that the file is being used by another process when you try to rename or move an output file from a job in SQL Server Agent in SQL Server 200850003427957807?(http://support.microsoft.com/kb/957807/)FIX: A new node is not added to a SQL Server 2008 Analysis Services cluster or a SQL Server 2008 Reporting Services cluster if the SQL Server 2008 Database Engine is not installed50003452957809?(http://support.microsoft.com/kb/957809/)FIX: Event ID 7904 is logged, and the SQL Server 2008 database is corrupted when you restore a SQL Server 2008 database from a sequence of transaction log backups50003453Whenyou programmatically retrieve data from a SQL Server 2008 database, the data in memory may be overwritten50003454The Service Broker connections between endpoints may experience a deadlock condition when the initiator queues contain many messages50003456957823?(http://support.microsoft.com/kb/957823/)FIX: The clustered index table may take longer than you expect to be rebuilt when you use the ALTER INDEX REBUILD statement in SQL Server 200850003458957816?(http://support.microsoft.com/kb/957816/)FIX: The Database Mirroring feature does not work on a SQL Server 2008-based mirror server when you perform a rolling upgrade on the mirror server50003460FIX: Extended Events session produces an empty value for data captured for certain actions50003467955943?(http://support.microsoft.com/kb/955943/)FIX: The Processes pane in the Activity Monitor incorrectly shows sessions as head blockers in SQL Server 200850003468When a SQL Server 2008 policy fileexecutes a WMI query, the policy always executes the query against the local server regardless of the intended target50003469957817?(http://support.microsoft.com/kb/957817/)FIX: You cannot expand the Facets node under the Policy Management node in SQL Server Management Studio in a non-English version of SQL Server 2008
Cumulative update package informationPrerequisites There are no prerequisites to apply this cumulative update package. 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 may not contain all the files that you must have to fully update a product to the latest build. This cumulative update contains only the files that you must have to correct the issue thatis listed in this article.
The English version of this cumulative update 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.32-bit versionsSQL Server 2008 Database Services Core Shared
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDistrib.exe2007.100.1763.078,36019-Sep-200809:43×86Dtspipeline.dll2007.100.1763.0697,36819-Sep-200809:43×86Microsoft.sqlserver.dmf.dll10.0.1763.0295,96019-Sep-200809:53×86Microsoft.sqlserver.management.collectortasks.dll10.0.1763.087,06419-Sep-200809:53×86Rdistcom.dll2007.100.1763.0652,31219-Sep-200810:00×86Replmerg.exe2007.100.1763.0344,08819-Sep-200810:00×86Sql_engine_core_shared_keyfile.dll2007.100.1763.016,92019-Sep-200809:52×86SQL Server 2008 Database Services Core Instance
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDatacollectorcontroller.dll2007.100.1763.0137,75219-Sep-200809:42×86Mssqlsystemresource.ldfNot applicable524,28818-Sep-200823:36Not applicableMssqlsystemresource.mdfNot applicable63,242,24018-Sep-200823:36Not applicableSql_engine_core_inst_keyfile.dll2007.100.1763.016,92019-Sep-200809:52×86Sqlagent.exe2007.100.1763.0369,68819-Sep-200810:14×86Sqlservr.exe2007.100.1763.041,003,03219-Sep-200810:14×86SQL Server 2008 Database Services Common Core
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformMsgprox.dll2007.100.1763.0204,82419-Sep-200809:53×86Replprov.dll2007.100.1763.0578,58419-Sep-200810:00×86Replrec.dll2007.100.1763.0793,11219-Sep-200810:00×86Sql_common_core_keyfile.dll2007.100.1763.016,92019-Sep-200809:52×86Xmlsub.dll2007.100.1763.0195,60819-Sep-200810:15×86SQL Server 2008 Business Intelligence Development Studio
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDataprofileviewer.exe10.0.1763.0316,44019-Sep-200809:42×86Dtspipeline.dll2007.100.1763.0697,36819-Sep-200809:43×86Microsoft.datatransformationservices.design.dll10.0.1763.04,236,31219-Sep-200809:53×86Microsoft.reportingservices.dataextensions.xmlaclient.dll10.0.1763.0566,29619-Sep-200809:53×86Microsoft.reportingservices.diagnostics.dll10.0.1763.0902,16819-Sep-200809:53×86Microsoft.reportingservices.hpbprocessing.dll10.0.1763.0287,76819-Sep-200809:53×86Microsoft.reportingservices.htmlrendering.dll10.0.1763.0197,65619-Sep-200809:53×86Microsoft.reportingservices.imagerendering.dll10.0.1763.0144,40819-Sep-200809:53×86Microsoft.reportingservices.processingcore.dll10.0.1763.04,342,80819-Sep-200809:53×86Microsoft.reportingservices.processingobjectmodel.dll10.0.1763.095,25619-Sep-200809:53×86Microsoft.reportingservices.rdlobjectmodel.dll10.0.1763.0832,53619-Sep-200809:53×86Microsoft.reportingservices.richtext.dll10.0.1763.0103,44819-Sep-200809:53×86Microsoft.reportingservices.spbprocessing.dll10.0.1763.0246,80819-Sep-200809:53×86Microsoft.reportingservices.wordrendering.dll10.0.1763.0230,42419-Sep-200809:53×86Msmdlocal.dll10.0.1763.023,455,25619-Sep-200809:53×86Msmgdsrv.dll10.0.1763.08,560,66419-Sep-200809:53×86Sql_bids_keyfile.dll2007.100.1763.016,92019-Sep-200809:52×86SQL Server 2008 Analysis Services
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformMsmdlocal.dll10.0.1763.023,455,25619-Sep-200809:53×86Msmdsrv.exe10.0.1763.021,949,97619-Sep-200809:53×86Msmgdsrv.dll10.0.1763.08,560,66419-Sep-200809:53×86Sql_as_keyfile.dll2007.100.1763.016,92019-Sep-200809:52×86SQL Server 2008 Integration Services
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDtspipeline.dll2007.100.1763.0697,36819-Sep-200809:43×86Sql_is_keyfile.dll2007.100.1763.016,92019-Sep-200809:52×86SQL Server 2008 Reporting Services
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformMicrosoft.reportingservices.dataextensions.xmlaclient.dll10.0.1763.0566,29619-Sep-200809:53×86Microsoft.reportingservices.diagnostics.dll10.0.1763.0902,16819-Sep-200809:53×86Microsoft.reportingservices.hpbprocessing.dll10.0.1763.0287,76819-Sep-200809:53×86Microsoft.reportingservices.htmlrendering.dll10.0.1763.0197,65619-Sep-200809:53×86Microsoft.reportingservices.imagerendering.dll10.0.1763.0144,40819-Sep-200809:53×86Microsoft.reportingservices.processingcore.dll10.0.1763.04,342,80819-Sep-200809:53×86Microsoft.reportingservices.processingobjectmodel.dll10.0.1763.095,25619-Sep-200809:53×86Microsoft.reportingservices.rdlobjectmodel.dll10.0.1763.0832,53619-Sep-200809:53×86Microsoft.reportingservices.richtext.dll10.0.1763.0103,44819-Sep-200809:53×86Microsoft.reportingservices.spbprocessing.dll10.0.1763.0246,80819-Sep-200809:53×86Microsoft.reportingservices.wordrendering.dll10.0.1763.0230,42419-Sep-200809:53×86Msmgdsrv.dll10.0.1763.08,560,66419-Sep-200809:53×86Reportingservicesservice.exe2007.100.1763.01,106,96819-Sep-200810:00×86Reportingserviceswebserver.dll10.0.1763.01,905,68819-Sep-200810:00×86Reportingserviceswebuserinterface.dll10.0.1763.01,610,77619-Sep-200810:00×86Rsconfigtool.exe10.0.1763.01,201,17619-Sep-200810:08×86Sql_rs_keyfile.dll2007.100.1763.016,92019-Sep-200809:52×86SQL Server 2008 Management Studio
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDataprofileviewer.exe10.0.1763.0316,44019-Sep-200809:42×86Dtspipeline.dll2007.100.1763.0697,36819-Sep-200809:43×86Microsoft.datatransformationservices.design.dll10.0.1763.04,236,31219-Sep-200809:53×86Microsoft.reportingservices.diagnostics.dll10.0.1763.0902,16819-Sep-200809:53×86Microsoft.sqlserver.dmf.dll10.0.1763.0295,96019-Sep-200809:53×86Microsoft.sqlserver.management.collectortasks.dll10.0.1763.087,06419-Sep-200809:53×86Microsoft.sqlserver.management.resourcemonitorwidgets.dll10.0.1763.0394,26419-Sep-200809:53×86Microsoft.sqlserver.sqlparser.dll10.0.1763.02,151,44819-Sep-200809:53×86Objectexplorer.dll10.0.1763.03,253,27219-Sep-200809:54×86Radlangsvc.dll10.0.1763.0123,92819-Sep-200810:00×86Rsconfigtool.exe10.0.1763.01,201,17619-Sep-200810:08×86Sql_ssms_keyfile.dll2007.100.1763.016,92019-Sep-200809:52×86Sqleditors.dll10.0.1763.01,225,75219-Sep-200810:14×86SQL Server 2008 Tools and Workstation Components
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDtspipeline.dll2007.100.1763.0697,36819-Sep-200809:43×86Microsoft.sqlserver.chainer.infrastructure.dll10.0.1763.0230,42419-Sep-200809:53×86Microsoft.sqlserver.configuration.sco.dll10.0.1763.01,303,57619-Sep-200809:53×86Microsoft.sqlserver.configuration.sstring.dll10.0.1763.024,60019-Sep-200809:53×86Msmdlocal.dll10.0.1763.023,455,25619-Sep-200809:53×86Msmgdsrv.dll10.0.1763.08,560,66419-Sep-200809:53×86Sql_tools_keyfile.dll2007.100.1763.016,92019-Sep-200809:52×86SQL Server 2008 Native Client
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformSqlncli10.dll2007.100.1763.02,460,18419-Sep-200810:14×86Sqlncli_keyfile.dll2007.100.1763.016,92019-Sep-200809:52×86x64-basedversionsSQL Server 2008 Database Services Core Shared
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDistrib.exe2007.100.1763.090,13619-Sep-200818:55×64Dtspipeline.dll2007.100.1763.01,090,07219-Sep-200818:55×64Microsoft.sqlserver.dmf.dll10.0.1763.0295,96019-Sep-200809:53×86Microsoft.sqlserver.dmf.dll10.0.1763.0295,96019-Sep-200819:20×86Microsoft.sqlserver.management.collectortasks.dll10.0.1763.087,06419-Sep-200819:20×86Rdistcom.dll2007.100.1763.0790,55219-Sep-200819:21×64Replmerg.exe2007.100.1763.0411,67219-Sep-200819:21×64Sql_engine_core_shared_keyfile.dll2007.100.1763.017,43219-Sep-200819:19×64SQL Server 2008 Database Services Core Instance
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDatacollectorcontroller.dll2007.100.1763.0258,07219-Sep-200818:48×64Mssqlsystemresource.ldfNot applicable524,28818-Sep-200823:36Not applicableMssqlsystemresource.mdfNot applicable63,242,24018-Sep-200823:36Not applicableSql_engine_core_inst_keyfile.dll2007.100.1763.017,43219-Sep-200819:19×64Sqlagent.exe2007.100.1763.0430,61619-Sep-200819:02×64Sqlservr.exe2007.100.1763.057,825,81619-Sep-200819:02×64SQL Server 2008 Database Services Common Core
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformMsgprox.dll2007.100.1763.0204,82419-Sep-200809:53×86Msgprox.dll2007.100.1763.0248,85619-Sep-200819:20×64Replprov.dll2007.100.1763.0578,58419-Sep-200810:00×86Replprov.dll2007.100.1763.0730,64819-Sep-200819:21×64Replrec.dll2007.100.1763.0793,11219-Sep-200810:00×86Replrec.dll2007.100.1763.0979,99219-Sep-200819:21×64Sql_common_core_keyfile.dll2007.100.1763.017,43219-Sep-200819:19×64Xmlsub.dll2007.100.1763.0195,60819-Sep-200810:15×86Xmlsub.dll2007.100.1763.0311,32019-Sep-200819:02×64SQL Server 2008 Business Intelligence Development Studio
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDataprofileviewer.exe10.0.1763.0316,44019-Sep-200809:42×86Dtspipeline.dll2007.100.1763.0697,36819-Sep-200809:43×86Microsoft.datatransformationservices.design.dll10.0.1763.04,236,31219-Sep-200809:53×86Microsoft.reportingservices.dataextensions.xmlaclient.dll10.0.1763.0566,29619-Sep-200809:53×86Microsoft.reportingservices.diagnostics.dll10.0.1763.0902,16819-Sep-200809:53×86Microsoft.reportingservices.hpbprocessing.dll10.0.1763.0287,76819-Sep-200809:53×86Microsoft.reportingservices.htmlrendering.dll10.0.1763.0197,65619-Sep-200809:53×86Microsoft.reportingservices.imagerendering.dll10.0.1763.0144,40819-Sep-200809:53×86Microsoft.reportingservices.processingcore.dll10.0.1763.04,342,80819-Sep-200809:53×86Microsoft.reportingservices.processingobjectmodel.dll10.0.1763.095,25619-Sep-200809:53×86Microsoft.reportingservices.rdlobjectmodel.dll10.0.1763.0832,53619-Sep-200809:53×86Microsoft.reportingservices.richtext.dll10.0.1763.0103,44819-Sep-200809:53×86Microsoft.reportingservices.spbprocessing.dll10.0.1763.0246,80819-Sep-200809:53×86Microsoft.reportingservices.wordrendering.dll10.0.1763.0230,42419-Sep-200809:53×86Msmdlocal.dll10.0.1763.023,455,25619-Sep-200809:53×86Msmdlocal.dll10.0.1763.044,450,32819-Sep-200819:20×64Msmgdsrv.dll10.0.1763.08,560,66419-Sep-200809:53×86Msmgdsrv.dll10.0.1763.012,334,10419-Sep-200819:20×64Sql_bids_keyfile.dll2007.100.1763.017,43219-Sep-200819:19×64SQL Server 2008 Analysis Services
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformMsmdlocal.dll10.0.1763.023,455,25619-Sep-200809:53×86Msmdlocal.dll10.0.1763.044,450,32819-Sep-200819:20×64Msmdsrv.exe10.0.1763.043,728,40819-Sep-200819:20×64Msmgdsrv.dll10.0.1763.08,560,66419-Sep-200809:53×86Msmgdsrv.dll10.0.1763.012,334,10419-Sep-200819:20×64Sql_as_keyfile.dll2007.100.1763.017,43219-Sep-200819:19×64SQL Server 2008 Integration Services
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDtspipeline.dll2007.100.1763.01,090,07219-Sep-200818:55×64Sql_is_keyfile.dll2007.100.1763.017,43219-Sep-200819:19×64SQL Server 2008 Reporting Services
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformMicrosoft.reportingservices.dataextensions.xmlaclient.dll10.0.1763.0566,29619-Sep-200819:20×86Microsoft.reportingservices.diagnostics.dll10.0.1763.0902,16819-Sep-200819:20×86Microsoft.reportingservices.hpbprocessing.dll10.0.1763.0287,76819-Sep-200819:20×86Microsoft.reportingservices.htmlrendering.dll10.0.1763.0197,65619-Sep-200819:20×86Microsoft.reportingservices.imagerendering.dll10.0.1763.0144,40819-Sep-200819:20×86Microsoft.reportingservices.processingcore.dll10.0.1763.04,342,80819-Sep-200819:20×86Microsoft.reportingservices.processingobjectmodel.dll10.0.1763.095,25619-Sep-200819:20×86Microsoft.reportingservices.rdlobjectmodel.dll10.0.1763.0832,53619-Sep-200819:20×86Microsoft.reportingservices.richtext.dll10.0.1763.0103,44819-Sep-200819:20×86Microsoft.reportingservices.spbprocessing.dll10.0.1763.0246,80819-Sep-200819:20×86Microsoft.reportingservices.wordrendering.dll10.0.1763.0230,42419-Sep-200819:20×86Msmgdsrv.dll10.0.1763.012,334,10419-Sep-200819:20×64Reportingservicesservice.exe2007.100.1763.02,045,46419-Sep-200819:21×64Reportingserviceswebserver.dll10.0.1763.01,905,68819-Sep-200819:21×86Reportingserviceswebuserinterface.dll10.0.1763.01,610,77619-Sep-200819:21×86Rsconfigtool.exe10.0.1763.01,201,17619-Sep-200810:08×86Sql_rs_keyfile.dll2007.100.1763.017,43219-Sep-200819:19×64SQL Server 2008 Management Studio
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDataprofileviewer.exe10.0.1763.0316,44019-Sep-200809:42×86Dtspipeline.dll2007.100.1763.0697,36819-Sep-200809:43×86Microsoft.datatransformationservices.design.dll10.0.1763.04,236,31219-Sep-200809:53×86Microsoft.reportingservices.diagnostics.dll10.0.1763.0902,16819-Sep-200809:53×86Microsoft.sqlserver.dmf.dll10.0.1763.0295,96019-Sep-200809:53×86Microsoft.sqlserver.dmf.dll10.0.1763.0295,96019-Sep-200819:20×86Microsoft.sqlserver.management.collectortasks.dll10.0.1763.087,06419-Sep-200809:53×86Microsoft.sqlserver.management.resourcemonitorwidgets.dll10.0.1763.0394,26419-Sep-200809:53×86Microsoft.sqlserver.sqlparser.dll10.0.1763.02,151,44819-Sep-200809:53×86Objectexplorer.dll10.0.1763.03,253,27219-Sep-200809:54×86Radlangsvc.dll10.0.1763.0123,92819-Sep-200810:00×86Rsconfigtool.exe10.0.1763.01,201,17619-Sep-200810:08×86Sql_ssms_keyfile.dll2007.100.1763.017,43219-Sep-200819:19×64Sqleditors.dll10.0.1763.01,225,75219-Sep-200810:14×86SQL Server 2008 Tools and Workstation Components
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDtspipeline.dll2007.100.1763.0697,36819-Sep-200809:43×86Dtspipeline.dll2007.100.1763.01,090,07219-Sep-200818:55×64Microsoft.sqlserver.chainer.infrastructure.dll10.0.1763.0230,42419-Sep-200819:20×86Microsoft.sqlserver.configuration.sco.dll10.0.1763.01,303,57619-Sep-200819:20×86Microsoft.sqlserver.configuration.sstring.dll10.0.1763.024,60019-Sep-200819:20×86Msmdlocal.dll10.0.1763.023,455,25619-Sep-200809:53×86Msmdlocal.dll10.0.1763.044,450,32819-Sep-200819:20×64Msmgdsrv.dll10.0.1763.08,560,66419-Sep-200809:53×86Msmgdsrv.dll10.0.1763.012,334,10419-Sep-200819:20×64Sql_tools_keyfile.dll2007.100.1763.017,43219-Sep-200819:19×64SQL Server 2008 Native Client
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformSqlncli10.dll2007.100.1763.02,460,18419-Sep-200810:14×86Sqlncli10.dll2007.100.1763.03,158,55219-Sep-200819:02×64Sqlncli_keyfile.dll2007.100.1763.017,43219-Sep-200819:19×64Itanium-based versionsSQL Server 2008 Database Services Core Shared
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDistrib.exe2007.100.1763.0208,92019-Sep-200823:37IA-64Dtspipeline.dll2007.100.1763.02,023,96019-Sep-200823:37IA-64Microsoft.sqlserver.dmf.dll10.0.1763.0295,96019-Sep-200809:53×86Microsoft.sqlserver.dmf.dll10.0.1763.0295,96019-Sep-200823:44×86Microsoft.sqlserver.management.collectortasks.dll10.0.1763.087,06419-Sep-200823:44×86Rdistcom.dll2007.100.1763.01,832,47219-Sep-200823:51IA-64Replmerg.exe2007.100.1763.0972,82419-Sep-200823:51IA-64Sql_engine_core_shared_keyfile.dll2007.100.1763.022,55219-Sep-200823:44IA-64SQL Server 2008 Database Services Core Instance
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDatacollectorcontroller.dll2007.100.1763.0474,13619-Sep-200823:37IA-64Mssqlsystemresource.ldfNot applicable524,28818-Sep-200823:36Not applicableMssqlsystemresource.mdfNot applicable63,242,24018-Sep-200823:36Not applicableSql_engine_core_inst_keyfile.dll2007.100.1763.022,55219-Sep-200823:44IA-64Sqlagent.exe2007.100.1763.01,203,22419-Sep-200823:58IA-64Sqlservr.exe2007.100.1763.0110,867,48019-Sep-200823:58IA-64SQL Server 2008 Database Services Common Core
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformMsgprox.dll2007.100.1763.0204,82419-Sep-200809:53×86Msgprox.dll2007.100.1763.0536,60019-Sep-200823:45IA-64Replprov.dll2007.100.1763.0578,58419-Sep-200810:00×86Replprov.dll2007.100.1763.01,644,05619-Sep-200823:51IA-64Replrec.dll2007.100.1763.0793,11219-Sep-200810:00×86Replrec.dll2007.100.1763.02,127,38419-Sep-200823:51IA-64Sql_common_core_keyfile.dll2007.100.1763.022,55219-Sep-200823:44IA-64Xmlsub.dll2007.100.1763.0195,60819-Sep-200810:15×86Xmlsub.dll2007.100.1763.0562,20019-Sep-200823:58IA-64SQL Server 2008 Analysis Services
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformMsmdlocal.dll10.0.1763.023,455,25619-Sep-200809:53×86Msmdlocal.dll10.0.1763.057,500,69619-Sep-200823:45IA-64Msmdsrv.exe10.0.1763.058,850,84019-Sep-200823:45IA-64Msmgdsrv.dll10.0.1763.08,560,66419-Sep-200809:53×86Msmgdsrv.dll10.0.1763.015,485,97619-Sep-200823:45IA-64Sql_as_keyfile.dll2007.100.1763.022,55219-Sep-200823:44IA-64SQL Server 2008 Integration Services
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDtspipeline.dll2007.100.1763.02,023,96019-Sep-200823:37IA-64Sql_is_keyfile.dll2007.100.1763.022,55219-Sep-200823:44IA-64SQL Server 2008 Reporting Services
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformMicrosoft.reportingservices.dataextensions.xmlaclient.dll10.0.1763.0566,29619-Sep-200823:44×86Microsoft.reportingservices.diagnostics.dll10.0.1763.0902,16819-Sep-200823:44×86Microsoft.reportingservices.hpbprocessing.dll10.0.1763.0287,76819-Sep-200823:44×86Microsoft.reportingservices.htmlrendering.dll10.0.1763.0197,65619-Sep-200823:44×86Microsoft.reportingservices.imagerendering.dll10.0.1763.0144,40819-Sep-200823:44×86Microsoft.reportingservices.processingcore.dll10.0.1763.04,342,80819-Sep-200823:44×86Microsoft.reportingservices.processingobjectmodel.dll10.0.1763.095,25619-Sep-200823:44×86Microsoft.reportingservices.rdlobjectmodel.dll10.0.1763.0832,53619-Sep-200823:44×86Microsoft.reportingservices.richtext.dll10.0.1763.0103,44819-Sep-200823:44×86Microsoft.reportingservices.spbprocessing.dll10.0.1763.0246,80819-Sep-200823:44×86Microsoft.reportingservices.wordrendering.dll10.0.1763.0230,42419-Sep-200823:44×86Msmgdsrv.dll10.0.1763.015,485,97619-Sep-200823:45IA-64Reportingservicesservice.exe2007.100.1763.03,360,28019-Sep-200823:51IA-64Reportingserviceswebserver.dll10.0.1763.01,905,68819-Sep-200823:51×86Reportingserviceswebuserinterface.dll10.0.1763.01,610,77619-Sep-200823:51×86Rsconfigtool.exe10.0.1763.01,201,17619-Sep-200810:08×86Sql_rs_keyfile.dll2007.100.1763.022,55219-Sep-200823:44IA-64SQL Server 2008 Management Studio
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDataprofileviewer.exe10.0.1763.0316,44019-Sep-200809:42×86Dtspipeline.dll2007.100.1763.0697,36819-Sep-200809:43×86Microsoft.datatransformationservices.design.dll10.0.1763.04,236,31219-Sep-200809:53×86Microsoft.reportingservices.diagnostics.dll10.0.1763.0902,16819-Sep-200809:53×86Microsoft.sqlserver.dmf.dll10.0.1763.0295,96019-Sep-200809:53×86Microsoft.sqlserver.dmf.dll10.0.1763.0295,96019-Sep-200823:44×86Microsoft.sqlserver.management.collectortasks.dll10.0.1763.087,06419-Sep-200809:53×86Microsoft.sqlserver.management.resourcemonitorwidgets.dll10.0.1763.0394,26419-Sep-200809:53×86Microsoft.sqlserver.sqlparser.dll10.0.1763.02,151,44819-Sep-200809:53×86Objectexplorer.dll10.0.1763.03,253,27219-Sep-200809:54×86Radlangsvc.dll10.0.1763.0123,92819-Sep-200810:00×86Rsconfigtool.exe10.0.1763.01,201,17619-Sep-200810:08×86Sql_ssms_keyfile.dll2007.100.1763.022,55219-Sep-200823:44IA-64Sqleditors.dll10.0.1763.01,225,75219-Sep-200810:14×86SQL Server 2008 Tools and Workstation Components
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformDtspipeline.dll2007.100.1763.0697,36819-Sep-200809:43×86Dtspipeline.dll2007.100.1763.02,023,96019-Sep-200823:37IA-64Microsoft.sqlserver.chainer.infrastructure.dll10.0.1763.0230,42419-Sep-200823:44×86Microsoft.sqlserver.configuration.sco.dll10.0.1763.01,303,57619-Sep-200823:44×86Microsoft.sqlserver.configuration.sstring.dll10.0.1763.024,60019-Sep-200823:44×86Msmdlocal.dll10.0.1763.023,455,25619-Sep-200809:53×86Msmdlocal.dll10.0.1763.057,500,69619-Sep-200823:45IA-64Msmgdsrv.dll10.0.1763.08,560,66419-Sep-200809:53×86Msmgdsrv.dll10.0.1763.015,485,97619-Sep-200823:45IA-64Sql_tools_keyfile.dll2007.100.1763.022,55219-Sep-200823:44IA-64SQL Server 2008 Native Client
Collapse this tableExpand this table
File nameFile versionFile sizeDateTimePlatformSqlncli10.dll2007.100.1763.02,460,18419-Sep-200810:14×86Sqlncli10.dll2007.100.1763.06,347,80019-Sep-200823:58IA-64Sqlncli_keyfile.dll2007.100.1763.022,55219-Sep-200823:44IA-64

Symptoms
In Microsoft SQL Server 2000, when you run a query that contains a RIGHT OUTER JOIN clause, you may receive an error message that is similar to the following:

ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 52 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Connection Broken
Resolution
Service pack informationTo resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
290211?(http://support.microsoft.com/kb/290211/) How to obtain the latest SQL Server 2000 service pack

Symptoms
When you install a Microsoft SQL Server 2005 service pack, cumulative update, or cluster hotfix, the installation fails. When this problem occurs, an error message that resembles the following is logged in the Summary.txt file:

Machine: ServerName
Product: Client Components
Error: Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll in the COM+ catalog.
Error: -2146233087
Error message: Unknown error 0×80131501
Error description: The Transaction Manager is not available. (Exception from HRESULT: 0×8004D01B)Note The Summary.txt file is located under the following folder:
%ProgramFiles%\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\HotfixAdditionally, an error message that resembles the following is logged in the SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log file:

MSI (s) (9C!38) [17:51:18:649]: Product: Microsoft SQL Server 2005 Tools — Error 29549. Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0×8013150
Error description: The Transaction Manager is not available. (Exception from HRESULT: 0×8004D01B)
Error 29549. Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0×8013150
Error description: The Transaction Manager is not available. (Exception from HRESULT: 0×8004D01B)Note The SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log file is located under the following folder:
%ProgramFiles%\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
Resolution
This problem occurs because the SQL Server Setup program cannot access the Microsoft Distributed Transaction Coordinator (MS DTC) service.

Symptoms
Although the MSSQLServer service does not stop, the Microsoft Operations Manager (MOM) 2005 Operator Console contains a Critical Error severity alert that is similar to the following alert:

Name: The MSSQLServer service terminated unexpectedlySeverity: Critical ErrorResolution State: NewDomain: WORKGROUPComputer: ComputerNameTime of First Event: TimeTime of Last Event: TimeAlert latency: 1 secProblem State: InvestigateRepeat Count: 3Age:Source: MSSQLSERVERAlert Id: 390da845-d0c7-4570-b895-cb265d13addaRule (enabled): Microsoft SQL Server\SQL Server 2000\SQL Server 2000 Event Collection\SQL Server General\The MSSQLServer service terminated unexpectedlyDescription: SqlDumpExceptionHandler: Process 56 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
Resolution
This issue occurs when the following conditions are true: You enable the The MSSQLServer service terminated unexpectedly event rule. This event rule has the following criteria in the MOM 2005 Administrator Console: The Event Number event property matches the following code:

regex ^(17052|17055)$The Source Name event property matches the following code:

wildcard MSSQL*The Description event property matches the following code:

substring Error: 0, Severity: 19, State: 0You receive an error message that has a severity level 19 in Microsoft SQL Server 2000 that is similar to the following error message:

ODBC: Msg 0. Level 19, State 1SqlDumpExceptionHandler: Process 56 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.Connection Broken

Symptoms
In Microsoft Windows Server 2003 with Service Pack 1 (SP1), a program that uses structured exception handling may stop responding for several seconds. Programs that use structured exception handling include Microsoft SQL Server.
Resolution
This problem occurs because Windows Server 2003 SP1 includes a change to the memory manager. This change may make the validation process of exception handling routines take a long time if the following conditions are true:The computer has lots of physical RAM.The process loader lock is held by one thread.Multiple exceptions occur at the same time.In these conditions, several threads wait for the memory manager, and the program stops responding for several seconds.