encrypting data in SQL table?

Is there any way to encrypt sensitive information in a table? I'd like to
save sensitive data in an encrypted form and then later retrieve it and
decrypt it.
Is this at all possible?
Thanks in advance,
Tom
TJT wrote:
> Is there any way to encrypt sensitive information in a table? I'd like to
> save sensitive data in an encrypted form and then later retrieve it and
> decrypt it.
> Is this at all possible?
> Thanks in advance,
> Tom
http://msdn2.microsoft.com/en-us/library/ms174361(sql.90).aspx
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
|||Thanks David.
I omitted an important fact - I am dealing with SQL2000 (not 2005). It
looks like that function is new for SQL 2005. Is there anything I could do
for sql2000?
Thanks.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1142368825.523764.75110@.p10g2000cwp.googlegro ups.com...[vbcol=seagreen]
> TJT wrote:
to
>
> http://msdn2.microsoft.com/en-us/library/ms174361(sql.90).aspx
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>