Category: SQL Server 2005
Very early this morning, Microsoft released four updates: one for SQL Server 2005 SP3, one for SQL Server 2005 SP4, one for SQL Server 2008 SP1, and one for SQL Server 2008 SP2. Cumulative...
In a previous blog post about Service Pack 4, I said the following: "…from this point forward all you're likely to see are cumulative updates to the SP3 and SP4 branches and, roughly a...
Well, much quicker than I would have suspected, the SQL Server Release Services team has incorporated all of the fixes in 2005 SP3's CU #12 into the first CU for SP4. Thanks to Chris...
After releasing SQL Server 2005 SP4 on Friday (you can read more about it here), the release services team did not hang up their hats for the Christmas holiday, but continued working on other...
Yes, the day has finally arrived, and a couple of weeks ahead of schedule. Typically when Microsoft promises a release in Qx or Hx, the software comes on the last or second last day...
Yesterday, Microsoft released a Community Technology Preview (CTP) of SQL Server 2005 Service Pack 4. You can read about the release on the following blog post from SQL Release Services: http://blogs.msdn.com/b/sqlreleaseservices/…preview-available.aspx If you don't...
Today Microsoft has released two updates for SQL Server. Listed below are the two updates, the blog posts from the SQL Server Release Services team, and the KB articles where you can read about...
Last week, Microsoft released Cumulative Update #8 for SQL Server 2005 SP3. The build # is 9.00.4285. You can read the blog post from the Release Services team here: http://blogs.msdn.com/sqlreleaseservices/archive/2010/02/15/cumulative-update-8-for-sql-server-2005-service-pack-3.aspx And the Knowledge Base...
Last week Microsoft snuck in some updates for the SQL Server 2005 product line. Cumulative Update #7 for Service Pack 3 brings you to build # 9.00.4273, while Cumulative Update #17 for Service Pack...
In our environment, we run the task scheduler as a cluster resource, so that scheduled tasks always run on the active node. (In ancient history, we would have scheduled tasks that weren't cluster aware...
Some new updates just posted by SQL Server Release Services: For SQL Server 2005 SP2, build 9.0.3355: http://support.microsoft.com/kb/974647 For SQL Server 2005 SP3, build 9.00.4266: http://support.microsoft.com/kb/974648 On first glance, it does not appear that...
Sleeping at the wheel again, I missed some big updates for SQL Server 2005 this past Monday. Cumulative Update #5 for SP3 brings you up to 9.00.4230 (the previous update was 9.00.4226). http://support.microsoft.com/kb/972511 Cumulative...
Microsoft quietly released another cumulative update for SQL Server 2005 Service Pack 3 this week. So quietly, in fact, that it took me 5 days to notice. As Chad Miller noted in his comment,...
It seems this came out on April 20th, but I did not catch it at the time. Better late than never, I guess. As Sean Nolan pointed out in a previous post, CU#3 includes...
What this says to me is, if any of your clusters have automatic updating turned on, you might get SP3 as a surprise. Since the blog post states that it must be run in...
The recent release of security fixes for SQL Server 2000 and 2005 (the issue did not impact SQL Server 2008) announced in MS09-004 seemed to spur two SQL Server 2005 cumulative updates (CUs) earlier...
Early reports indicate that some users running Express <= SP2 are getting SP3 for Express pushed to their system automatically as an important update, rather than recommended, which means that some users are getting...
Chris Wood let me know that the update is now being pushed through Windows Update / Microsoft Update.
So recently I have been charged with updating several SQL Server 2005 clusters from SP2 + GDR to SP3. My experiences have been relatively good but the past few have been downright horrible. I...
As promised, upon return from a trip to the frozen tundra of Northern Ontario, I am posting the latest updates from last week's release of SQL Server 2005 Service Pack 3. For those who...
I recently posted about the availability of SQL Server 2005 SP3. I have a bit more information about cumulative updates and the service pack, for those of you who might be confused about the...
UPDATE 2008-12-16, from the team, regarding SP3 CU1: CU#1 on SP3 is nothing but a rollup of fixes from SP2 CU#10 and SP2 CU#11 that did not make it into SP3 release as these...
Don't be fooled by the poor title on the page, which still says "SQL Server 2005 Books Online (September 2007)" (clearly a leftover from an earlier BOL update). The text under the overview section...
Okay, it happened a couple of days ago; sorry for not noticing. But SQL Server Release Services / Sustained Engineering has announced that an SP3 Beta has been made available. The build is 9.00.4028...
Microsoft quietly released CU #9 (build 9.00.3282) yesterday; it contains a few dozen fixes, including a nasty AV involving UNION queries, documented in KB #956006. You can read about / obtain the cumulative update...
Currently, the plans for IntelliSense are to support SQL Server 2008 *ONLY*… since it works against SQL Server 2005 in the February CTP, I was very surprised to learn that it is being dropped...
Bob Ward posted a blog entry today where he explains the process of getting a cumulative update for SQL Server 2005 without having to call Microsoft's support team (they are called CSS now but...
Microsoft has committed publicly to releasing Service Pack 3 for SQL Server 2005. Francois Ajenstat first talked about it very recently here. While there were some casual mentions of the release in some responses...
Cumulative Update 6 for SQL Server 2005 is now available. This is build 3228. http://support.microsoft.com/kb/946608 Looks mainly like fixes to replication, reporting services, and analysis services. But there appear to be some fun access...
For years, ever since I started posting build lists over at aspfaq.com (don't go there now; it's been taken over by malware slimeballs), I have been complaining that Microsoft makes it very hard for...
Microsoft has released a new cumulative update (build 3200) for SQL Server 2005. http://support.microsoft.com/default.aspx/kb/941450 Adam has pointed out that the wording in the article is incorrect; it calls these post-SP3 updates, which is obviously...
A new CU (Build 3186) has been issued by Microsoft in KB #939537, though unlike previous updates, this one is not readily available for public consumption. You must fill out a form to obtain...
Updated: 2007-07-02 Continuing with a great tradition, I present again an updated list of SQL Server builds and hotfixes that have been released since the last time I posted a similar list (beginning of May). ...
For years I have been an advocate of making any and all hotfix information available to the public. I used to stumble upon new builds in the KB by accident, and so I took it...
Sorry, this table looks much better in preview mode than publish mode <shrug>. KB Title Build # KB #932557 FIX: A script task or a script component may not run correctly when you run...
James Howey of Microsoft gave us a very thorough explanation on the differences between a GDR and a QFE, what happened in SP2, and how to decide which build you should be aiming for. I'm going...
4/6 Here is some more info from Steve Kass. He paraphrased Microsoft's internal response to the confusion about who should install 3054 and who should install 3159. <snip>3054 includes the new fix along with...
I'm still waiting for the latest GDR / QFE that is going to clean up (no pun intended) all the maintenance plan cleanup issues that were borne out of SP2 and the followup fixes....
So I have official word (and permission to broadcast) that there is one minor bug left in maintenance plans, in the wake of last week's difficulties in properly addressing SP2 and the fixes that...
Well, I'm certainly glad I didn't bet that 3050 would be the last we'd hear about SP2. It's like alphabet soup, I think 3152 (found at http://support.microsoft.com/kb/933097/ – Thanks Chris!) could unofficially be called SP2c...
Since I probably won't be the "first post!" winner, I'll go over the highlights of what you're getting (some of which are not mentioned in the What's New document). Before I do that I'll...
The SQL Server team is keeping quite busy (and keeping us busy as a result). Today Paul Mestemaker II announced in the SQL Server Manageability Team Blog that a brand new CTP of Service...
Now that SQL Server 2005 is over a year old (what a big boy you are!), the beta builds are irrelevant, but the post-RTM builds fix some issues that may be quite important to...