martes, 21 de julio de 2009

Disponible el Cumulative update package 1 for SQL Server 2008

Ya puedes bajar el Cumulative update package 1 for SQL Server 2008 en esta dirección http://support.microsoft.com/kb/956717/en-us

Dentro de los errores que se corrigen están los siguientes:

SQL Hotfix bug number
Knowledge Base article number
Description

50003171
When you use a SAP client computer to view a SQL Server database, the database may be smaller than expected

50003196
957810 (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 partitions

50003200
957375 (http://support.microsoft.com/kb/957375/ )
FIX: A mirror server cannot fail over to a principal server in a SQL Server 2008 failover cluster

50003202
957811 (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 2005

50003203
957205 (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 2008

50003224
926292 (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

50003238
957814 (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 cube

50003241
957101 (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 Services

50003242
955719 (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 Services

50003243
958745 (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"

50003244
957103 (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)"

50003245
FIX: SQL Server 2008 Reporting Services stops responding when you try to render a report in the Image format

50003246
957104 (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 Services

50003247
957107 (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 Services

50003248
957108 (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 Services

50003249
FIX: 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 property

50003250
The 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 Services

50003251
FIX: 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 AutoSize

50003252
957118 (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 report

50003253
957111 (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 Services

50003254
957120 (http://support.microsoft.com/kb/957120/ )
FIX: SQL Server 2008 Reporting Services interprets the Slant property as a positive slope

50003255
957112 (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 location

50003256
957113 (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"

50003315
956039 (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"

50003316
956376 (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 20598

50003320
954831 (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 session

50003325
955896 (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 package

50003330
955372 (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 2005

50003334
FIX: Error message when you run an INSERT statement in SQL Server: "Cannot insert an explicit value into a timestamp column"

50003336
FIX: 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 Services

50003339
FIX: 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"

50003341
955975 (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"

50003342
955958 (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 Server

50003344
957872
FIX: When you update rows by using a cursor in SQL Server 2008, the update may take a long time to finish

50003345
956036 (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"

50003346
FIX: 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 Services

50003349
FIX: 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"

50003350
Analysis Services may stop responding when a NonEmpty clause causes many cell errors

50003351
957819 (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 security

50003352
957820 (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 Studio

50003360
956718 (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 2008

50003364
957277 (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 2008

50003365
956218 (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 2008

50003367
957278 (http://support.microsoft.com/kb/957278/ )
FIX: The IntelliSense feature incorrectly completes the logical operators in the CASE WHEN clause in SQL Server 2008

50003368
957239 (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"

50003369
957279 (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 2008

50003371
957803 (http://support.microsoft.com/kb/957803/ )
FIX: You cannot start the Data Profile Viewer (DataProfileViewer.exe) in SQL Server 2008

50003373
957281 (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 Studio

50003382
FIX: Error message when you start the SQL Server 2008 Reporting Services Configuration Manager: "Invalid namespace"

50003383
FIX: The SimSun font is not displayed correctly when you view a SQL Server 2008 Report Services report

50003386
957330 (http://support.microsoft.com/kb/957330/ )
FIX: Clients cannot connect to the Report Server Web service in SQL Server 2008 Reporting Services

50003387
FIX: Error message when you render a report in SQL Server 2008 Reporting Services: "A generic error occurred in GDI+"

50003388
957332 (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 Services

50003389
957333 (http://support.microsoft.com/kb/957333/ )
FIX: A SQL Server 2008 Reporting Services report may repaginate continually and consume 100% of CPU resources

50003391
957387 (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 2008

50003393
955814 (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"

50003399
956138 (http://support.microsoft.com/kb/956138/ )
You cannot upgrade a non-English instance of SQL Server 2000 Reporting Services to SQL Server 2008 Reporting Services

50003400
957805 (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 messages

50003401
957453 (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 file

50003402
957804 (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 Express

50003407
Data warehousing may stop collecting data when many time-outs occur

50003409
You receive a memory error message when you try to run SQL Server Setup from a network resource

50003410
You may be unable to uninstall a prepared instance of SQL Server 2008

50003411
955949 (http://support.microsoft.com/kb/955949/ )
FIX: Cluster upgrade to SQL Server 2008 fails when SQL Server 2005 cluster nodes have different installed features

50003412
955948 (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 password

50003414
957806 (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 2008

50003415
957459 (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"

50003419
957357 (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 2008

50003427
957807 (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 installed

50003452
957809 (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 backups

50003453
When you programmatically retrieve data from a SQL Server 2008 database, the data in memory may be overwritten

50003454
The Service Broker connections between endpoints may experience a deadlock condition when the initiator queues contain many messages

50003456
957823 (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 2008

50003458
957816 (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 server

50003460
FIX: Extended Events session produces an empty value for data captured for certain actions

50003467
955943 (http://support.microsoft.com/kb/955943/ )
FIX: The Processes pane in the Activity Monitor incorrectly shows sessions as head blockers in SQL Server 2008

50003468
When a SQL Server 2008 policy file executes a WMI query, the policy always executes the query against the local server regardless of the intended target

50003469
957817 (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

 

 

Saludos,

Eduardo Castro – Microsoft SQL Server MVP

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

http://ecastrom.blogspot.com

http://ecastrom.wordpress.com

http://ecastrom.spaces.live.com

http://universosql.blogspot.com

http://todosobresql.blogspot.com

http://todosobresqlserver.wordpress.com

1 comentario:

  1. To repair your mdf file use sql recovery software. SQL recovery software to recover lost data, tables, views, stored procedures, rules, defaults, user defined data types and triggers from Microsoft SQL server database.

    ResponderEliminar