>Thread-Topic: Class does not support aggregation
>thread-index: AcYdzJqnv7Gvd6SmT+qRbL0nvajMoA==
>X-WBNR-Posting-Host: 194.131.103.210
>From: "=?Utf-8?B?UmljaA==?=" <richvista@nospam.nospam>
>Subject: Class does not support aggregation
>Date: Fri, 20 Jan 2006 06:20:03 -0800
>Lines: 13
>Message-ID: <801EF9EE-69E9-4B04-902C-E7BC6C98D***@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
>    charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:418324
>X-Tomcat-NG: microsoft.public.sqlserver.server
>
>In Microsoft SQL Server Management Studio 2005 whenever I open a table I
get
>the error
>------------------------------
>
>Class does not support aggregation (or class object is remote) (Exception
>from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION))
>(Microsoft.SqlServer.SqlTools.VSIntegration)
>
>I previously had SQL Server 2000 installed, but the upgrade worked
>successfully.
>Could someone please advise?
>Many thanks
>Richard.
>

"Peter Yang [MSFT]" wrote:

> Hello Richard,
>
> This is a COM interop related issue:
>
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/com/html/3b
> 414b95-e8d2-42e8-b4f2-5cc5189a3d08.asp
>
> You may want to remove Workstation componenents, then do a repair on Net
> Framework 2.0 then Re-Install workstation components to test:
>
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=178936&SiteID=1
>
> If the issue persists, please make sure you have removed all SQL 2000
> components including SQL client tool to test the situation again.
>
> Regards,
>
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> =====================================================
>
>
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> --------------------
> >Thread-Topic: Class does not support aggregation
> >thread-index: AcYdzJqnv7Gvd6SmT+qRbL0nvajMoA==
> >X-WBNR-Posting-Host: 194.131.103.210
> >From: "=?Utf-8?B?UmljaA==?=" <richvista@nospam.nospam>
> >Subject: Class does not support aggregation
> >Date: Fri, 20 Jan 2006 06:20:03 -0800
> >Lines: 13
> >Message-ID: <801EF9EE-69E9-4B04-902C-E7BC6C98D***@microsoft.com>
> >MIME-Version: 1.0
> >Content-Type: text/plain;
> >    charset="Utf-8"
> >Content-Transfer-Encoding: 7bit
> >X-Newsreader: Microsoft CDO for Windows 2000
> >Content-Class: urn:content-classes:message
> >Importance: normal
> >Priority: normal
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> >Newsgroups: microsoft.public.sqlserver.server
> >NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> >Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA03.phx.gbl
> >Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.server:418324
> >X-Tomcat-NG: microsoft.public.sqlserver.server
> >
> >In Microsoft SQL Server Management Studio 2005 whenever I open a table I
> get
> >the error
> >------------------------------
> >
> >Class does not support aggregation (or class object is remote) (Exception
> >from HRESULT: 0x80040110 (CLASS_E_NOAGGREGATION))
> >(Microsoft.SqlServer.SqlTools.VSIntegration)
> >
> >I previously had SQL Server 2000 installed, but the upgrade worked
> >successfully.
> >Could someone please advise?
> >Many thanks
> >Richard.
> >
>
>