i a the user of sql server 2005 on window server 2003. i want to know
that how can i prevent my database from other user logins because all
of them are sysadmin type.
and i am also looking for database concurrency control methods.

if any one know about this plz mail me answer on this mail id
mahendersingh_be (AT) yahoo (DOT) co.in

thanx in advance

On 11 juin, 13:00, Mandy <mahendersing... (AT) gmail (DOT) com> wrote:
Hi,
You can use SQL Server authentification, open MS SQL manager then
change the connection of the current server
Omar Abid

Mandy (mahendersinghbe (AT) gmail (DOT) com) writes:
In that case you would need to move the database to a different
instance where the other people can't get in. No protection from other
sysadmin on a aserver.




--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx