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...