BetaCollector tells me that the Beta for SQL Server 2000 Service Pack 2 has begun, he sent me 2 documents that outline what will be covered in the beta.

This release of Service Pack 2 (SP2) for Microsoft® SQL Server™ 2000 is provided in three parts:
Database Components SP2 provides updates for the database components of an instance of SQL Server 2000, excluding instances of the SQL Server 2000 Desktop Engine. Database Components SP2 includes upgrades to:
    1. The data engine.
  • Database client tools and utilities such as SQL Server Enterprise Manager and osql.
  • Database client connectivity components, such as the Microsoft OLE DB Provider for SQL Server 2000, the SQL Server 2000 ODBC driver, and the client Net-Libraries.
  • Analysis Services SP2 provides updates for the SQL Server 2000 Analysis Services components of a SQL Server 2000 installation, including:
    2. Analysis Services.
  • Analysis Services client components, which include Analysis Manager and the Microsoft OLE DB Provider for Analysis Services.
  • Database client connectivity components, such as the Microsoft OLE DB Provider for
  • SQL Server 2000, the SQL Server 2000 ODBC driver, and the client Net-Libraries.
  • Desktop Engine SP2 provides updates for the database components of an instance of the SQL Server 2000 Desktop Engine (also referred to as MSDE 2000), including:
    3. The data engine.
  • Database client connectivity components, such as the Microsoft OLE DB Provider for SQL Server 2000, the SQL Server 2000 ODBC driver, and the client Net-Libraries.

Bug fix list is inside, click read more to view them. :cross:

