Post reply

SQL 2005 64 bits SP

  • January 14, 2010 at 11:47 am

    #138266

    HI,

    Where I can find the list of SP for SQL 2005 64bits and the build attached to it?

    On one server I am on version:

    Microsoft SQL Server 2005 - 9.00.3282.00 (X64) Aug 5 2008 00:48:00 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

    While on another one the version is:

    Microsoft SQL Server 2005 - 9.00.4035.00 (X64) Nov 24 2008 16:17:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

    Thanks

    Rem

  • January 14, 2010 at 11:53 am

    #1103831

    Rem-487422 (1/14/2010)

    HI,

    Where I can find the list of SP for SQL 2005 64bits and the build attached to it?

    Thanks

    Rem

    not sure what you mean...SP=Stored Procedures, right? Stored procedures are not 32 or 64 bit, they are simply compiled code that happens to exist on a 32 bit or 64 bit installation.

    Are you refering to extended stored procedures?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • January 14, 2010 at 11:56 am

    #1103832

    Hello,

    By SP, I meant Service Pack.

  • January 14, 2010 at 12:15 pm

    #1103843

    doh! rereading, i can see that;

    this should help:

    http://support.microsoft.com/kb/321185

    2005 versions:

    For example, the results resemble the following. Collapse this tableExpand this table9.00.1399.06 RTM Enterprise Edition

    The following table lists the Sqlservr.exe version number. Collapse this tableExpand this tableRelease Sqlservr.exe

    RTM 2005.90.1399

    SQL Server 2005 Service Pack 1 2005.90.2047

    SQL Server 2005 Service Pack 2 2005.90.3042

    SQL Server 2005 Service Pack 3 2005.90.4035

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply