Running in master xp_msver, result: Index Name Internal_Value Character_Value 1 ProductName NULL Microsoft SQL Server2 ProductVersion 524288 8.00.1943 Language 2052 Chinese (China) 4 Platform NULL NT INTEL X86 ... which ProductVersion meaning: 8.00.194 --- ---- SQL Server 2000 RTM 8.00.384 ------- (SP1) 8.00.534 ------- (SP2) 8.00.760 ------- (SP3)
8.00.2039 ---------------------- (SP4)
SQL Server is a version number after the completion, select @@ Version.
Version NumberService Pack8.00.194Microsoft SQL Server 20008.00.384Microsoft SQL Server 2000 SP18.00.532Microsoft SQL Server 2000 SP28.00.760Microsoft SQL Server 2000 SP38.00.818Microsoft SQL Server 2000 SP3 w / Cumulative Patch MS03-031 8.00.2039Microsoft SQL Server 2000 SP4 7.00.623Microsoft SQL Server 7.07.00.699Microsoft SQL Server 7.0 SP17.00.842Microsoft SQL Server 7.0 SP27.00.961Microsoft SQL Server 7.0 SP37.00.1063Microsoft SQL Server 7.0 SP4 6.50.201Microsoft SQL Server 6.5 RTM6.50.213Microsoft SQL Server 6.5 SP16.50.240 Microsoft SQL Server 6.5 SP26.50.258Microsoft SQL Server 6.5 SP36.50.281Microsoft SQL Server 6.5 SP46.50.415Microsoft SQL Server 6.5 SP56.50.416Microsoft SQL Server 6.5 SP5a6.50.479Microsoft SQL Server 6.5 SP5a Update
