Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    78

    Unanswered: how to identify the fixpack level?

    hi,
    for sql server 2000, how can we find the fixpack(service pack) level installed on this sql server?
    is there any command, or any gui tool to identify the level?

    tnks

  2. #2
    Join Date
    Nov 2003
    Posts
    68

    you can use this

    SET NOCOUNT ON
    SELECT CONVERT(CHAR(25),@@SERVERNAME) AS 'SQL SERVER',
    SUBSTRING(@@VERSION,23,4) AS 'PRODUCT VERSION',
    SUBSTRING(@@VERSION,35,3) AS 'BUILD NUMBER',
    CASE SUBSTRING(@@VERSION,35, 3)
    WHEN '194' THEN 'NO SP'
    WHEN '384' THEN 'SP1'
    WHEN '534' THEN 'SP2'
    WHEN '760' THEN 'SP3'

    ELSE 'Unknown - may be a Hot-Fix version or script out of date'
    END AS 'SERVICE PACK'
    set nocount off

  3. #3
    Join Date
    Dec 2003
    Posts
    78
    thanks philio,
    how about service pack 3a, is there an id also to distinguish it from sp3??

  4. #4
    Join Date
    Dec 2002
    Posts
    1,245
    SP3 and SP3a have identical build numbers (760).

    Also, you can use this:

    Code:
    SELECT
    	cast(@@microsoftversion / power(2, 24) as varchar(2)) + '.00.' + cast(@@microsoftversion & 0xffff as varchar(4)) as VERSION
    To derive version info...

    hmscott
    Quote Originally Posted by shedb
    thanks philio,
    how about service pack 3a, is there an id also to distinguish it from sp3??
    Have you hugged your backup today?

Posting Permissions

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