SQL Server 2005 Build List

  • A new one.....

    9.00.2050 KB932555 was delivered via Windows update.

  • Does anybody know if this build list can be downloaded from some place ?

    (for the moment I tend to keep up the copy/paste way )

    This way we can match it to our inventory database and get an actual standing of our sqlservers.

    Paperwork has some flaws

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • New one...

    Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

  • What does the date represent in the string? I have two instances on my machine Standard and SQLExpress with 2 different dates.

    Microsoft SQL Server 2005 - 9.00.1406.00 (Intel X86) Mar 3 2007 18:40:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

    and

    Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

    by the way the first is not in this list.

  • Cumulative hotfix package (build 2153) for SQL Server 2005

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

  • Just to provide a link to another buildlist (also contains sql2000 and sql7 builds)

    http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • http://support.microsoft.com/kb/919224/en-us 

    9.00.2153

    Error message when you connect to an instance of SQL Server 2005 Integration Services by using SQL Server Management Studio on a computer that has a 64-bit processor: "Connect to SSIS Service on machine <computer_name> failed"

  • Thanks for the notes and those 3 (2150, 2153, 3054) have been added.

    Also added a CSV to the article so you can download the list. I'll try to keep it as up to date as possible.

  • Thanks for the csv

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • I am nothing but disgusted that M$ is doing such a poor Job!

    I would have never expected that "we" are compiling those and M$ is simply playing catch up with the bugs!


    * Noel

  • I have to admit that I'm a little surprised at the number of builds that have been released. I know there are lots of fixes for different components, but this still seems like a lot of fixes.

    The other thing that bothers me is the number of builds in April alone. Today is the 10th. I wouldn't have expected more than 1 in April, especially with SP2 just being released.

    And you are welcome for the CSV. We aim to please!

    Working on SS2K builds as well, but there's a lot of those to load.

  • Here are 4 new hotfixes (april 2007), for the same problem (regarding scripts in SSIS):

    - post-SP1 hotfix version 9.00.2221, downloadable from KB article 931593.

    - post-SP1 hotfix version 9.00.2050, KB 932555 (already added in the list)

    - hotfix version 9.00.1561, KB 932556

    - hotfix version 9.00.1406, KB 932557

    It's interesting to note that there is no post-SP2 hotfix yet, although the problem is not documented as fixed in SP2. KB Article 931846 documents that this problem is fixed in SP2.

    Razvan

  • Steve, thank you.  You can't believe how many times I've tried to find a complete list...

  • God bless you Steve! Really handy list that I could'n find anywhere.

    Thank You!

  • Excellent, thank you!

    Microsoft should hang their heads in shame and make this information EASILY AVAILABLE themselves!

    It would also helpful if @@VERSION returned a unique software level. We became really confused after applying the original SP2, then the first GDR. We used the re-released SP2 on subsequent builds (which included the GDR changes) and found that @@VERSION (i.e. sqlserver.exe) was different between the builds. It didn't even match that expected in KB 933508. They amended the KB later.

    GET THE BASICS RIGHT MICROSOFT!!!!

Viewing 15 posts - 1 through 15 (of 98 total)

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