|
Home > Archive > Microsoft SQL Server forum > February 2006 > Class does not support aggregation
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Class does not support aggregation
|
|
| Crazy Cat 2006-02-07, 11:24 am |
| 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_NOAGGREGATI
ON))
(Microsoft.SqlServer.SqlTools.VSIntegration)
------------------------------
BUTTONS:
OK
------------------------------
I tried repairing the .NET 2.0 framework but to no avail.
Please help!!!
Thanks,
| |
| Erland Sommarskog 2006-02-07, 8:24 pm |
| 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_NOAGGREGATI
ON))
> (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
| |
| Crazy Cat 2006-02-07, 8:24 pm |
|
Erland Sommarskog wrote:
> Crazy Cat (danbredy@hotmail.com) writes:
>
> 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
|
|
|
|
|