hot fix service number

  • what is hot fix service number ?what is build version?

    .how do u know the all service packs,hotfixes, build versions which are installed in the server?

  • Run command select @@version

    7.0.nnnn = SQL 7

    8.0.nnnn = SQL2000

    9.0.nnnn - SQL2005

    10.0.nnnn = SQL2008

    10.5.nnnn = SQL2008R2

    nnnn denotes the SP\Hotfix level.

    On this site do a search on 'build list'. Steve jones the editor helpfully maintains a list that will tell you which releases have been applied.

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

  • An alternative to what George posted is at: http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

    This site includes not just major builds but build numbers including different patches and hotfixes.

  • The following site lists all versions of SQL with a link to what exactly is in each update/release.

    http://sqlserverbuilds.blogspot.com/

    Hope this helps.

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

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

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