Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/314309

From BetaArchive Wiki
Knowledge Base

INF: SQL Server 2000 Service Pack 1 and Service Pack 2 Fixlist for SQL Mail

Article ID: 314309

Article Last Modified on 2/22/2007


  • Microsoft SQL Server 2000 Service Pack 1
  • Microsoft SQL Server 2000 Service Pack 2

This article was previously published under Q314309


Following is a list of fixes and other various improvements that have been made in SQL Server 2000 Service Pack 1 (SP1) and Service Pack 2 (SP2) specifically for SQL Mail. For more information, contact your primary support provider.


To determine which Service Pack level your SQL Server server is currently running, run the following statement from the SQL Server Query Analyzer window:

SELECT @@version

The result of this query is:

8.00.194 if SQL Server 2000 with no service pack applied
8.00.384 if SQL Server 2000 Service Pack 1
8.00.534 if SQL Server 2000 Service Pack 2

Please note that the workarounds described in these articles are provided for information only. You do not need to implement these workarounds if you have the updated software.

For more information about each corrected problem in the Service Pack for Microsoft SQL Server 2000, either click the link or use the Qxxxxxx number to query for the article in the Microsoft Knowledge Base.

To view the Service Pack Readme.txt file that accompanies the Service Pack, see the following Microsoft Knowledge Base Article:

300516 INF: Readme.txt Files for SQL Server 2000 Service Packs

For additional information on how to obtain SQL Server 2000 Service Pack, see Microsoft Knowledge Base article:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack

Fixlist of SQL Mail related issues in Service Pack 1

274330 FIX: Sending Open Files as Attachment in SQL Mail Fails with Error 18025

281293 FIX: SQL Mail 2000 Needs Microsoft Outlook 2000 Client

292237 FIX: xp_startmail Does Not Start Default Profile on Nondefault Instance

279867 FIX: Sending Maintenance Report by E-mail to Operator Fails in Maintenance Plan

290058 FIX: SQL Mail Procedures May Intermittently Fail with Error 0x8004010f

280720 FIX: xp_sendmail Generates UNICODE CSV File Format

290739 FIX: Iterating Through SQL Mail Messages Using Extended Procedures Takes Longer in SQL Server 2000

292761 FIX: xp_startmail Error Message Does Not Indicate Problem

291273 FIX: SQLMail Incorrectly Uses Default Mail Profile

290814 FIX: xp_readmail Leaks Memory if Message Contains Attachment

299602 FIX: Extended Stored Procedure xp_sendmail Does Not Handle DBCS Correctly

295627 FIX: Xp_readmail May Cause System to Stop Responding in Windows 95 or Windows 98

299620 FIX: Cannot Use a Profile Name Longer Than 32 Characters with SQL Mail

296098 FIX: xp_sendmail Fails with the @attach_results Parameter on SQL Server 2000 Personal Edition

Fixlist of SQL Mail related issues in Service Pack 2

300414 FIX: SQL Mail Operations May Lead to Failures and Memory Leaks

305573 FIX: xp_findnextmsg Return Code Changed to 1 Against Empty Inbox

305576 FIX: Regression: AV When xp_findnextmsg Is Invoked Against an Empty Inbox

307948 FIX: SQL Mail Attachments Contain Leading Space Before First Column of Each Result Row

308758 FIX: SQL Agent Mail May Cause E-mail to Be Written to Root Directory of Source Mailbox

302892 FIX: Specifying More Than One Operator E-mail Address May Terminate SQL Server Agent with Dr. Watson

305354 FIX: Paging an Operator May Not Work After You Apply Service Pack 1

308777 FIX: SQL Mail Profile Name in SQL Enterprise Manager Does Not Handle Information Over 132 Characters

For more information about SQL Mail see the following Microsoft Knowledge Base Articles:

263556 INF: How to Configure SQL Mail

311231 INF: Frequently Asked Questions - SQL Server - SQL Mail

315886 INF: Common SQL Mail Problems

Additional query words: sql server 2000 sp1 sp2 fixlist SQLMail Mail

Keywords: kbbug kbinfo KB314309