Column Encryption/Decryption in SQL 2000

Hello,
I m using MS SQL 2000 server. I want to encrypt a password column of
my table and retrieve it later by decrypting the same. How can I do so in sq
l
2000 without using any third party tool?
Thanks,
RbanBphYou can't (unless you write your own - technically that would be a 1st
party tool wouldn't it? :P).
*mike hodgson*
http://sqlnerd.blogspot.com
RbanBph wrote:

>Hello,
> I m using MS SQL 2000 server. I want to encrypt a password column o
f
>my table and retrieve it later by decrypting the same. How can I do so in s
ql
>2000 without using any third party tool?
>Thanks,
>RbanBph
>
>|||You can encrypt password column using Extended procedures.
You can search BOL and below URL.
http://www.codeproject.com/database/xp_md5.asp
Hong.
"RbanBph"?? ??? ??:

> Hello,
> I m using MS SQL 2000 server. I want to encrypt a password column
of
> my table and retrieve it later by decrypting the same. How can I do so in
sql
> 2000 without using any third party tool?
> Thanks,
> RbanBph
>