Password in SQL

Hi,
Is there a way I can store password in SQL table as
encrypted using SQL table defintion instead of writing code
to do encrypt and decrypt?
Thanks.
Hi
Not with SQL Server 2000. SQL Server 2005 supports this.
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/
"dbc user" <anonymous@.discussions.microsoft.com> wrote in message
news:07b101c5191b$0ee24b50$a601280a@.phx.gbl...
> Hi,
> Is there a way I can store password in SQL table as
> encrypted using SQL table defintion instead of writing code
> to do encrypt and decrypt?
> Thanks.
|||Ok. Thanks
>--Original Message--
>Hi
>Not with SQL Server 2000. SQL Server 2005 supports this.
>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/
>"dbc user" <anonymous@.discussions.microsoft.com> wrote in
message
>news:07b101c5191b$0ee24b50$a601280a@.phx.gbl...
>
>.
>