Data Hiding in SQL Server

I don't want other users to view data from query analyzer and enterprise manager without proper password
If the proper password is not there, anyone cannot connect to the database and then won't be able to use the query analyzer or any tool and look data.

What else are you looking for?

You could also encrypt the data on insertion into the Database. I do that for example if Im storing access credentials for a user account on a website. I always make sure I encrypt the users credentials on the record. I have a few routines setup that I reuse to encrypt values passed to the database and decrypt when they come back automatically.

The basic thing is to protect the data with both user identification and roles. With users you give a person or a group an access to a database, see: http://msdn.microsoft.com/en-us/library/ms173463.aspx[^].

When the user has an access to the database you use roles to handle the privileges, what can be seen or done, see: http://msdn.microsoft.com/en-us/library/ms187936.aspx[^].

When you have secured the data with both of these mechanisms, a user cannot see the data he/she doesn't have the privilege to see, no matter what the tool is.