Class does not support aggregation

I am trying to port a database from SQL Server 2005 Express to SQL
Server 2005 Standard. I
detached my database from the SQL Sever 2005 Express instance and
attached it to the SQL Server 2005 Standard instance. Whenever I do a
select on tables in the database I have no problem. However if I
attempt to open or modify a table by selecting open or modify from the
popup menu, I get the following error --

TITLE: Microsoft SQL Server Management Studio
----------

Class does not support aggregation (or class object is remote)
(Exception from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION))
(Microsoft.SqlServer.SqlTools.VSIntegration)

----------
BUTTONS:

OK
----------

I tried repairing the .NET 2.0 framework but to no avail.

Please help!!!

Thanks,Crazy Cat (danbredy@.hotmail.com) writes:
> I am trying to port a database from SQL Server 2005 Express to SQL
> Server 2005 Standard. I
> detached my database from the SQL Sever 2005 Express instance and
> attached it to the SQL Server 2005 Standard instance. Whenever I do a
> select on tables in the database I have no problem. However if I
> attempt to open or modify a table by selecting open or modify from the
> popup menu, I get the following error --
> TITLE: Microsoft SQL Server Management Studio
> ----------
> Class does not support aggregation (or class object is remote)
> (Exception from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION))
> (Microsoft.SqlServer.SqlTools.VSIntegration)
> ----------
> BUTTONS:
> OK
> ----------
> I tried repairing the .NET 2.0 framework but to no avail.

Sounds like a bug in Management Studio. Could you create a new table
with the same definition, and see how it that works? If the error
persists, could you post the CREATE TABLE statement?

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland Sommarskog wrote:
> Crazy Cat (danbredy@.hotmail.com) writes:
> > I am trying to port a database from SQL Server 2005 Express to SQL
> > Server 2005 Standard. I
> > detached my database from the SQL Sever 2005 Express instance and
> > attached it to the SQL Server 2005 Standard instance. Whenever I do a
> > select on tables in the database I have no problem. However if I
> > attempt to open or modify a table by selecting open or modify from the
> > popup menu, I get the following error --
> > TITLE: Microsoft SQL Server Management Studio
> > ----------
> > Class does not support aggregation (or class object is remote)
> > (Exception from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION))
> > (Microsoft.SqlServer.SqlTools.VSIntegration)
> > ----------
> > BUTTONS:
> > OK
> > ----------
> > I tried repairing the .NET 2.0 framework but to no avail.
> Sounds like a bug in Management Studio. Could you create a new table
> with the same definition, and see how it that works? If the error
> persists, could you post the CREATE TABLE statement?
Actually I found a post somewhere that suggested uninstalling the
workstation components, repairing the .NET 2.0 framework, and
reinstalling the workstation.
I worked perfectly. I just wanted to post back in case someone else ran
into the same problem.

Thanks for replying.

> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx|||Hi,

Crazy Cat wrote:

> Actually I found a post somewhere that suggested uninstalling the
> workstation components, repairing the .NET 2.0 framework, and
> reinstalling the workstation.
> I worked perfectly. I just wanted to post back in case someone else ran
> into the same problem.

you probably had the CTP Express Version of the Mangement Tool
installed previously, and then uninstalled it after the release-version
of SQL2005 had been installed?!

At least that's what I did, and I'm getting the same error.
I'll try just reinstalling the 2005 client tools...

--
Stefan Klepsch