Posts

Showing posts from December, 2010

SSAS: Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))

Image
Today, I've no idea what happend to my SSAS suddenly!! but I got that nasty error while browsing one of my cubes. Searched it down and found that you'll need to re-install the ' office 2003 web components ' Although I'm using Office 2010 for the last 2 Months. Also if you have time, please read that... will explain more Office Web Components “Roadmap”

Server Explorer not showing up on Visual Studio 2008

Hello, VS 2008 is acting up lately on me! nothing happens when you click on "server explorer" from the VIEW menu, or press "Ctrl + Alt + S". The fix is to open a Visual Studio Command Prompt   and run   devenv /resetsettings or devenv /setup

How to Setup Row-Level Security for SQL Server - Linked Article

Before I used to do it through several 'Views' and grant different permissions to each View, but recently I came across this good article by K. Brian Kelley.... How to Setup Row-Level Security for SQL Server

T-SQL Display Month Numbers and Names

SELECT Number + 1 as [Month Number], DateName(mm,DATEADD(mm,Number,0)) as [Month Name] FROM master..spt_values WHERE Type = 'P' and Number < 12