SQL Server 2005 Build List

Question

Post reply

SQL Server 2005 Build List

Steve Jones - SSC Editor

SSC Guru

Points: 736252
More actions
April 23, 2007 at 12:00 am

#75141

Comments posted to this topic are about the item SQL Server 2005 Build List

Viewing 15 posts - 16 through 30 (of 98 total)

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

Linda-57932 SSC Journeyman Points: 79 More actions · Answer 1

Updated Hotfix for SP2 for 2005 has been released - build 3161

http://support.microsoft.com/kb/935356/en-us

The number of bugs fixed by this hotfix is 29 but it’s not publicly available…

Graham_Day Ten Centuries Points: 1103 More actions · Answer 2

Print version is broken:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/columnists/sjones/2960_printversion.asp, line 23

slsmithstone SSC-Addicted Points: 431 More actions · Answer 3

Excellent article!

Where are you supposed to vote?

Steve Jones - SSC Editor SSC Guru Points: 736252 More actions · Answer 4

The voting is at the bottom and the print version has been fixed. I've also updated the CSV with these numbers.

SanjayAttray SSChampion Points: 13157 More actions · Answer 5

I am not able to download csv file. Give me invalid page error. Am I only getting this error or everyone.

SQL DBA.

EugeneZ-162636 Default port Points: 1448 More actions · Answer 6

Good job!

Can we have the list some where easy accessible on sqlservercentral.com, for future references?

It would be nice to go there and quickly to check what is new.

Thanks,

EugeneZ

P.S. could you add 'spelling' to reply editor?

Cullen Lowe-436363 SSC Veteran Points: 226 More actions · Answer 7

You may have preferred that I begin a new topic, but since I did a search for KB932555 and this was the only applicable thread, here I am. Also, as this is my first post hopefully you will all be tolerant.

Anyway, I have been happily running SQL Server version 9.00.2047.00, and in fact I need to remain on this version due to requirements by Sage MAS 500. What I did was deploy what I thought was a Hot Fix for Service Pack 1, KB 932555. It did not seem like all that big a deal.

Now, however, SQL Server 2005 is up to version 9.00.2050.00, which is SP2. Am I going totally insane here or did this "Hot Fix" upgrade me to SP2?

Thanks in advance.

Razvan Socol SSCarpal Tunnel Points: 4811 More actions · Answer 8

Cullen,

Version 9.00.2050 is not SP2, it's just a post-SP1 hotfix. SP2 is 9.00.3042

Razvan

Cullen Lowe-436363 SSC Veteran Points: 226 More actions · Answer 9

Thanks, do you know why I get this?

select @@version:

Microsoft SQL Server 2005 - 9.00.2050.00 (Intel X86)

Feb 13 2007 23:02:48

Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Cullen Lowe-436363 SSC Veteran Points: 226 More actions · Answer 10

Never mind, sorry, that was the O/S. My bad.

Here is the bottom line, the message from MAS 500:

You are running SQL Server version 9.00.2050.00. Sage MAS 500 currently supports SQL Server versions between 9.00.1399.06 and 9.00.2047.00. Continuing to use Sage MAS 500 with your current version of SQL Server may result in a loss of data.

It is recommended that you revert to a version of SQL Server supported by Sage MAS 500.

Razvan Socol SSCarpal Tunnel Points: 4811 More actions · Answer 11

You can either uninstall the KB 932555 hotfix (if you don't use those SSIS features) or contact Sage Software support for an updated version of their software.

Anyway, you should open a different thread if you want to continue this conversation.

Razvan

Cullen Lowe-436363 SSC Veteran Points: 226 More actions · Answer 12

Thanks, will do. I really appreciate your time and advice.

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 13

There's a little inconcistency in the csv.

data for build 9.00.1532 isn't in the same layout as the other ones !

(the URL position has shifted !)

9.00.1528,915306,http://support.microsoft.com/?kbid=915306, FIX: The merge agent fails and a "permission denied" error message is logged when you synchronize a SQL Server 2005-based merge publication,2007-01-08 00:00:00.000

9.00.1532,916046,KB916046 : FIX: Indexes may grow very large when you insert a row into a table and then update the same row in SQL Server 2005,http://support.microsoft.com/?kbid=916046,2007-01-09 00:00:00.000

Some rows are contained within double quotes, also ruining my auto upload

Maybe converting to a TSV (tab separated) could solve the issue with KB-titles containg commas.

Thank you for this great info summary.

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

Brian Brown-204626 Hall of Fame Points: 3211 More actions · Answer 14

I have four SQL Server 2005 SP2 installs which show 9.00.3033.00 as the Product Version. I do not find this in your list. Can anyone tell me what this build is for?