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/columnists/mcoles/sql2005symmetricencryption.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