Problem updating Report Builder 1.0 Model in SQL Server 2008 R2

Thursday, January 6, 2011

So, as you may have gathered from the previous post, we installed SQL Server 2008 R2 in the municipality not too long ago. And yes, that led to all sort of problems... One of the main problems that all of us encountered, was that we couldn't update our report models. Yes, we could start a new Report Builder 1.0 Project. We could define a DSV and autogenerate a Report Model. But then, if we added a table to the DSV or new columns were added to an existing table, and then we would run an Autogenerate on the Report Model...

SQL Server 2005 SP3

Tuesday, December 16, 2008

Wow, it's here! After the phase of SQL Server 2005 SP3 beta has ended, Microsoft has announced that SQL Server 2005 SP3 is available for download. SQL Server 2005 SP3 includes all cumulative updates up until and including Cumulative Update 9. Though it has just been released, there is already a Knowledge Base article about customizing the TokenAndPermUserStore cache store in SQL Server 2005 SP3 Still, if you have installed SQL Server 2005 Cumulative Update 9 or SQL Server 2005 Cumulative Update 10, then you may have encountered an error message such as "Unexpected Error Occurred" which was already...

SQL Server SP3 Beta and more news

Tuesday, October 28, 2008

Well apparently, you can miss out on a lot of things during a two weeks vacation. Luckily I came back in time to see SP3 Beta for SQL Server 2005 get released! But I'll talk about that in a bit... The announcement of Project Gemini in SQL Server 2010 sparked a very heated debate in the BI Community, over how much it might be abused by users as an alternative to an organized DW \ OLAP solution. The discussion did not go unnoticed by Microsoft. I guess I can only sum up by saying that we'll see what happens in...

Cumulative Update Package 9 for SQL Server 2005 SP2

Tuesday, August 19, 2008

CU9 for SQL Server 2005 Service Pack 2 has just been released, which I should have guessed as the grounds have also been made for Cumulative Update Package 10 as well. It seems that you may need CU9 to correct a bug caused from installing Cumulative Update Package 7. What's the problem? Apparently you may get an error message after installing CU7, when you explicitly define a slice at a partition and then process the partition by using a query that returns no records. To read more about the problem that may arise from CU7, that was fixed in...

Cumulative Update Package 8 for SQL Server 2005 Service Pack 2

Wednesday, June 18, 2008

CU8 for SQL Server 2005 Service Pack 2 has just been released, which also means that the grounds have also been made for Cumulative Update Package 9 as well. Microsoft recommends that in general, you only install Cumulative Updates to correct problems described in the knowledge base articles relevant to that CU. That said, Cumulative Update Package 8 can, amongst other things, correct something related to Cumulative Update Package 6. It seems that queries that use a cursor run faster on previous builds than they do on CU6. This problem was fixed in CU8, and so if you...

Cumulative Update Package 7 for SQL Server 2005 Service Pack 2

Thursday, April 17, 2008

Microsoft has recently announced the release of Cumulative Update Package 7 for SQL Server 2005 Service Pack 2. CU 7 comes 2 months after its predecessor (just like they promised) and yet again, the groundwork is already built for Cumulative Update Package 8. You can read more about Cumulative Update Package 7 and also download CU 7 upon request from Microsoft Support. You should be aware though, that the Microsoft PSS SQL Support team has announced that installing Cumulative Update Package 7 can impact your SSAS backup and sync operations....

Cumulative update package 5 for SQL Server 2005 Service Pack 2

Sunday, December 23, 2007

Cumulative update 5 was released last week (18th of December 2007). Cumulative update 5 contains hotfixes for SQL Server 2005 issues that have been fixed since the release of Service Pack 2. For more details please read the knowledgebase article. More importantly, to download it, please submit a request to Microsoft.   As always, the release of one cumulative package, also means another one is in the works. And this time is no exception…

Cumulative update package 4 for SQL Server 2005 Service Pack 2

Tuesday, October 16, 2007

CU 4 was released yesterday, and as in previous versions, contains the hotfixes that have been developed since the release of SP2. Like with cumulative update 3, this one is also multilanguage and is available through writing a request to Microsoft Online Customer Services at To install cumulative update package 4 for SQL Server 2005 Service Pack 2, you need to enable the SMO and the SQL-DMO stored procedures. The cumulative update is also known as build 3200. For further detail, please see the knowledge base article.

Cumulative Update #3 for SQL Server 2005 Service Pack 2

Saturday, August 25, 2007

Goodness, it's feels like I just blinked there for a moment, and already Microsoft is releasing a new cumulative update for SQL Server 2005 SP2! The build of the cumulative update package is also known as build 3186. The knowledge base article is here and the download itself is available here, and you can download the version in which ever language suits you. And just so you don't think the guys at Microsoft are resting on their laurels, I would tell you that obviously, Cumulative Update #4 is already in the works...