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@yahoo.co.in
thanx in advance
On 11 juin, 13:00, Mandy
> 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...@yahoo.co.in
>
> thanx in advance
Hi,
You can use SQL Server authentification, open MS SQL manager then
change the connection of the current server
Omar Abid
Mandy (mahendersinghbe@gmail.com) writes:
> 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.
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@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downlo ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books .mspx