Results 1 to 6 of 6

Thread: Sql 2000 Sp3a

  1. 08-05-2003, 02:18 PM #1
    jtav
    jtav is offline Registered User
    Join Date
    Sep 2002
    Posts
    41

    Sql 2000 Sp3a

    Select @@version does not know the difference between SP3 and SP3A.

    Does anyone know of a SQL statement that will let me know if I have SP3A??

    Thanks.
    Reply With Quote Reply With Quote
  2. 08-05-2003, 02:58 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Tried 'SELECT SERVERPROPERTY('productversion')'?
    Reply With Quote Reply With Quote
  3. 08-05-2003, 03:11 PM #3
    jtav
    jtav is offline Registered User
    Join Date
    Sep 2002
    Posts
    41
    Yes, I have tried:
    'SELECT SERVERPROPERTY 'productversion')'

    It returns 8.00.760 for SP3 and SP3A.

    That's my problem.

    Thanks.
    Reply With Quote Reply With Quote
  4. 08-05-2003, 03:33 PM #4
    ravi
    ravi is offline Registered User
    Join Date
    Nov 2002
    Posts
    231
    Try this

    SELECT SERVERPROPERTY('ProductLevel')
    Reply With Quote Reply With Quote
  5. 08-05-2003, 03:34 PM #5
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Did you check sqlservr.exe file properties?.

    I am not sure whether 3a installs a new .exe

    If not the version may have remained same.
    Reply With Quote Reply With Quote
  6. 08-05-2003, 03:58 PM #6
    jtav
    jtav is offline Registered User
    Join Date
    Sep 2002
    Posts
    41
    Yep. I have checked the version numbers of the sqlservr.exe file properties.

    SP3 and SP3A are the same.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules