SQL Server/T-SQL Tutorial/System Settings/xp msver

EXEC master..xp_msver

   <source lang="sql">

2> EXEC master..xp_msver 3> GO Index Name Internal_Value Character_Value

---

-------------------------------- -------------- ------------------------------------------------------------------------------------------------------------------------

    1 ProductName                                NULL Microsoft SQL Server
    2 ProductVersion                           589824 9.00.1399.06
    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 2005.090.1399.00
    9 InternalName                               NULL SQLSERVR
   10 LegalCopyright                             NULL c Microsoft Corp. All rights reserved.
   11 LegalTrademarks                            NULL Microsoftr is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation
   12 OriginalFilename                           NULL SQLSERVR.EXE
   13 PrivateBuild                               NULL NULL
   14 SpecialBuild                           91684864 NULL
   15 WindowsVersion                        170393861 5.1 (2600)
   16 ProcessorCount                                1 1
   17 ProcessorActiveMask                           1 00000001
   18 ProcessorType                               586 PROCESSOR_INTEL_PENTIUM
   19 PhysicalMemory                             1023 1023 (1073201152)
   20 Product ID                                 NULL NULL

(20 rows affected)</source>

xp_msver function

   <source lang="sql">

4> CREATE TABLE #VersionTable( 5> [Index] int PRIMARY KEY, 6> Name varchar(30), 7> Internal_Value int, 8> Character_Value varchar(250) 9> ) 10> GO 1> 2> INSERT INTO #VersionTable 3> EXEC master..xp_msver 4> 5> DECLARE @Version int 6> 7> SELECT @Version = (SELECT Internal_Value 8> FROM #VersionTable 9> WHERE Name = "ProductVersion") 10> IF (@Version) >= 524288 11> PRINT "Running SS2K Beta 2 or Later" 12> ELSE 13> IF @Version >= 458752 14> PRINT "Running 7.0 RTM or Later" 15> ELSE 16> PRINT "Running Pre 7.0 RTM Version" 17> GO (20 rows affected) (20 rows affected) Running SS2K Beta 2 or Later 1> DROP TABLE #VersionTable 2> GO</source>