Database Encryption

Hello All,
Is there a built-in way that one can encrypt and decrypt data in SQL
Server tables. My client wants all data in the database encrypted so that
even the system admins doing backups cannot view the sensitive data.
Any suggestions or solutions will be greatly appreciated.
Thanks a lot,
Imran.What version of SQL Server, 2000 or 2005..?
--
HTH. Ryan
"Imran Aziz" <imran@.tb2.net> wrote in message
news:Omk%23c3gjGHA.1552@.TK2MSFTNGP03.phx.gbl...
> Hello All,
> Is there a built-in way that one can encrypt and decrypt data in SQL
> Server tables. My client wants all data in the database encrypted so that
> even the system admins doing backups cannot view the sensitive data.
> Any suggestions or solutions will be greatly appreciated.
> Thanks a lot,
> Imran.
>
>|||Hello Ryan thanks for your response. I will be using SQL Server 2005,
googling around I can see that SQL Server 2005 has this option , but I
cannot seem to see how to work with it in our install of SQL Server 2005.
In addition the current database is in SQL Server 2000 which I will
transfer to SQL Server 2005 and then would like to encrypt all existing data
in the database.
Of some info that I have found till now, it seems that one has to set the
encryption up for a database table on creation (although could not find it
in my SQL server 2005)
but will SQL Server 2005 encrypt existing data in tables ?
Thanks a lot,
Imran.
"Ryan" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:eZmEVchjGHA.1600@.TK2MSFTNGP04.phx.gbl...
> What version of SQL Server, 2000 or 2005..?
> --
> HTH. Ryan
>
> "Imran Aziz" <imran@.tb2.net> wrote in message
> news:Omk%23c3gjGHA.1552@.TK2MSFTNGP03.phx.gbl...
>> Hello All,
>> Is there a built-in way that one can encrypt and decrypt data in SQL
>> Server tables. My client wants all data in the database encrypted so that
>> even the system admins doing backups cannot view the sensitive data.
>> Any suggestions or solutions will be greatly appreciated.
>> Thanks a lot,
>> Imran.
>>
>