Data Encryption In SQL2005

I am a developer and need to store some confidential information in my DB. I
came to know about SQL server 2005's encryption features recently.
I want to encrypt data in such a way that even DBA's who created the DB's
(owners) should not be able to decrpt the data.
Is it possibel in SQL server 2005 ? if so, can anyone breifly outline the
steps or point to ncessary location.
thanks. KumarHi
Have a look at Laurentiu Cristofor's blog
http://blogs.msdn.com/lcris/default.aspx
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Kumar" <Kumar@.discussions.microsoft.com> wrote in message
news:89F62EDD-1D58-4781-96CE-5FC5E6E82C8F@.microsoft.com...
>I am a developer and need to store some confidential information in my DB.
>I
> came to know about SQL server 2005's encryption features recently.
> I want to encrypt data in such a way that even DBA's who created the DB's
> (owners) should not be able to decrpt the data.
> Is it possibel in SQL server 2005 ? if so, can anyone breifly outline the
> steps or point to ncessary location.
> thanks. Kumar
>|||Mike,
Thanks. Will try it. Do I need to have any special privileges to create all
these keys ?
thanks Kumar
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Have a look at Laurentiu Cristofor's blog
> http://blogs.msdn.com/lcris/default.aspx
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Kumar" <Kumar@.discussions.microsoft.com> wrote in message
> news:89F62EDD-1D58-4781-96CE-5FC5E6E82C8F@.microsoft.com...
>
>|||Yes, you need to have been granted special permissions for creating keys.
For details, look in Books Online; the permission requirements for DDL are
listed there.
Thanks
Laurentiu Cristofor [MSFT]
Software Design Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kumar" <Kumar@.discussions.microsoft.com> wrote in message
news:4DDBF38B-32FA-4284-A273-225F1D0B79A0@.microsoft.com...[vbcol=seagreen]
> Mike,
> Thanks. Will try it. Do I need to have any special privileges to create
> all
> these keys ?
> thanks Kumar
> "Mike Epprecht (SQL MVP)" wrote:
>|||Guys, thank you very much.
"Laurentiu Cristofor [MSFT]" wrote:

> Yes, you need to have been granted special permissions for creating keys.
> For details, look in Books Online; the permission requirements for DDL are
> listed there.
> Thanks
> --
> Laurentiu Cristofor [MSFT]
> Software Design Engineer
> SQL Server Engine
> http://blogs.msdn.com/lcris/
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> "Kumar" <Kumar@.discussions.microsoft.com> wrote in message
> news:4DDBF38B-32FA-4284-A273-225F1D0B79A0@.microsoft.com...
>
>sql