How to enrypt password in a table?

Hi,
I use SQL 2K and have a table "tblPassword" which stores all the username
and passwords for front end login validation. I want to encrypt these table
so only "sa" can read. How can I accomplish this ?
Thanks
kaiHi
Not in SQL Server 2000. Get an application to do it and look at it though
the application.
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/
"kai" <kailiang@.earthlink.net> wrote in message
news:J_PHe.1993$ns.1635@.newsread1.news.atl.earthlink.net...
> Hi,
> I use SQL 2K and have a table "tblPassword" which stores all the username
> and passwords for front end login validation. I want to encrypt these
> table so only "sa" can read. How can I accomplish this ?
> Thanks
> kai
>|||Hi,
Have a look into the below URL.
http://www.activecrypt.com/help/xpc...tep_by_step.htm
Thanks
Hari
SQL Server MVP
"kai" <kailiang@.earthlink.net> wrote in message
news:J_PHe.1993$ns.1635@.newsread1.news.atl.earthlink.net...
> Hi,
> I use SQL 2K and have a table "tblPassword" which stores all the username
> and passwords for front end login validation. I want to encrypt these
> table so only "sa" can read. How can I accomplish this ?
> Thanks
> kai
>|||Hi, Mike
Thanks.
Kai
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:OMAl6q5lFHA.2860@.TK2MSFTNGP15.phx.gbl...
> Hi
> Not in SQL Server 2000. Get an application to do it and look at it though
> the application.
> 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/
> "kai" <kailiang@.earthlink.net> wrote in message
> news:J_PHe.1993$ns.1635@.newsread1.news.atl.earthlink.net...
>|||Hari,
Thanks for the link. Where I can find
master..xp_sha1
Thanks
Kai
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:u74DSv5lFHA.3316@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Have a look into the below URL.
> http://www.activecrypt.com/help/xpc...tep_by_step.htm
> Thanks
> Hari
> SQL Server MVP
> "kai" <kailiang@.earthlink.net> wrote in message
> news:J_PHe.1993$ns.1635@.newsread1.news.atl.earthlink.net...
>