Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll

I have been struggling since a few days with the following issues on MS Analysis Services 2008. When I try and create a Data Source with the Provider "Native OLE DB\SQL Server Native Client 10.0" I was not able browse the list of databases. The list of databases always remained empty.

When I click on Test Connection I get the following error message "Test connection failed because of an error in initializing provider. Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The system cannot find the path specified".

After searching for the resolution on Internet, I found that I may have to reinstall my .Net Framework 2.0. Although, Windows will not allow me to remove my .Net Framework. It turned out that since I additionally had .Net Framework 3.0 and 3.5 installed, I had to remove them first before removing 2.0. And it worked..

After reinstalling .Net Framework 2.0 and all others I was able to browse the databases. Hope it helps...

Meanwhile, till the time I was not able to work with "Native OLE DB\SQL Server Native Client 10.0" I used ".Net Providers\SqlClient Data Provider"

Error "Unable to get the window handle for the 'ActionsAwarePivotTable' control."

I got the following error "Unable to get the window handle for the 'ActionsAwarePivotTable' control." while browsing the cube in SQL Server Analysis Services 2008.

It turns out that you get this error message when your Lotus Notes is up. The error went away after closing the Lotus Notes.

Wish there were better integration between IBM and Microsoft. :-)

SQL Server 2008 Installation error for Reporting Services

If you get the following error while installing SQL Server 2008 "The Reporting Services catalog database file exists. Select a Reporting Services files-only mode installation.", please follow the link on Microsoft Support page. http://support.microsoft.com/kb/956095

To resolve this issue, move, rename, or delete the existing Report Server databases. Or, use a different instance name.

SQL Server 2008 Installation error for "Restart failed"

While trying to install SQL Server 2008 the installation may not proceed showing that Restart has failed. Even though you restart your computer it may show you the same message.

Check your system's pending file rename operations registry key. It should be cleared after you reboot your system. If not, something must be wrong.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations

DMV a day by Glen Berry

Last month Glen Berry started a fantastic series called "DMV a day" and posted one DMV everyday.

This post has a compilation of all 30 DMV's.

Transfer Tables between Schemas

Sometimes we accidentally create table in our own user schema instead of dbo (or others). The following code translates between different schema.

Suppose there is a table called Employee which has been created in ragarwal schema instead of dbo. The following code will transfer it to dbo from ragarwal schema.

ALTER SCHEMA dbo
TRANSFER ragarwal.Employee

More on Alter Schema at the following MSDN Link.

Record Resultset from Stored Procedure in a Table

There may be times when a Store Procedure outputs a Rowset and you may want to capture the results in a database table.

(The below example is executed on the AdventureWorks database)

Here is how you can do that. Suppose you have a Stored Procedure named LoadEmployee and it accepts the three parameters MaritalStatus, Gender and SalariedFlag and it outputs the resultset from the HumarResources.Employee table. Now, if you are interested in finding all salaried single ladies from the table and store it in EmployeeMaster table, this is how you do..

INSERT INTO dbo.EmployeeMaster
EXEC dbo.LoadEmployee @MaritalStatus = 'S', @Gender = 'F', @SalariedFlag = 1

And the output will be stored in a table.