Browse by Tags

KBA: Articles on SQL Server 2005, 2000 & MSDE Installation issues

Published 12 June 8 10:2 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 X64 Edition Notification Contents: New SQL Server 2005 installers...

Filed under: sql server, instance, kba, installation, 2000, 2005, msde

FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005

Published 15 May 8 3:14 AM | SSQA.net

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

Filed under: sql server, kba, transaction, 2005, msdtc, issues

A query that references a nondeterministic user-defined function may run slower in SQL Server 2005 than in SQL Server 2000

Published 12 May 8 1:43 PM | 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 A query that references a nondeterministic...

Filed under: sql server, performance, query, kba, 2000, 2005, slow

An additional resource group that contains no resources is created after you install a second failover clustered instance of SQL Server 2005 on a Windows Server 2008-based server

Published 11 February 8 1:0 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 An additional resource group that contains...

Filed under: sql server, server, kba, group, 2005, resource, windows 2008

FIX: Error message when you run a stored procedure that references a linked server that is linked to the local server itself in SQL Server 2005: "Transaction context in use by another session"

Published 4 February 8 3:1 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you run a stored procedure that references a linked server...

Filed under: sql server, kba, x64, 2005, transactions, context, linked server

SQL Server error - The linked server has been created but failed a connection test. Do you want to keep the linked server?

Published 16 January 8 1:40 AM | SSQA.net

Linked Server errors, such as between SQL Server 2000 and 2005 versions are quite common in DBA-day life. When it goes wrong I would always refer (myself) and others to review HowDoI-PreventLinkedServerIssues resource from ASPFAQ site. Also the usual...

Filed under: sql server, microsoft, error, kba, 2000, error log, 2005, stored procedure, linked server, aspfaq, issues

How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL Server 2008

Published 24 December 7 4:38 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL...

Filed under: sql server, microsoft, instance, kba, 2008, pack, 2005, ifilter, register

FIX: Error message when you jump to another report that uses a shared data source in SQL Server 2005 Reporting Services: "One or more data sources is missing credentials"

Published 23 December 7 1:59 PM | 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 jump to another report that uses a shared data...

Filed under: sql server, security, kba, reporting services, 2005, data source, credentials

FIX: An empty string is replicated as a NULL value when you synchronize a table to a SQL Server 2005 Compact Edition subscriber

Published 16 November 7 3:5 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 Notification Contents: New and All Modifications FIX: An empty string is replicated as...

Filed under: sql server, replication, kba, table, 2005, compact edition, synchronization

FIX: Some events are not logged correctly when you enable SQL Server event forwarding on a SQL Server Agent of SQL Server 2000 to forward events to SQL Server 2005

Published 1 November 7 10:13 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New and Major Modifications FIX: Some events are not logged correctly when you enable SQL Server event forwarding...

Filed under: sql server, kba, 2000, 2005, events, sql server agent, forward

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: You cannot connect to an instance of SQL Server 2005, and an error message is logged in the SQL Server error log

Published 12 October 7 11:10 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, instance, kba, error log, 2005

FIX: An object data source may not appear in the Website Data Sources window when you try to set the object data source for a SQL Server 2005 Reporting Services report in Visual Studio 2005

Published 7 October 7 12:31 PM | 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: An object data source may not appear in the Website Data Sources window...

Filed under: sql server, kba, reporting services, 2005, visual studio, website, data source

SQL Server 2000 and SQL Server 2005 support for mounted volumes

Published 5 October 7 7: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 SQL Server 2000 and SQL Server 2005 support...

Filed under: sql server, kba, standard, 2000, storage, clustering, 2005, mounted, volume

FIX: An access violation may occur intermittently when you run an Integration Services package that contains a Data Flow task in SQL Server 2005

Published 24 September 7 1:49 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 X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, package, ssis, kba, 2005, access violation, data flow, integration services, task

FIX: A memory leak occurs when you call the Initialize method and the Terminate method of the SQLDistribution object in a loop in an application that you develop by using Microsoft ActiveX replication controls in SQL Server 2005

Published 24 September 7 1:2 PM | SSQA.net

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

Filed under: application, sql server, performance, replication, kba, 2005, memory leak, terminate, activex, initialize

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

Published 12 September 7 12:46 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications FIX: Changes in the publisher database are not replicated to the subscribers in a transactional...

Filed under: sql server, replication, kba, database mirroring, publisher, transactional, 2005

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 2005

Published 27 August 7 2:3 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 X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, kba, client, 2005, sqlnative

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