http://www.sqlservercentral.com/Content tagged Administering, 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/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/