how to Allow Multiple access to data base over network

Hello All, I have a running/ woking database, but only one user can
access the data base at a time on the newtork, If more than one user
try accessing the database, it will frezee until the first to grab the
data base logs out. Please how do I solve this problem. I have sql 2000
enterprise edition running on the server.
Regards
Agboola.1default wrote:
> Hello All, I have a running/ woking database, but only one user can
> access the data base at a time on the newtork, If more than one user
> try accessing the database, it will frezee until the first to grab the
> data base logs out. Please how do I solve this problem. I have sql 2000
> enterprise edition running on the server.
> Regards
> Agboola.
>
First, check the database properties to make sure it's not in
Single-User mode. However, that doesn't sound like your problem.
What exactly freezes up? It sounds like your first user is doing
something that is blocking other users. You can confirm that by
querying the sysprocesses table in the master database, or by issuing
the command 'sp_who2' in Query Analyzer.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Looks like you have the database in restricted or single user mode. But you
should receive messages like these, instead of freezing the session:
Database 'Northwind' is already open and can only have one user at a time.
Database 'Northwind' is in restricted mode. Only the database owner and
members of the dbcreator and sysadmin roles can access it.
Try this first: Using Enterprise Manager, right-click your database,
Properties, select the Options tab and make sure the Restrict access option
is not checked.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"1default" wrote:
> Hello All, I have a running/ woking database, but only one user can
> access the data base at a time on the newtork, If more than one user
> try accessing the database, it will frezee until the first to grab the
> data base logs out. Please how do I solve this problem. I have sql 2000
> enterprise edition running on the server.
> Regards
> Agboola.
>

how to Allow Multiple access to data base over network

Hello All, I have a running/ woking database, but only one user can
access the data base at a time on the newtork, If more than one user
try accessing the database, it will frezee until the first to grab the
data base logs out. Please how do I solve this problem. I have sql 2000
enterprise edition running on the server.
Regards
Agboola.1default wrote:
> Hello All, I have a running/ woking database, but only one user can
> access the data base at a time on the newtork, If more than one user
> try accessing the database, it will frezee until the first to grab the
> data base logs out. Please how do I solve this problem. I have sql 2000
> enterprise edition running on the server.
> Regards
> Agboola.
>
First, check the database properties to make sure it's not in
Single-User mode. However, that doesn't sound like your problem.
What exactly freezes up? It sounds like your first user is doing
something that is blocking other users. You can confirm that by
querying the sysprocesses table in the master database, or by issuing
the command 'sp_who2' in Query Analyzer.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Looks like you have the database in restricted or single user mode. But you
should receive messages like these, instead of freezing the session:
Database 'Northwind' is already open and can only have one user at a time.
Database 'Northwind' is in restricted mode. Only the database owner and
members of the dbcreator and sysadmin roles can access it.
Try this first: Using Enterprise Manager, right-click your database,
Properties, select the Options tab and make sure the Restrict access option
is not checked.
Hope this helps,
Ben Nevarez, MCDBA, OCP
Database Administrator
"1default" wrote:

> Hello All, I have a running/ woking database, but only one user can
> access the data base at a time on the newtork, If more than one user
> try accessing the database, it will frezee until the first to grab the
> data base logs out. Please how do I solve this problem. I have sql 2000
> enterprise edition running on the server.
> Regards
> Agboola.
>

How to add YTD (Calculation) to Time Dimension?

Is there any you can add YTD to Time Dimension as attribute? Or it has to be Calculation? Then how do we do this? Is this need to base on Dimension or Measure? I would prefer this to be base on dimension and show in Time dimension hierarchy.

Any inputs on this are highly appreciated.

If you are using Analysis Services 2005 you can open the cube editor and then click on the "Add Business Intelligence" button you will get a wizard that will guide you through the process of adding a "Period Calculations" attribute hierarchy to your time dimension which can be used to support YTD, QTD, MTD and other period calculations.

The following is a link to an excellent article on the "Time Intelligence" wizard that was published in SQLServer magazine:

http://www.windowsitpro.com/Article/ArticleID/46157/46157.html

|||

Although you need to be aware that some of the calculations produced by the Time Intelligence Wizard, including the YTD calculation, don't actually work. See:

http://spaces.msn.com/members/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!379.entry

|||

There are several ways to accomplish this. If your users want a way to select Monthly values vs, QTD, YTD from a selector/slicer you will need to create a Time Utility Dim or a Time Ref Dim.

This Dim will only contain one member for the lowest level of detail. ie. Month or Daily. You would then create calculated members to compute YTD and anyother values that are based on what the user has selected in the Time Dim.

|||Can this be done in AS 2005?

How to add YTD (Calculation) to Time Dimension?

Is there any you can add YTD to Time Dimension as attribute? Or it has to be Calculation? Then how do we do this? Is this need to base on Dimension or Measure? I would prefer this to be base on dimension and show in Time dimension hierarchy.

Any inputs on this are highly appreciated.

If you are using Analysis Services 2005 you can open the cube editor and then click on the "Add Business Intelligence" button you will get a wizard that will guide you through the process of adding a "Period Calculations" attribute hierarchy to your time dimension which can be used to support YTD, QTD, MTD and other period calculations.

The following is a link to an excellent article on the "Time Intelligence" wizard that was published in SQLServer magazine:

http://www.windowsitpro.com/Article/ArticleID/46157/46157.html

|||

Although you need to be aware that some of the calculations produced by the Time Intelligence Wizard, including the YTD calculation, don't actually work. See:

http://spaces.msn.com/members/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!379.entry

|||

There are several ways to accomplish this. If your users want a way to select Monthly values vs, QTD, YTD from a selector/slicer you will need to create a Time Utility Dim or a Time Ref Dim.

This Dim will only contain one member for the lowest level of detail. ie. Month or Daily. You would then create calculated members to compute YTD and anyother values that are based on what the user has selected in the Time Dim.

|||Can this be done in AS 2005?