current users

Is there a limit on how many concurrent users that can use SQL Server 2005 Express Edition?

I haven't been able to find any facts about that

Hi,

no there isn′t and there never has been. MSDE either didn′t havelimited concurrent users, the workload governor only throttled the query performance for more than 5 users.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Jens is correct, we do not limit the number of concurrent users in SQL Express. We have also removed the workload governer in SQL Express as well. Check out Euan Garden's Blog for a historical discussion on the workload governer in MSDE.

http://blogs.msdn.com/euanga/archive/2006/03/09/545576.aspx

Mike - SQL Express team

sql

Cumulative database size limit

Hello all,
I have SQL 2000 SP 3 running on a Windows 2000 server. It used to be a
Desktop edition of SQL Server which we then upgraded to the SQL 2000
i.e. the SQL Server name is of the type: abcd\efg. I am trying to
increase the size of the database but it gives me the following error:
error 1827 create/alter database failed because the resulting cumulative
database size would exceed your licensed limit of 2048 MB per database.
We have checked with the vendor and they do not have any such
restrictions. Is this a SQL Desktop edition restriction? If so, this
database has already been converted to SQL 2000. Have any ideas?
Thanks,
Raziq.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!Is it possible that SQL Server did not successfully get upgraded. You can
verify this by looking at the SQL Server errorlog. It will tell you the
exact version that you are running. If it does not say SQL Server 2000
Standard or SQL Server 2000 Enterprise Edition then it did not get upgraded
successfully.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Hi Rand thanks for your response. It is SQL 2000. The errorlog is
listing it as version 8.00.760.
Any other ideas?
Raziq.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||What is the output of select @.@.version and select serverproperty('Edition')
?
It certainly sounds like it thinks it's Personal/Desktop edition
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Raziq Shekha" <raziq_shekha@.anadarko.com> wrote in message
news:OAuC1Gy%23DHA.2512@.TK2MSFTNGP11.phx.gbl...
> Hi Rand thanks for your response. It is SQL 2000. The errorlog is
> listing it as version 8.00.760.
> Any other ideas?
> Raziq.
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||Hi Jasper,
You are right when I run the @.@.version it is coming back with the
desktop edition. But I did run the upgrade utility. Ok, what can I do
to make it the Enterprise Edition?
Raziq.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||I would probably start from scratch by detaching all my user
databases.Script all logins and jobs and save all DTS packages as structured
storage files then uninstall the existing instance and do a clean install of
Enterprise Edition. If you want to avoid any login->user SID mapping issues
afterwards you can export the logins as detailed here
http://support.microsoft.com/defaul...b;en-us;Q246133
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Raziq Shekha" <raziq_shekha@.anadarko.com> wrote in message
news:uJ%234kc7%23DHA.4060@.TK2MSFTNGP10.phx.gbl...
> Hi Jasper,
> You are right when I run the @.@.version it is coming back with the
> desktop edition. But I did run the upgrade utility. Ok, what can I do
> to make it the Enterprise Edition?
> Raziq.
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||Thanks for your help Jasper.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

Cumulative database size limit

Hello all,
I have SQL 2000 SP 3 running on a Windows 2000 server. It used to be a
Desktop edition of SQL Server which we then upgraded to the SQL 2000
i.e. the SQL Server name is of the type: abcd\efg. I am trying to
increase the size of the database but it gives me the following error:
error 1827 create/alter database failed because the resulting cumulative
database size would exceed your licensed limit of 2048 MB per database.
We have checked with the vendor and they do not have any such
restrictions. Is this a SQL Desktop edition restriction? If so, this
database has already been converted to SQL 2000. Have any ideas?
Thanks,
Raziq.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Is it possible that SQL Server did not successfully get upgraded. You can
verify this by looking at the SQL Server errorlog. It will tell you the
exact version that you are running. If it does not say SQL Server 2000
Standard or SQL Server 2000 Enterprise Edition then it did not get upgraded
successfully.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Cube Operator

When we are using more than 10 columns in cube operator it is throwing error that maxiimum limit is 10.
but it is mandatory for my project to use more than 10 columns.
So could any one tell how to do this.
If not at all possible by using cube operator how else can this be done to get the same result

The only way to do this is to generate the query with the necessary GROUP BY clauses yourself. The sheer number of combinations that you need to take care of will be huge. You could write a stored procedure or client side script that can generate a query for each combination of GROUP BY and UNION them together to get the same results. It almost seems like this is more suited for OLAP.

cube limit

Hi all,

I am new to SSAS with SQL2005SP2. Currently, I have a fact table with almost 10 million records. In this table, I have at least 27 fields which store monthly data for the past 27 months along with some other fields. At first, I plan to make those 27 fields to one field and add another field like period to capture the year and month information so I can link to my time dimension table. Of course, this makes the new table with 270 million record counts. It took forever to process the cube. If I add more dimenstions into this cube, I got an error msg saying it exceed the limits. I am trying to find out the limit but did not get anywhere. Does anyone know the max dimensions is allowed in a cube or the max intersection can be created for a cube?

wenchi

did you patrition your cube?

what exactly error message you have got?

how many dimensions (attribute hierarchies) has the cube?

|||

I think the theoretical limit is 2 billion attributes in a cube. If you could answer Vladimir's questions we might be able to help identify your issue.

cube limit

Hi all,

I am new to SSAS with SQL2005SP2. Currently, I have a fact table with almost 10 million records. In this table, I have at least 27 fields which store monthly data for the past 27 months along with some other fields. At first, I plan to make those 27 fields to one field and add another field like period to capture the year and month information so I can link to my time dimension table. Of course, this makes the new table with 270 million record counts. It took forever to process the cube. If I add more dimenstions into this cube, I got an error msg saying it exceed the limits. I am trying to find out the limit but did not get anywhere. Does anyone know the max dimensions is allowed in a cube or the max intersection can be created for a cube?

wenchi

did you patrition your cube?

what exactly error message you have got?

how many dimensions (attribute hierarchies) has the cube?

|||

I think the theoretical limit is 2 billion attributes in a cube. If you could answer Vladimir's questions we might be able to help identify your issue.