Re: security

Locking is independent of the security context so a common login won't
introduce locking issues.


--
Hope this helps.

Dan Guzman
SQL Server MVP

"vinu thomas" <vinuthomas@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:64EF111C-6EDC-4E68-9484-FE406F8AE470@xxxxxxxxxxxxxxxx
thanks mate...Well, I think we have to change from NT SQL authentication.
this might be a stupid question, if i create a sql user and if nearly 400
people connect the database using that sql user name. will there be any
locking problem.. i believe that won't case any locking problem right..

vt



.

Relevant Pages

  • Re: row vs page locking...
    ... There was a major rewrite of much of the core database engine code in SQL 7. ... SQL 7 and above do a great job of row-level locking. ...
    (microsoft.public.sqlserver.server)
  • Re: Concurrency issue - Best Practice wanted
    ... Handling Data Concurrency Using ADO.NET ... 1/ Transactions and 2/ using timestamps. ... >I have been using for learning SQL is Petkovic, SQL Server 2000, A ... >explaining locking. ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Web page not responding
    ... Thanks for the reply, although I dont think it is locking, as it can happen ... with only one active user on the system. ... Although I will try and ascertain what SQL is doing at the time of the ... > like a record locking problem during the update. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Concurrent executions of "fn_trace_gettable" function are failing.
    ... but definitely seems like a locking issue on ... Vyas, MVP (SQL Server) ... executing the query simulateously from multiple clients. ...
    (microsoft.public.sqlserver.server)
  • row vs page locking...
    ... Somewhere on these newsgroups I recall reading that SQL Server 6 and prior ... used page locking and not row level ... RDMSs like Interbase have a versioning engine so it was built from the ...
    (microsoft.public.sqlserver.server)