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

Clarification of suitability

We ship an application for use in hotels. Some are big and will us
SQL Server 2005, some aren't so big and will use SQL Server Express
For the bigger sites it is fine for the users to select reports fro
the server
But for all sites we would like to present a list of reports an
descriptions from our application for the user to select and ru
(generally printing direct to a printer, but sometimes to a previe
or export). Also, we want the user to be able to add his own report
to this list without us having to write any database access code
etc
Also, some of these reports need to be run directly by our applicatio
(nearly always direct to the printer)
My question is whether all this can be achieved with RS and th
versions of SQL Server outlined above
Apologies if this has been covered elsewhere but I haven't found it s
farLast time I looked, RS was not available with SQL Server Express or SQL
Workgroup, only Enterprise and Standard
--
Mary Bray [SQL Server MVP]
Please reply only to newsgroups
"SimonP" <simon@.mentat.co-dot-uk.no-spam.invalid> wrote in message
news:pr2dnf298v9c4BDfRVn_vg@.giganews.com...
> We ship an application for use in hotels. Some are big and will use
> SQL Server 2005, some aren't so big and will use SQL Server Express.
> For the bigger sites it is fine for the users to select reports from
> the server.
> But for all sites we would like to present a list of reports and
> descriptions from our application for the user to select and run
> (generally printing direct to a printer, but sometimes to a preview
> or export). Also, we want the user to be able to add his own reports
> to this list without us having to write any database access code,
> etc.
> Also, some of these reports need to be run directly by our application
> (nearly always direct to the printer).
> My question is whether all this can be achieved with RS and the
> versions of SQL Server outlined above.
> Apologies if this has been covered elsewhere but I haven't found it so
> far!
>

Chosing the best Data Access component for SQL Server Express

Hi all,

I have to chose the best Data Access Component with SQL Server Express edition.

The application that I am going to develope is a simple one but the speed should be as much as possible.

Any help would be highly appreciated.

Thanks & regards

Arun Gupta

The 'best' speed would most likely be attained using the SQL native client and a datareader object.

choose from SQLDMO /SMO

in my classic ASP 3.0 application I would like to back up and restore SQL Express database. Should I use SQLDMO or SMO? Whats the difference?In classic ASP you'll have to stay with DMO, but remember that using DMO you won't be able to manage any of the new SQL Server 2005 features. If you expect to do that you'll have to upgrade your code to ASP.Net 2.0 and use SMO. I'd recommend the latter as DMO will not be supported in future releases of SQL Server.|||Thanks for your answer.I am using SQLDMO for backing up and restoring Sql Express database. While Restoring if i have any users connected to db ,restore fails.. Whats the solution for the problem? Do i need to Stop SQL Server ,restore and start again?|||You don't need to stop the server, just kill any connection to the database you're attempting to restore.|||

Allen,

I am using SQLDMO in my C# application for backing up and restoring MSDE
2000 database. Backup operations run fine, but Restoring fails. I've tried to KILL all the connections from the application but get the "cannot use KILL to kill your own process" error. Any ideas to solve this problem?
Thank you in advance for your help.
JC

|||Why I cannot use SMO in VBScript? Is there any limitation? I tried to use SMO in VBScript to connect to SQLExpress and got error :Object not found/object required. Is that the reason?|||VBScript uses COM for its object support and SMO uses the .Net Framework. The only server you can use VBScript to communicate with SMO is the default local instance of SQL Server, and SQL Express usually installs itself in a named instance called SQLExpress.|||Hello Everyone

i have one question please answer if you know, what is my requirement is if i supply the SQL server name i want all the available instances in that sql server for that i m writing code in C#

way no:
1).
ManagedComputer mc = new ManagedComputer(SystemName);
foreach (ServerInstance si in mc.ServerInstances)
{
lstInstanceNames.Items.Add(si.Name);
}

2).
DataTable dtSQLServers = SmoApplication.EnumAvailableSqlServers(servername);
foreach (DataRow drServer in dtSQLServers.Rows)
{
InstanceName = drServer["Instance"].ToString();
}

none of these are working please help me solve this problem

