encrypting data in SQL table?

14 Mar 2006 8:10 PM

TJT

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

14 Mar 2006 8:40 PM

David Portas

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
--

16 Mar 2006 5:50 PM

TJT

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.

Show quoteHide quote

"David Portas" <REMOVE_BEFORE_REPLYING_dpor***@acm.org> wrote in message
news:1142368825.523764.75110@p10g2000cwp.googlegroups.com...
> 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
> --
>