SQL Server 2000 SP2 Fix List for SQL Server 2000
  • Q260182 BUG: Unable to Restore to a Point in Time in First Transaction Log Backup
  • Q271351 BUG: All Replication Agents Have Step Name That Reads "Log Reader Agent Startup Message"
  • Q275024 BUG: SQL Server Enterprise Manage Does Not List all Tables in the TaskPad View and the Next and Last Buttons Do Not Appear
  • Q279080 PRB: Sqldiag Utility Exits if SQL Server Service Is Not Started
  • Q282749 BUG: Deadlock Information Reported with SQL Server 2000 Profiler Is Incorrect
  • Q290415 FIX: Use of the Jet Provider to Query a Linked Server Text File from SQL Server May Be Very Slow
  • Q291332 BUG: SERVERPROPERTY Returns Incorrect Value for LICENSETYPE
  • Q295589 PRB: Upgrading SQL Server 2000 SP1 to a Cluster Virtual Server May Result in Use of Mixed Binaries
  • Q296045 BUG: Merge Snapshot Agent Fails with Error 50007: "Too many table names in the query. The maximum allowable is 256."
  • Q296456 FIX: Full Text Query May Return 0 Rows When Valid Results are Present
  • Q296612 FIX: Large Array of IN Clause Parameters Parses/Compiles Slower on SQL Server 2000
  • Q296849 FIX: BULK INSERT Replaces Current Datetime Column Value with Previous Column Value if Data File Contains All Spaces
  • Q298828 BUG: Query Analyzer Stops Responding and Cannot be Started Until Visual Studio Analyzer is Stopped
  • Q299287 BUG: The Number of Parameters Does Not Match Error Message From Distribution Task
  • Q299299 FIX: Export of Specific DBCS to Excel Fails When Text Type is Used
  • Q299717 FIX: Query Method Used to Access Data May Allow Rights that the Login Might Not Normally Have
  • Q300195 FIX: The SQL-DMO Transfer Method Silently Fails to Copy All Data
  • Q300269 BUG: Replication Conflict Viewer Reports That Merge Published Database Is Not Published
  • Q300383 FIX: Initial Snapshot Fails with 8115 Error "Arithmetic Overflow Error Converting Expression to Data Type Int"
  • Q300412 FIX: Shared Table Lock Incorrectly Held for Lifetime of Transaction Instead of Statement
  • Q300414 FIX: SQL Mail Operations May Lead to Failures and Memory Leaks
  • Q300919 BUG: SQL Server 2000 Service Pack 1 Setup May Fail when Applied to a Server with Non-writable Databases
  • Q301642 FIX: SQL Server Error Message 6002 Is Returned with an Incorrect Severity
  • Q302477 FIX: Cursor Created on Linked Server That Requests Meta-Data May Cause Handled Access Violation
  • Q302675 FIX: Delete on Nonindexed Column Fails with Error 1203
  • Q302825 FIX: Complex Join Query with Views and Redundant Tables May Cause Error 8623
  • Q302892 BUG: Specifying More Than One Operator E-mail Address May Terminate SQL Server Agent with Dr. Watson
  • Q303005 FIX: SQL Server Performance Condition Alerts do not Fire After You Install SQL Server 2000 Service Pack 1
  • Q303042 FIX: Spanish VSwitch Causes Setup to Fail
  • Q303324 BUG: SQL Server 2000 Service Pack 1 Breaks Visual Basic T-SQL Debugger
  • Q303640 FIX: Latch Timeout Warnings Appear in Error Log and Slow SQL Server Response Occurs with AWE Enabled
  • Q303664 BUG: SP_PROCESSMAIL May Fail with Error 18023
  • Q303822 FIX: Properties Dialog Box of a Transform Data Task Takes a Long Time to Open
  • Q303981 BUG: Merge Agent Fails with Error: "Line38: Incorrect syntax near "." " During Initial Snapshot Application
  • Q304222 FIX: Merge Replication Non-Convergence Occurs with Local Subscribers when Published Table has 32 or More Columns
  • Q304519 FIX: Nonclustered Indexes Rebuilt For CREATE UNIQUE CLUSTERED INDEX ... WITH DROP_EXISTING Query
  • Q304551 FIX: Merge Publishing with Vertical Filters Results in Nonconvergence
  • Q304658 FIX: Distribution Task Encounters Syntax Error During Application of Initial Snapshot
  • Q304703 FIX: Pull Subscribers Experience Non-Convergence After Running sp_mergecleanupmetadata Against a Published Database
  • Q304711 PRB: SQL Server 2000 Service Pack 1 Setup Fails with No Errors
  • Q304847 FIX: Abort of DTC Transaction in tempdb May Cause 7105 Errors, Assertions, and Possible Shutdown of SQL Server
  • Q305042 FIX: UPDATE After ALTER TABLE Can Result in Unexpected Data to Added Columns
  • Q305066 BUG: Merge Agent Access Violation Occurs with Large Batch Size and Several Columns
  • Q305354 BUG: Paging an Operator May Not Work After You Apply Service Pack 1
  • Q305377 FIX: SQL Server 2000 May Be More Aggressive with Read-Ahead Than SQL Server 7.0
  • Q305378 BUG: Service Pack 1 Installation May Fail with Error Messages 3703 and 1911
  • Q305573 FIX: Return Code of xp_findnextmsg Changed to 1 Against an Empty Inbox
  • Q305576 FIX: Regression: AV When xp_findnextmsg Is Invoked Against an Empty Inbox
  • Q305711 BUG: DBO User Does Not Display in Enterprise Manager
  • Q306034 BUG: SQL Server 2000 SP1 Installation on a Cluster with Sqlservr.exe Fails with "...Entry Point Not Found" Error Message
  • Q306167 BUG: MSDE SP1 Upgrade Does Not Update Merge Replication Components
  • Q306266 FIX: Updates to Distributed Partitoned Views May Return Incorrect @@ROWCOUNT Value
  • Q306334 BUG: Objects May Fail to Retain Quoted Identifier Setting When You Use SQL-DMO to Create or Alter Objects
  • Q306374 FIX: SP1 Regression: Table Scan Chosen Over Index Seek for INSERT/SELECT Statement Against the Same Table
  • Q306401 BUG: Error Message 7355 "..Inconsistent metadata for a column" Occurs When You Use a Linked Server
  • Q306488 FIX: Reinstall with Long Command May Cause Setup to Fail
  • Q306491 FIX: "Unable To Run The Script Files" Error Message Occurs with Desktop Engine Modification
  • Q306816 FIX: ActiveX Controls for Replication May Cause Access Violation with More Than 256 Articles in a Publication
  • Q306890 FIX: Merge Join with Rank Operator May Produce Incorrect Results
  • Q306893 FIX: Unexpected Results Occur When You Use a Sort and a Stream Aggregate
  • Q306998 FIX: Complex CASE Clause on Query May Cause Error 8621 and Terminate Batch
  • Q307533 BUG: Distribution Agent May Encounter Error 8115 in the Sp_MSadd_distribution_history Stored Procedure
  • Q308010 FIX: SQL Server Service Manager Fails with "The system cannot find the file specified" Error Message
  • Q307538 FIX: SQLTrace Start and Stop is Now Reported in Windows NT Event Log for SQL Server 2000
  • Q307946 BUG: SQL Profiler Truncates Seconds and Milliseconds for Datetime RPC Parameter
  • Q307948 FIX: SQL Mail Attachments Contain Leading Space Before First Column of Each Result Row
  • Q308016 FIX: sp_configure 'network packet size' Not Functional in SQL Server 7.0 SP3 and SQL Server 2000
  • Q308267 BUG: DTS Copy Objects Task (DMO) Breaks Transaction Log Backup Chain By Switching Recovery Mode to Simple During Transfer
  • Q308370 BUG: Query Containing LIKE NULL May Not Return Correct Results
  • Q308398 BUG: Execution of Stored Procedure That Uses a TEXT Parameter in Cursor Definition Causes AV
  • Q308547 FIX: SELECT DISTINCT from Table with LEFT JOIN of View Causes Error Messages or Client Application May Stop Responding
  • Q308772 BUG: Unicode Wildcard Comparisons with Latin1_general_CI_AS May Return Incorrect Results
  • Q308878 FIX: sp_mergemetadataretentioncleanup Does Not Clean Generations with ArtNick=0
  • Q308984 FIX: Nondynamic Snapshot Performs Poorly for Partitioned Merge Publication
  • Q309251 FIX: Execution of Sp_addsynctriggers Results in Syntax Error After ALTER TABLE MDAC
  • Q297035 FIX: Correlation Error Using Parameters.Refresh with SQLOLEDB
  • Q299765 FIX: SQL Server 2000 ODBC Driver Fails to Return SQL Server 7.0 Server Names
  • Q300420 FIX: Connection to SQL Server Database Using IP Address Is Unusually Slow
  • Q304329 FIX: Application Using Microsoft Oracle ODBC Driver Crashes When TNS Does Not Exist OLAP
  • Q296186 BUG: Incorrect Results In Cube Editor When You Edit a Dependent Calculated Member or Calculated Cell


There are no additional comments
Advertisement


Commenting has either been disabled on this article or you are not logged in. Click here to login or register, its free!

Note: Anonymous commenting is disabled in order to keep the quality of responses to a high standard.


Scroll to the Top
....
My Preferences
....
Communicating with server
Loading
Please Wait...
....
Loading
 X 
....