If your SQL Server 2000 is running on Service Pack 3 (build 8.00.760) or Service Pack 3a, you might be interested in this blog entry.

 

Since the launch of SQL 2000 SP3 and SP3a, Microsoft has released a number of hotfixes with resolutions to several known issues.

 

  • We strongly encourage you to be at least at 8.00.818 build, as this build includes important security fixes. Please refer to the MS03-031 Security Bulletin for more information on this.
     
  • At the time of writing of this blog entry, the latest publicly available build for SP3 rollup was 8.00.1019.
     
  • For a detailed list of all the fixes and the several builds between 8.00.760 to 8.00.1019, refer to the KB article 810185 
     
  • You might also be interested in upgrading to SP4 and its rollup. Learn more about it here.

NOTE

We strongly recommend that you test any service pack or hotfix builds on your test server before putting them on your production server.

 

POSTED BY : Sanchan Saxena