SQL Server VersionBy Bill Graziano on 29 January 2009 | Tags: Administration I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fill out any missing data, please post in the comments and I'll update the article. The versions of SQL Server are listed in the following table. Below the table are instructions to determine what build you are running.
You can determine what version SQL Server is running by running Select @@version @@Version is a system level variable that holds the current version. On my computer this returns 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) The main version number is 8.00.384 which corresponds to SQL Server 2000 SP1. See below for a complete list of versions. It will also tell us the version of the operating system we're running. In this case I'm running Windows 2000 (aka NT 5.0) Service Pack 2. You can find this same information in Enterprise Manager by right clicking on a server and choosing Properties. The version information is displayed in the General tab. This information is pulled from the system extended procedure exec master..xp_msver and it returns Index Name Internal_Value Character_Value ------ -------------------------------- -------------- ------------------------------ 1 ProductName NULL Microsoft SQL Server 2 ProductVersion 524288 8.00.384 3 Language 1033 English (United States) 4 Platform NULL NT INTEL X86 5 Comments NULL NT INTEL X86 6 CompanyName NULL Microsoft Corporation 7 FileDescription NULL SQL Server Windows NT 8 FileVersion NULL 2000.080.0384.00 9 InternalName NULL SQLSERVR 10 LegalCopyright NULL © 1988-2000 Microsoft ... 11 LegalTrademarks NULL Microsoft® is a registered ... 12 OriginalFilename NULL SQLSERVR.EXE 13 PrivateBuild NULL NULL 14 SpecialBuild 25165824 NULL 15 WindowsVersion 143851525 5.0 (2195) 16 ProcessorCount 1 1 17 ProcessorActiveMask 1 00000001 18 ProcessorType 586 PROCESSOR_INTEL_PENTIUM 19 PhysicalMemory 255 255 (267902976) 20 Product ID NULL NULL This is quite a bit of additional information. There really isn't anything exciting in here that I can find but it's there if you need it. |
- Advertisement - |