Posted by Erland Sommarskog on 06/11/07 22:17

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/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: MSSQL - DTS Package - Find distinct rows - Output to TXT file - ActiveX
• Prev in forum: Re: Establishing Precedence In ORDERBY Condition Causing Problems.
• Thread view: Re: database security

[Reply to this message]