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 Q
xxxxxx 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
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
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