Results 1 to 7 of 7

Thread: service pack in SQL

  1. #1
    Join Date
    Oct 2002
    Location
    queens
    Posts
    139

    service pack in SQL

    How would i find out whhich service pack applied to a sql server 2000?

    Thanks in advance!!!

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    select @@version will tell you.

    example

    http://www.krell-software.com/mssql-builds.htm

  3. #3
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    If you see numbers above 8.00.760 it means those are hot fixes like




    Microsoft Knowledge Base Article - 821334

    Microsoft Knowledge Base Article - 831997

    Microsoft Knowledge Base Article - 838460

  4. #4
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Wish list......

    Microsoft should organize their SQL Server Website with all the SQL related SPs and Patches in the same page with KB articles.

  5. #5
    Join Date
    Oct 2002
    Location
    queens
    Posts
    139
    Thanks

  6. #6
    Join Date
    Jan 2003
    Posts
    58
    Use any one of these:

    SELECT SERVERPROPERTY('ProductLevel')

    master..xp_msver

    select @@version

  7. #7
    Join Date
    Oct 2002
    Location
    queens
    Posts
    139
    That's great, thanks a lot!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •