How many users for a database application?

Hi,
lately i've been faced with a dilemma of whether i should choose to have one
database user to access the database from my app and have inbuilt user
management in the app itself or if i should choose to make a database user
for every user of the application, implementing minimal user management on
the app.
Which is best to choose? what is the best practice?
reagrds,Hi,
I recommend you to have seperate users in SQL server for each application
(provide prev. based on requirement), this will allow you to
have more security.
If you have the option of using Windows Authentication to connect to sql
server then you can set
the user and password policies for each user, this enables the highest
security level.
Note:
I will not recommend you to have application level users because of security
reasons.
Thanks
Hari
MCDBA
"Kazar Kunos" <kazar@.inbox.lv> wrote in message
news:e$92kfHiEHA.704@.TK2MSFTNGP09.phx.gbl...
> Hi,
> lately i've been faced with a dilemma of whether i should choose to have
one
> database user to access the database from my app and have inbuilt user
> management in the app itself or if i should choose to make a database user
> for every user of the application, implementing minimal user management on
> the app.
> Which is best to choose? what is the best practice?
> reagrds,
>
>

How many user current "connect" to a row in table.

Hi all...
Iam a newbie and i have one question want to ask experts ... .
I am current working on one App which have some user connect to database at the same time.
And i want to know: how many user connect or use (read , update) to one row in a table?
Could it be possible to know that? If you have one solution to solve this problem , please let me know :) ...
Could it be done by Software , T-SQL or anything ...., iam happy to know.
Thanks all.

Hello,

There's actually no straightforwarffd answer as this will depend upon the transaction isolation level which will in turn determine how many transactions may read a row as well as what state the data read will be in (dirty, comitted etc). Only one transaction can ever modify a row.

Have a look at http://www.microsoft.com/technet/prodtechnol/sql/2005/cncrrncy.mspx and http://msdn2.microsoft.com/en-US/library/ms173763.aspx as well as BOL for information.

Cheers,

Rob

|||Iam using SQL server 2000 and don't have intended to update to sql server 2005, so i can't use RLV.
I ask this question because i want to notify my clients when data was changed by users.
Is there any idea for me to solve this problem? if have , please show me more details
Thanks .:)|||Couldn't you try to use a trigger to make such a mecanism ?|||I think when a user changed data on the table and trigger on that table was fired then only that user was recieved alert from Server. Do you think so ?|||A trigger is fired on a statement level. When the trigger is fire you could write a message / row in a event table which is polled by the application. In another table you could save the information that the application of User A has received the notification but the application of user B did not. Althouh the trigger is fired once you could spread the *news* anout the changed data.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Thanks for your advise.
But i think traffic network is expensive resource so if my App keep polled the table which store info about what table has changed , it'll impact my performence which i want to avoid.
do you have anothet idea?
Thanks again.|||

Can you state the underlying purpose to what you are doing? It is not a natural thing to be interested in what row a user might be "connected" to. Now if you are talking about locking it for modification, that makes it a bit more clear, and you could use some form of lock to make that happen.

The thing is, SQL works in a very set oriented architecture, so you might touch a million rows when you think you end up only looking at one (it might require a scan of all values to find just one). SQL Server does nice things with locking, and there are techniques like optimistic locking that you can use to enhance concurrency, so if you could give a bit more information we might could suggest a better way.

|||

Louis Davidson wrote:

Can you state the underlying purpose to what you are doing? It is not a natural thing to be interested in what row a user might be "connected" to. Now if you are talking about locking it for modification, that makes it a bit more clear, and you could use some form of lock to make that happen.

The thing is, SQL works in a very set oriented architecture, so you might touch a million rows when you think you end up only looking at one (it might require a scan of all values to find just one). SQL Server does nice things with locking, and there are techniques like optimistic locking that you can use to enhance concurrency, so if you could give a bit more information we might could suggest a better way.

Thanks for your post :).

My purpose at

begin is Sql server or My App will notify my client when data was

changed for any client who current connect to that row.
For example:
-user A connect and load row R1 into dataset(vb.net).
-user B also connect to that table and load row R2
- R1 and R2 has some column which has the same data
==>

when user change data on some column and finished it,a litle later,

because user B did not know data was changed and continue changed that

data...so if i sum on total column(for example)then may be the value

was double and that is what i don't expect.

Sorry about my poor English, but if you understand what i mean , please give me your advise
Thanks.

How many rows...?

I'm developing an app that will allow a user to track clicks and sales by date/time. However, I was wondering with the potential for a TON of clicks, is it feasable to track individual clicks in a SQL Server 2000 or 2005 database? I'm talking potentially 50,000 products receiving thousands of clicks per day, coud the db handle that kind of traffic? Or should I stick with a running total of clicks per product, and forget about the ability to see a breakdown of clicks per day, etc?That data is going to get out of control rather fast. However you can keep a running total by day.|||How many rows can a typical table handle? 1 million? 500 million? 1 billion? More? That will help me figure out if I can track clicks daily, or if I have to track weekly or monthly.|||The only limitation of rows per table in SQL is the storage available, see 'Maximum Capacity Specifications' topic in SQL Books Online

how many concurrent users for client/server app?

How many concurrent users will MSDE support in a client/server application?
I found 25 users for a website but I have an Access application that I wish
to connect to MSDE and wish to know how many users before having to upgrade
to the full blown version of SQL Server.
hi Ron,
Ron wrote:
> How many concurrent users will MSDE support in a client/server
> application? I found 25 users for a website but I have an Access
> application that I wish to connect to MSDE and wish to know how many
> users before having to upgrade to the full blown version of SQL
> Server.
25 concurrent users is just am estimate number, as it depend on the actual
project , the dataload, the data access type, the data access method and so
on...
you really have to test yourself for your actual solution..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

HOW I CAN SAVE AN XML IN SQL SERVER

I HAVE AN APP THAT RECEIVE FROM THE WEB A XML FILE
I NEED TO SAVE AS A TABLE IN SQL SERVER
CAN ANYBODY HELP ME ?
THANKS
GRS
Do you want to shred it into rows/columns or store it as blob?
If you want to shred it, you may use OpenXML or Dataset. If the file size is
big, consider using Bulkload which will stream the date to SQL server.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"GRS" <g_saturansky@.yahoo.com> wrote in message
news:1121727965.861690.60780@.g47g2000cwa.googlegro ups.com...
>I HAVE AN APP THAT RECEIVE FROM THE WEB A XML FILE
> I NEED TO SAVE AS A TABLE IN SQL SERVER
> CAN ANYBODY HELP ME ?
> THANKS
> GRS
>
|||

Quote:

Originally posted by GRS
I HAVE AN APP THAT RECEIVE FROM THE WEB A XML FILE
I NEED TO SAVE AS A TABLE IN SQL SERVER
CAN ANYBODY HELP ME ?
THANKS
GRS

http://www.kbalertz.com/kb_316244.aspx
That will get you started.
...