CheckSAPwdPolicy Return=''28001''

I need help for the following problem:

We use SQL Server 2005 Express. With a Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790) we get the following installation problem.

In the log-file SQLSetup0005_M067RT1107P1_SQL.log we get these lines:

...

Failed to validate sa password error 2704
<EndFunc Name='CheckSAPwdPolicy' Return='28001' GetLastError='0'>
Error Code: 0x80076d61 (28001)
Windows Error Text: Source File Name: sqlca\sqlcax.cpp
Compiler Timestamp: Fri Feb 9 22:35:05 2007
Function Name: SAPasswordPolicyCheck
Source Line Number: 2727
...

I try it on other PC a Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790) - Installation.

Here I got no problems!

What is the reason?

Thank you!

Seems that the first computer has a password policy enabled in Windows which is applied to the sa account (and all appropiate SQL accounts on the server). Either a Local Security Policy or a domain policy is applied to the server which sets the password complexity on the server. If your password is not conform to the complexity rules, the creation of the user will fail. (use the MMC snapin for configuration)

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Thank you very much for your help!

The problem is the local security policy!

checking for range

hey all,
what's the best way to express this in a query?
for each employee
take the salary and determine which range the particular salary falls in.
for instance:
40k
falls between 35-40k so the category is 1
number of categories are 1-12
thanks,
rodcharSELECT Employee,
CASE
WHEN Salary BETWEEN 35000 AND 40000 THEN 1
WHEN Salary BETWEEN 40001 AND 45000 THEN 2
.
.
.
END AS "Category"
FROM [Your Table]
Or, you could have a table that stores that salary categories, and JOIN to i
t
SELECT e.Employee, c.Category
FROM [Your Table] e INNER JOIN [Salary Categories] c
ON e.Salary BETWEEN c.StartingSalary and c.EndingSalary
"rodchar" wrote:

> hey all,
> what's the best way to express this in a query?
> for each employee
> take the salary and determine which range the particular salary falls in.
> for instance:
> 40k
> falls between 35-40k so the category is 1
> number of categories are 1-12
> thanks,
> rodchar|||select case when salary < 40 and salary > 35 then 1
when salary >= 40 and salary < x then 2
when salary >= x and salary < y then 3
..
when salary > z then 12
end as 'category'|||Besides the CASE examples posted, consider a table of categories with
their ranges, and JOIN to it with the range test:
FROM Employees JOIN Ranges
ON Employees.salary >= Ranges.RangeMin
AND Employees.salary < Ranges.RangeMax
Roy
On Thu, 18 May 2006 14:35:01 -0700, rodchar
<rodchar@.discussions.microsoft.com> wrote:

>hey all,
>what's the best way to express this in a query?
>for each employee
>take the salary and determine which range the particular salary falls in.
>for instance:
>40k
>falls between 35-40k so the category is 1
>number of categories are 1-12
>thanks,
>rodchar|||thanks everyone for the help. i appreciate it a lot.
"rodchar" wrote:

> hey all,
> what's the best way to express this in a query?
> for each employee
> take the salary and determine which range the particular salary falls in.
> for instance:
> 40k
> falls between 35-40k so the category is 1
> number of categories are 1-12
> thanks,
> rodchar|||nice clean solution!! thanks.

Check space left

Hi,

I understand that the Express Edition can create databases up to a size of 4GB. Is there a way to check the space left for a particular database via C++?

Thanks in advance.

Regards

Melvin

You should be able to find some usefull commands in SMO, which you can call from C++. Start with the Size property and you'll find additional size related properties shown in the sample code.

Mike

|||

hi,

i think u facing the problem regarding the property that is one property size property i am not exp in that so please check it up with that

Check space left

Hi,

I understand that the Express Edition can create databases up to a size of 4GB. Is there a way to check the space left for a particular database via C++?

Thanks in advance.

Regards

Melvin

You should be able to find some usefull commands in SMO, which you can call from C++. Start with the Size property and you'll find additional size related properties shown in the sample code.

Mike

|||

hi,

i think u facing the problem regarding the property that is one property size property i am not exp in that so please check it up with that