Group29.com - What did you expect?
  Create an account
:: Home  ::  Downloads  ::  Your Account  ::  Forums  ::
Google Adsense
Modules
  • Home
  • Downloads
  • ExpectationReviews
  • Forums
  • Group29 FAQ
  • MovieReviews
  • OtherReviews
  • Stories Archive
  • Submit News
  • Top 10
  • Topics
  • Web Links
  • New at Group29
    ·Expectation Review: Avengers: Infinity War [24]
    ·Movie Review: Star Wars: The Last Jedi [16]
    ·Movie Review: Star Wars: The Last Jedi [23]
    ·2017 USC vs UCLA preview
    ·Forum Topic: Update your Facebook property
    ·2016 UCLA vs USC preview
    ·Expectation Review: Star Wars: The Force Awakens [29]
    ·Web Link: WEP Key Converter
    ·Forum Topic: Why does my IPA file get saved as a zip file in IE?
    ·Web Link: BeyondCompare

    read more...
    TheForce.Net
    ·Rebelscum Breast Cancer Awareness Charity Patch
    ·BBC Interviews J.J. Abrams About Trek And Wars
    ·CEII: Jabba's Palace Reunion - Massive Guest Announcements
    ·Fathead's May the Fourth Be With You!
    ·Star Wars Night With The Tampa Bay Storm Reminder
    ·Stephen Hayford Star Wars Weekends Exclusive Art
    ·ForceCast #251: To Spoil or Not to Spoil
    ·New Timothy Zahn Audio Books Coming
    ·SDCC: Exclusive Black Series Boba Fett With Han In Carbonite Set
    ·Star Wars Art Exposition May 4th

    read more...
    Hot trends
    ·Group29.com

    read more...
    Group29 Discussion Board :: View topic - Determine Microsoft SQL Server service pack version
    Log in Register Forum FAQ Memberlist Search
    Ratings, Links, Free Speech and more

    Group29 Discussion Board Forum Index -> Group29 Tech Tips -> Determine Microsoft SQL Server service pack version
    Post new topic  Reply to topic View previous topic :: View next topic 
    Determine Microsoft SQL Server service pack version
    PostPosted: Mon Jan 10, 2005 11:32 am Reply with quote
    BB
    Regular
     
    Joined: Jun 23, 2004
    Posts: 340


      


    This is covered in detail in this Microsoft Knowledge Base Article:
    http://support.microsoft.com/kb/321185

    HOW TO: Identify Your SQL Server Service Pack Version and Edition

    From Query Analyzer run
    Code:
    SELECT @@VERSION


    SQL Server 2005 (Code name Yukon)
    9.00.1399.06 SQL Server 2005 Release to Manufacturing (RTM)
    9.00.1314.06 SQL Server 2005 Community Technical Preview (CTP Sept 2005)
    9.00.1187.00 SQL Server 2005 Community Technical Preview (CTP June 2005)
    9.00.1116.00 SQL Server 2005 Community Technical Preview (CTP April 2005)

    SQL Server 2000 (Code name Shiloh)
    8.00.2039.0 SQL Server 2000 SP4
    8.00.818.0 SQL Server 2000 SP3a with hotfix/cumulative patch (KB #821277 )
    8.00.760.0 SQL Server 2000 SP3a
    8.00.760.0 SQL Server 2000 SP3
    8.00.534.0 SQL Server 2000 SP2
    8.00.384.0 SQL Server 2000 SP1
    8.00.287.0 SQL Server 2000 RTM + KB #297209
    8.00.194.0 SQL Server 2000 RTM (SQL Server release to manufacturing)

    SQL Server 7.0 (Code name Sphinx)
    7.00.1063 SQL Server 7.0 Service Pack 4 (SP4)
    7.00.961 SQL Server 7.0 Service Pack 3 (SP3)
    7.00.842 SQL Server 7.0 Service Pack 2 (SP2)
    7.00.699 SQL Server 7.0 Service Pack 1 (SP1)
    7.00.623 SQL Server 7.0 RTM (Release To Manufacturing)

    SQL Server 6.5 (Code name Hydra)
    6.50.479 SQL Server 6.5 Service Pack 5a (SP5a) Update
    6.50.416 SQL Server 6.5 Service Pack 5a (SP5a)
    6.50.415 SQL Server 6.5 Service Pack 5 (SP5)
    6.50.281 SQL Server 6.5 Service Pack 4 (SP4)
    6.50.258 SQL Server 6.5 Service Pack 3 (SP3)
    6.50.240 SQL Server 6.5 Service Pack 2 (SP2)
    6.50.213 SQL Server 6.5 Service Pack 1 (SP1)
    6.50.201 SQL Server 6.5 RTM

    SQL Server 6.0
    6.00.151 SQL Server 6.0 Service Pack 3
    6.00.139 SQL Server 6.0 Service Pack 2
    6.00.124 SQL Server 6.0 Service Pack 1
    6.00.121 SQL Server 6.0 RTM


    On SQL Server 2000 and 2005 you may also run:
    Code:
    SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')


    The results are:
    • The product version (for example, "9.00.1399.06").
    • The product level (for example, "RTM").
    • The edition (for example, "Enterprise Edition").
    View user's profile Visit poster's website
    Determine Microsoft SQL Server service pack version
      Group29 Discussion Board Forum Index -> Group29 Tech Tips
    You cannot post new topics in this forum
    You cannot reply to topics in this forum
    You cannot edit your posts in this forum
    You cannot delete your posts in this forum
    You cannot vote in polls in this forum
    All times are GMT - 6 Hours  
    Page 1 of 1  

      
      
     Post new topic  Reply to topic  


    Powered by phpBB © 2001-2003 phpBB Group
    Theme created by Vjacheslav Trushkin
    Forums ©
    Group29 Productions

    All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest (c) 2006 by Group29 Productions.


    You can syndicate Group29 Productions news with an RSS Feeder using the file backend.php


    PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
    Page Generation: 0.23 Seconds

    :: HeliusGray phpbb2 style by CyberAlien :: PHP-Nuke theme by www.nukemods.com ::