asked
MSDE 2000 Version 8.00.761 Service Pack
Our current version of MSDE is MSDE 2000 Version 8.00.761 Looks like Microsoft Sql Server 2000 Service Pack 4(KB884525) is a safe bet. Does anyone have a different opinion on what Service Pack should be installed. Thank you.
If you do **SELECT @@version** you'll see something like: > Microsoft SQL Server 2000 - 8.00.384 > (Intel X86) May 23 2001 00:02:52 > Copyright (c) 1988-2000 Microsoft > Corporation Standard Edition on > Windows NT 5.0 (Build 2195: Service > Pack 2) Then you'll see which service pack is installed. If SP4 is not already applied, you should go for that one. It's SQL2000.MSDE-KB884525-SP4-x86.EXE at [
http://www.microsoft.com/downloads/details.aspx?familyid=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en][1] [1]:
http://www.microsoft.com/downloads/details.aspx?familyid=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en
Select @ @version gives you the build of SQL server(which I prefer). But if you want to get both the build(ProductVersion) and service pack(Product Level), use this query: /* SELECT SERVERPROPERTY('Edition') AS 'Edition', SERVERPROPERTY('ProductVersion') AS 'ProductVersion', SERVERPROPERTY('ProductLevel') AS 'ProductLevel', SERVERPROPERTY('ResourceLastUpdateDateTime') AS 'ResourceLastUpdateDateTime', SERVERPROPERTY('ResourceVersion') AS 'ResourceVersion' GO */
