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

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

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

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

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

KBA: Blank space appears in the file when you export a report to a physical page format file in SQL Server 2005 Reporting Services or in SQL Server 2000 Reporting Services

Published 10 July 7 4:50 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete Blank space appears in the file when you export a report to a physical page format file in SQL Server 2005 Reporting...

Filed under: sql server, server, reporting, kba, 2000, physical, 2005