Post reply

SQL Server version

  • January 19, 2006 at 7:44 am

    #115966

    How do i find out the SQL Server version i'm running (and the service pack)?

  • January 19, 2006 at 8:40 am

    #615829

    Most accurate way is to run SELECT @@VERSION and compare the value to the list here:

    SQLSecurity.com: SQL Server Version Database

    K. Brian Kelley
    @kbriankelley

  • January 20, 2006 at 6:06 am

    #616034

    In EM just rightclick on the server where the Db is and choose properties. It says it all on the generaltab.

    /Jonas

  • January 21, 2006 at 12:13 am

    #616263

    Hi All

    you can use this query to know about the SQL Service pack version.

    select serverproperty('productlevel')

     

  • January 22, 2006 at 3:27 pm

    #616300

    Hi !

    I guess there is not much to add, so I'll make a summary on the issue:

    SELECT SERVERPROPERTY('ProductVersion')

    SQL Server 2000 Original Release 8.00.194 RTM

    Database Components SP1 8.00.384 SP1

    Database Components SP2 8.00.534 SP2

    Database Components SP3, SP3a or MSDE 2000 Release A. 8.00.760 SP3

    Database Components SP4 8.00.2039 SP4

     

    SELECT SERVERPROPERTY('ProductLevel')--sp installed

    SELECT SERVERPROPERTY('Edition') -- this is useful to know which edition you are running, the results could be :"desktop engine," = MSDE 2000,"Developer Edition",etc

    and last but not least : SELECT @@VERSION

    Best regards

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply