Browse by Tags

Changes to a SQL Server Agent job are lost when the job corresponds to a subplan in a maintenance plan that you created in SQL Server 2005 Service Pack 2

Published 29 May 8 1:29 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64Edition Notification Contents: New Changes to a SQL Server Agent...

Filed under: sql server, maintenance plan, kba, service pack2, subplan

List of modified Knowledge Base articles in SQL Server 2005 Enterprise X64 Edition

Published 16 November 7 5:14 PM | SSQA.net

The following pages were recently modified, rather than posting each as a blog post I have included them here: Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: A gradual...

Filed under: sql server, restore, database, kba, service pack2, x64, backups, modified

BUG: Error message when you try to install SQL Server 2005 Service Pack 1 or SQL Server 2005 Service Pack 2 from the existing active node: "The product instance <InstanceName> been patched with more recent updates"

Published 12 November 7 4:30 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications BUG: Error message when you try to install...

Filed under: sql server, kba, bug, service pack2, clustering, active node, patches

How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server

Published 28 October 7 11:56 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Reporting Services Notification Contents: New and Major Modifications How...

Filed under: sql server, kba, service pack2, xp, configuration

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

Published 24 October 7 3:38 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: Dates in the Datetimepicker control appear in the incorrect format when...

Filed under: datetime, sql server, kba, service pack2, reporting services, language, report viewer, format, locale, german

Cumulative update package 5 for SQL Server 2005 Service Pack 2

Published 23 October 7 4:20 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications Cumulative...

Filed under: sql server, download, kba, service pack2, cumulative, update5

Keep your eyes open for Cumulative Update 4 for SQL Server 2005 Service Pack 2 - now you can rest now (available now)

Published 16 October 7 4:50 PM | SSQA.net

August 19 2007: As per the KBA-BlogPost on Cumulative Update 4 for SQL 2005 SP2, Microsoft confirms that this cumulative update package will be released in the October 2007 timeframe. The information that is presented here is subject to change at any...

Filed under: sql server, download, update, kba, support, service pack2, 2005, cumulative, servicing model, costs

Cumulative update package 4 for SQL Server 2005 Service Pack 2 - available now

Published 16 October 7 4:43 AM | SSQA.net

August 19 2007: Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Reporting Services, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications...

Filed under: sql server, update, kba, service pack2, 2005, cumulative, available

FIX: A table in a report that is delivered by SQL Server 2005 Reporting Services with Service Pack 2 appears to be compressed when the report is opened in Outlook 2007

Published 15 October 7 2:52 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: A table in a report that is delivered by SQL Server 2005 Reporting Services...

Filed under: sql server, kba, outlook, service pack2, reporting services, 2007, compressed

FIX: In Reporting Services together with SQL Server 2005 Service Pack 2, the "Save As Report" dialog box stops responding, or the "Open Report" dialog box stops responding in Report Builder

Published 6 October 7 3:0 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: In Reporting Services together with SQL Server 2005 Service Pack 2,...

Filed under: sql server, report builder, kba, service pack2, reporting services, report viewer, dialog, save as

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

Published 22 September 7 7:4 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, query, kba, service pack2, hints, access violation, hash join

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

Published 19 September 7 5:23 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, database, plan, kba, maintenance, service pack2, backups

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"

Published 19 September 7 11:58 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, kba, service pack2, object, database mirroring, backups, exception

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>”

Published 31 August 7 11:25 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: Error message when you display a report that uses SAP Business Information...

Filed under: sql server, business, kba, service pack2, reporting services, information, data source, sap

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”

Published 30 August 7 1:45 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, kba, service pack2, column, bcp, queryout

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"

Published 30 August 7 1:42 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, query, plan, kba, service pack2, processor

The file name of Cumulative Update 3 for SQL Server 2005 Service Pack 2 is incorrectly associated with Microsoft Knowledge Base article 936252

Published 23 August 7 6:30 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, update, kba, service pack2, cumulative, incorrect

Keep your eyes open for Cumulative Update 4 for SQL Server 2005 Service Pack 2

Published 19 August 7 4:50 PM | SSQA.net

As per the KBA-BlogPost on Cumulative Update 4 for SQL 2005 SP2, Microsoft confirms that this cumulative update package will be released in the October 2007 timeframe. The information that is presented here is subject to change at any time before the...

Filed under: sql server, update, developer, kba, service pack2, 2005, cumulative, servicing model

Cumulative update package 4 for SQL Server 2005 Service Pack 2

Published 19 August 7 4:43 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Reporting Services, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications Cumulative...

Filed under: sql server, update, kba, service pack2, cumulative

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"

Published 19 August 7 4:40 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: Error message when you try to create an Oracle...

Filed under: sql server, replication, kba, service pack2, oracle, linked, publisher