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



APPLIES TO

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



This article was previously published under Q314309

SUMMARY

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.

MORE INFORMATION

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