encryption in sql server 2005

Hi All,

Does any body know how to use encryption in sql server 2005.Is it
possible to encrypt a particular column in a table.

thanksshark (xavier.sharon@.gmail.com) writes:
> Does any body know how to use encryption in sql server 2005.Is it
> possible to encrypt a particular column in a table.

Yes, you can encrypt column data. A good place to start is this section
in Books Online:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/96c276d5-1bba-4e95-b678-10f059f1fbcf.htm

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I've done a bit of work with Asymetic keys based on an article.
I dont believe this requires a login:

http://www.sqlservercentral.com/col...cencryption.asp
HTH
rob

shark wrote:
> Hi All,
> Does any body know how to use encryption in sql server 2005.Is it
> possible to encrypt a particular column in a table.
> thanks|||I'm just curios, what is the point of encrypting the column info if a
stored proc can be run which decrypts the contents? What is the main
goal of the encryption, just for casual browsers or to do the
encryption only in the DB side and the decryption in another layer, or
is that possible?

rcamarda wrote:
> I've done a bit of work with Asymetic keys based on an article.
> I dont believe this requires a login:
> http://www.sqlservercentral.com/col...cencryption.asp
> HTH
> rob
> shark wrote:
> > Hi All,
> > Does any body know how to use encryption in sql server 2005.Is it
> > possible to encrypt a particular column in a table.
> > thanks