data encryption

Hello there
I have database with some details that i don't no one can read it. including
programmers who have access directly to sql server.
How can i do that ?Roy, shalom
I assume , you are using SQL Server 2000 , right?
Take a look at this article
http://vyaskn.tripod.com/ row_level...as
es.htm
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:u3IMJblMHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello there
> I have database with some details that i don't no one can read it.
> including programmers who have access directly to sql server.
> How can i do that ?
>|||what's the datatypes of that columns? if it looks like the binary datea,
then try to convert it as varchar(8000) column
SELECt cast(urVarbinaryColumn as varchar(8000) )
from urTable
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:u3IMJblMHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello there
> I have database with some details that i don't no one can read it.
> including programmers who have access directly to sql server.
> How can i do that ?
>|||"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:u3IMJblMHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello there
> I have database with some details that i don't no one can read it.
> including programmers who have access directly to sql server.
> How can i do that ?
In addition, if SQL 2005, look here:
http://www.sqlservercentral.com/col...oolkitpart1.aspsql