Results 1 to 8 of 8

Thread: problem with the selection of service pack.

  1. #1
    Join Date
    Sep 2007
    Posts
    14

    problem with the selection of service pack.

    Dear friends,
    I have a problem with the selection of download file in the microsoft website for SP4.
    For 32 bit database pattern and for 64 bit database pattern they are providing 2 separate files. I want to select the right one which fit to my current environment.
    So how i know the bit pattern of my current database
    and how i know the bit pattern in operating system level.

    Any reply to my doubts is greatly appreciating.
    I am new in your group. please help me.

    Thank you
    Ichayan

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,922
    What version of SQL Server are you using?. You can get that by running

    select @@version

    Download the SP4 for the version that you have.

  3. #3
    Join Date
    Sep 2007
    Posts
    14
    Hi skhanal,
    my version is sp3a.
    i have to upgrade to sp4 with build 2187.
    If you go to the following link you can see that there are two separate files for 32 bit and 64 bit database. here which one i have to choose. how i know my database is 32 bit level or 64 bit level.
    please ...help me.

    Thank you

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    If you see (Intel X86) in result of 'select @@version', you have 32-bit sql2k. By the way, 64-bit sql2k works on Itanium machine only.

  5. #5
    Join Date
    Sep 2007
    Posts
    14
    HI friends,
    THANK YOU FOR YOUR HELPS.
    I REALY PROUD BY JOINING WITH YOU IN THE DISCUSSIONS.
    THANKS A LOT

    ICHAYAN

  6. #6
    Join Date
    Jun 2006
    Posts
    28
    Just curious if 'select @@version' statement actually shows us the SQL server version; because last time when I ran this command it showed me the windows version.

    Thanks

  7. #7
    Join Date
    Sep 2002
    Posts
    5,938
    In fact, it gives you both sql and os version.

  8. #8
    Join Date
    Jun 2006
    Posts
    28
    Oops I didn't pay attention to it. Thanks for the info.

Posting Permissions

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