SQL hotfix bug number | Knowledge Base article number | Description |
50000927 | | FIX: Partitions that has the proactive caching feature enabled may return values that exceed the values in the data source in SQL Server 2005 Analysis Services |
50000923 | 935829 | FIX: You receive incorrect results when you run an MDX query against a dimension that contains a parent-child hierarchy in SQL Server 2005 Analysis Services |
50001018 | 938087 | FIX: You experience problems when you use SQL Server Business Intelligence Development Studio to create an SSIS package after you install SQL Server 2005 Service Pack 2 |
50000885 | 935832 | FIX: You cannot cancel an MDX query that runs for a long time in SQL Server 2005 Analysis Services |
50000925 | 936262 | FIX: When you run an MDX query for the second time, the query does not run faster than the first time that you ran the query in SQL Server 2005 Analysis Services |
50000898 | 936261 | FIX: The process stops responding and the CPU utilization reaches 100 percent when you process a partition in SQL Server 2005 Analysis Services |
50000899 | 935831 | FIX: The operation takes a long time to be completed when you process a partition that has proactive caching enabled in SQL Server 2005 Analysis Services |
50000802 | 932180 | FIX: The Cluster Discrimination tab is empty when you browse a clustering model of SQL Server 2005 Analysis Services in SQL Server BIDS |
50000924 | 936863 | FIX: Some MDX queries may run slower and consume more memory after you install SQL Server 2005 Analysis Services Service Pack 2 |
50000732 | 932331 | FIX: Error message when you try to build a mining model that contains lots of data on a 32-bit SQL Server 2005 Analysis Services server: "Memory error: Allocation failure: Not enough storage is available to the process command" |
50000926 | 935360 | FIX: Error message when you run an MDX query that retrieves data from an Analysis Services database: "An error occurred while the dimension, with the ID of '<DatabaseName>', Name of '<DimensionName>' was being processed" |
50001001 | 932610 | FIX: Error message when you run an MDX query in SQL Server 2005 Analysis Services: "An unexpected error occurred (file 'pffilestore.cpp', line 3267, function 'PFFileStore::HandleDataPageFault')" |
50000920 | 935341 | FIX: Error message when you run an MDX query against a measure in SQL Server 2005 Analysis Services: "An internal error has occurred" |
50000726 | 932106 | FIX: Error message when you run a DMX query that uses a linked server to query data from a Microsoft SQL Server 2005 Analysis Services server: "The following system error occurred: Logon failure: unknown user name or bad password" |
50000883 | 933519 | FIX: Error message when the Log Reader Agent runs for a transactional publication in SQL Server 2005: "Invalid Text Info Block for UpdateText" |
50000890 | 936254 | FIX: An MDX query may be slow if it reads from an aggregation that has less than 4,096 records in SQL Server 2005 Analysis Services |
50000871 | 935830 | FIX: A server may start slowly if you have SQL Server 2005 Analysis Services installed and if many objects are stored on the server |
50001017 | 938085 | A clean-up task does not delete database maintenance plan reports after you install SQL Server 2005 Service Pack 2 |
50001042 | | A System.FormatException exception occurs in a .NET Framework 2.0 application when you use the ADOMD.NET data provider to retrieve numeric data from SQL Server 2005 Analysis Services |
50001096 | | An exception occurs when you open the query builder in SQL Server 2005 Reporting Services on a computer that is running a Spanish version of Microsoft Windows |
50001054 | | After you install SQL Server 2005 Service Pack 2, the granularity of subcube requests appears to be at the key attribute of parent/child dimensions, and you experience slow performance when you query the parent/child dimension in SQL Server 2005 Analysis Services |
50001100 | 933762 | FIX: You receive error 18815 when the Log Reader Agent runs for a transactional publication in SQL Server 2005 |
50001041 | 932608 | FIX: You obtain an incorrect prediction when you browse a mining structure that is created by using the Microsoft Association algorithm in SQL Server 2005 Analysis Services |
50001122 | 936968 | FIX: You may receive incorrect results when you run a Multidimensional Expressions (MDX) query and the WHERE clause and the SELECT clause in the query contain different attributes of the same dimension in SQL Server 2005 Analysis Services |
50001141 | 933265 | FIX: You may receive error 1203 when you run an INSERT statement against a table that has an identity column in SQL Server 2005 |
50001095 | 932393 | FIX: You may experience poor performance after you install SQL Server 2005 Service Pack 1 |
50001094 | 932990 | FIX: You cannot obtain statements in the current batch in SQL Server 2005 by using the DBCC INPUTBUFFER statement, trace flag 1204, deadlock graph event class, or Activity Monitor |
50001140 | 934066 | FIX: The row of data on the publisher and the row of data on the subscriber may be inconsistent in a merge publication after synchronization has occurred in SQL Server 2005 |
50001126 | 936080 | FIX: Some values of measures in a cube unexpectedly appear as "#N/A" when you enable the "Enable read-contingent permissions" option for the cube in SQL Server 2005 Analysis Services Service Pack 2 |
50001040 | 932609 | FIX: Error message when you use the Association Rules algorithm to process a data mining model in SQL Server 2005 Analysis Services: "This number of attributes exceeds the attribute limit of 5000 allowed by the current version of the algorithm" |
50001046 | 934713 | FIX: Error message when you run the CHECKPOINT statement after you restore a database that has a read-only user-defined filegroup in SQL Server 2005: "The operating system returned error 5(Access is denied.) to SQL Server" |
50001045 | 938913 | FIX: Error message when you run a maintenance plan that contains a Back Up Database task in Microsoft SQL Server 2005 Service Pack 2: "0x80004003: Object reference not set to an instance of an object" |
50001056 | 935922 | FIX: Error message when you install Microsoft Dynamics CRM:"Setup failed to validate specified Reporting Services Report Server" or "Setup requires SQL Server Reporting Services 2005 Hotfix for role creation on SQL Reporting Service SP2 Workgroup edition" |
50001101 | 934065 | FIX: Error message when the Replication Merge Agent runs to synchronize a merge replication subscription in SQL Server 2005: "The merge process failed to execute a query because the query timed out" |
50001020 | 936185 | FIX: Blocking and performance problems may occur when you enable trace flag 1118 in SQL Server 2005 if the temporary table creation workload is high |
50001024 | 934734 | FIX: A database is marked as suspect when you update a table that contains a nonclustered index in SQL Server 2005 |
50001180 | 936488 | When you install a SQL Server 2005 service pack or a SQL Server 2005 hotfix, the installation stops unexpectedly |
50001184 | 938748 | FIX: You obtain inconsistent results when you run an MDX query that uses the Siblings function against an instance of SQL Server 2005 Analysis Services compared to an instance of SQL Server 2000 Analysis Services |
50001230 | 926292 | FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2005, the result is still returned in random order |
50001207 | 937090 | FIX: The Report Designer or the Report Manager stops responding when you try to export a SQL Server 2005 Reporting Services report to a PDF file or a TIFF file |
50001217 | 938077 | FIX: The client application stops responding, and the Msmdsrv.exe process uses all the available memory after you perform the filtering operation and the browsing operation against an instance of SQL Server 2005 Analysis Services |
50001253 | 938911 | FIX: Event ID: 21421 occurs when you use the Microsoft Operations Manager 2005 agent to monitor a clustered instance of SQL Server 2005 in a clustered environment |
50001256 | 938102 | FIX: Error messages when you run a query that references a view in SQL Server 2005 Service Pack 2: "A severe error occurred on the current command. The results, if any, should be discarded" |
50001186 | 936223 | FIX: Error messages when you run a query against a linked server that you create in SQL Server 2005: "Statement(s) could not be prepared" and "The column prefix '<column_prefix_name>' does not match with a table name or alias name used in the query" |
50001192 | 936253 | FIX: Error messages are logged, and some threads may not sort the data successfully if many threads are displaying a report in SQL Server 2005 Reporting Services |
50001212 | | FIX: Error message when you use the Playback Capture Wizard (PCW) to capture a backup of a database that is larger than 2 terabytes: "Unable to obtain required information about the server" |
50001232 | 936728 | FIX: Error message when you run a SQL Server 2005 Integration Services (SSIS) package that contains a Fuzzy Lookup transformation: "System.Data.SqlClient.SqlException Error number 8101 is invalid" |
50001248 | 937033 | FIX: Error message when you run a linked server query in SQL Server 2005: "The oledbprovider unisys.dmsII.1 for linkserver '<ServerName>' reported an error the provider ran out of memory" |
50001235 | 938750 | FIX: Error message when you connect to an instance of SQL Server 2005 Analysis Services after you cancel an MDX query that has been running for a long time: "A connection attempt failed because the connected party did not properly respond" |
50001158 | 936534 | FIX: Error message when the Distribution Agent tries to apply the snapshot to the subscriber in SQL Server 2005: "Must declare the scalar variable "@Variable"" |
50001251 | 937041 | FIX: Changes in the publisher database are not replicated to the subscribers in a transactional replication if the publisher database runs exposed in a database mirroring session in SQL Server 2005 |
50001183 | 936489 | FIX: A SQL Server assertion is logged in the Errorlog file when the Log Reader Agent runs for a transactional publication in SQL Server 2005 |
50001169 | 938825 | FIX: A foreign key constraint that you drop on a table at the publisher is not dropped on the table at the subscriber in a SQL Server 2005 merge replication |
50001170 | 936891 | A memory leak may occur when the Merge Replication Agent retries a connection in SQL Server 2005 |
50001259 | | Error message when you use the SQL Server Native Client to bulk insert data into a column of a large object data type in SQL Server 2005: "Conversions not allowed using bcp_moretext" |
50001317 | 937745 | FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections |
50001313 | 938915 | FIX: You cannot select the child parameters even after you select the parent parameter when you use the Report Viewer Web part on a SharePoint site to view a SQL Server 2005 Reporting Services report |
50001263 | 934812 | FIX: You cannot bring the SQL Server group online in a cluster environment after you rename the virtual server name of the default instance of SQL Server 2005 |
50001288 | 938675 | FIX: The update may take a longer time to complete in SQL Server 2005 than in SQL Server 2000 when you update subscribers of a transactional publication that has immediate updating subscriptions enabled |
50001293 | 938916 | FIX: The status of the shared schedule appears as Paused after you click Resume when you use Report Manager in SQL Server 2005 Reporting Services SP2 |
50001323 | 937792 | FIX: The data mining model that you build by using the association algorithms contains only one rule in SQL Server 2005 Analysis Services |
50001270 | 937149 | FIX: Rows in a table are not aligned correctly in a SQL Server 2005 Reporting Services report when you view the deployed report in a browser |
50001291 | 938912 | FIX: In a maintenance plan, the databases that you selected are no longer selected when you edit a Back Up Database task in SQL Server 2005 Service Pack 2 |
50001319 | 938068 | FIX: Hebrew characters are incorrectly converted when you synchronize a replication subscription in SQL Server 2005 |
50001283 | 937829 | FIX: Error message when you run an MDX query against a database in SQL Server 2005 Service Pack 2: "An unexpected exception occured" |
50001299 | 938697 | FIX: Error message when you run a query that references a temporary table in SQL Server 2005: "Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption" |
50001287 | 937533 | FIX: Error message when you run a query in SQL Server 2005: "Cannot insert duplicate key row in object <TableName> with unique index <IndexName>" |
50001284 | 938823 | FIX: Dates in the Datetimepicker control appear in the incorrect format when you view a report of SQL Server 2005 Reporting Services with SP2 on a server that is set to a German locale |
50001268 | 937521 | FIX: An access violation may occur when you run a query that uses a hash join hint in the x64 version of SQL Server 2005 Service Pack 2 |
50001286 | 938585 | FIX: Additional data columns for ascendant members are returned unexpectedly when you run an MDX statement against an instance of SQL Server 2005 Analysis Services that has SQL Server 2005 Service Pack 2 installed |
50001312 | 937277 | FIX: A memory leak occurs when you use the sp_OAMethod stored procedure or the sp_OAGetProperty stored procedure to call a method of a COM object in SQL Server 2005 |
50001346 | 935446 | FIX: You receive error messages when you use the BULK INSERT statement in SQL Server 2005 to import data in bulk |
50001355 | 938682 | FIX: You receive an access violation when you process an object or alter an object after you run an MDX query against the object in Microsoft SQL Server 2005 Analysis Services |
50001340 | 937544 | FIX: You may receive error 3456 when you try to restore a transaction log for a SQL Server 2005 database |
50001385 | 936595 | FIX: The estimate of the number of children that a dimension member has may be inaccurate when you request the CHILDREN_CARDINALITY property for a dimension member in SQL Server 2005 Analysis Services |
50001347 | 938671 | FIX: The Distribution Agent may skip some rows when you configure a transactional replication that uses the "-SkipErrors" parameter in SQL Server 2005 |
50001339 | 937545 | FIX: Error message when you use the BULK INSERT statement to import a data file into a table in SQL Server 2005 with SP1: "The OLE DB provider "BULK" for linked server "(null)" reported an error" |
50001335 | 938050 | FIX: Error message when you try to synchronize a SQL Server 2005 Compact Edition subscription again: "The common generation watermark is invalid at this replica since it does not exist" |
50001342 | 937969 | FIX: Error message when you import data from a flat file in a SQL Server 2005 Integration Services (SSIS) package: "There is a partial row at the end of the file" |
50001329 | 938049 | FIX: An SSIS package stops responding when you run the package and the package contains a data flow task that contains one or more MergeJoin transformations in SQL Server 2005 |