Posted by Crazy Cat on 02/07/06 19:15

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,

• Next in forum: Help with tricky T-SQL
• Prev in forum: Re: one for the SQL experts - dare I say TRICKY SQL!
• Thread view: Class does not support aggregation

[Reply to this message]