Post reply

Finding SQL Version

  • January 9, 2009 at 2:06 pm

    #155109

    When i run select @@Verion i see the following result. how could i tell, what SP and Cumalative patch installed on this server?

    Microsoft SQL Server 2005 - 9.00.3282.00 (X64) Aug 5 2008 00:48:00 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

    Apprecaited if someone please share this.

    Thanks,

  • January 9, 2009 at 2:12 pm

    #924589

    http://support.microsoft.com/default.aspx/kb/321185

    Has data on version numbers.

    http://support.microsoft.com/kb/937137/

    Has data on cumulative update version data.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • January 9, 2009 at 2:12 pm

    #924590

    The following will give you similar info, product level states SP.

    select serverproperty('ProductVersion') as ProductVersion,serverproperty('Edition') as Edition,serverproperty('ProductLevel') as ProductLevel

    and this link has list of build version

    http://www.sqlservercentral.com/articles/Administration/2960/[/url]

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • January 9, 2009 at 3:07 pm

    #924638

    Thanks for providing the info. it was very helpful and solved my purpose.

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

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