http://www.sqlservercentral.com/Content tagged Service Packs, SQL Server 7, 2000 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes. http://www.sqlservercentral.com/articles/Service+Packs/sp3coresecurity/907/2005/12/09http://www.sqlservercentral.com/articles/Service+Packs/sp3coresecurity/907/Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes. http://www.sqlservercentral.com/articles/Service+Packs/sp3coresecurity/907/2005/12/09http://www.sqlservercentral.com/articles/Service+Packs/sp3coresecurity/907/There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods. http://www.sqlservercentral.com/articles/Service+Packs/versionservicepack/928/2003/02/28http://www.sqlservercentral.com/articles/Service+Packs/versionservicepack/928/On Friday the 24th, a virus that preys on a SQL Server vulnerability began to attack networks, taking down many networks. This brief network describes the virus and how to protect yourself from it. http://www.sqlservercentral.com/articles/Service+Packs/sapphirevirus/901/2003/01/27http://www.sqlservercentral.com/articles/Service+Packs/sapphirevirus/901/If you're still on SQL Server 2000 SP2, beware! Microsoft has released a number of fixes that have now been rolled up into this cumulative patch to fix major security flaws in SQL Server. http://www.sqlservercentral.com/articles/Service+Packs/securityhotfix/820/2002/10/07http://www.sqlservercentral.com/articles/Service+Packs/securityhotfix/820/Microsoft has released a patch to fix two buffer overflow vulnerabilities in SQL Server 2000. No UserID or password is required by the attacker to exploit these issues. The problem is exacerbated by the fact the attack goes over UDP.http://www.sqlservercentral.com/redirect/articles/751/2002/07/29http://www.sqlservercentral.com/redirect/articles/751/Here we go again! Microsoft has released service pack 2 this week, which is much more tame than service pack 1. Read the summary of this service pack here. http://www.sqlservercentral.com/articles/Service+Packs/servicepack2forsqlserver2000/545/2001/12/05http://www.sqlservercentral.com/articles/Service+Packs/servicepack2forsqlserver2000/545/SQL Server 2000 has better replication capabilities than ever before! Do you have questions about using Replication on SQL Server? Whether it be transactional or merge replication, you can not find a better group of guys to answer your questions. Right from the development team, Matt Hollingsworth and Dean Kalanquin, replication program manager and test lead respectively are setting aside this time to take on your most challenging replication questions! http://www.sqlservercentral.com/redirect/articles/533/2001/11/15http://www.sqlservercentral.com/redirect/articles/533/Microsoft has announced that it is now accepting applications for beta testers for the latest service pack. http://www.sqlservercentral.com/articles/Service+Packs/sp2betaforsql2knews/487/2001/10/22http://www.sqlservercentral.com/articles/Service+Packs/sp2betaforsql2knews/487/Steve Jones provides some notes from the field after installing SP1 on a personal edition of SQL Server http://www.sqlservercentral.com/articles/Service+Packs/sp1_personal/302/2001/06/18http://www.sqlservercentral.com/articles/Service+Packs/sp1_personal/302/Like most SQL Server service packs, the latest service pack by Microsoft for SQL Server 2000 is simple to install. Don't let this deceive you though. A step mishap can leave your system in an inconsistent state and cause major problems when users begin to hit it again. This article will provide you a step-by-step guide to installing Service Pack 1 for SQL Server 2000. http://www.sqlservercentral.com/articles/Service+Packs/sp1sql2kinstall/307/2001/06/18http://www.sqlservercentral.com/articles/Service+Packs/sp1sql2kinstall/307/In this article by Brian Knight, he explores how to install Service Pack 1 for SQL Server 2000 and some of the catches. This service pack is one of the largest in SQL Server history. Learn what was fixed here. http://www.sqlservercentral.com/articles/Service+Packs/sp1sql2k/290/2001/06/13http://www.sqlservercentral.com/articles/Service+Packs/sp1sql2k/290/Getting ready to install Windows 2000 SP2? Read this article first. It provides links to resources as well as potential problems.http://www.sqlservercentral.com/redirect/articles/258/2001/06/01http://www.sqlservercentral.com/redirect/articles/258/This article will show you some of the common problems fixed in service pack 3 for SQL Server 7.0 and how to rollback. http://www.sqlservercentral.com/articles/Service+Packs/sp3/138/2001/05/04http://www.sqlservercentral.com/articles/Service+Packs/sp3/138/