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,
TomTJT 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.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
> --
>

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,
TomTJT 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.googlegroups.com...
> TJT wrote:
to[vbcol=seagreen]
>
> 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
> --
>

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

Encrypted data

Hi,
How can I save encryped data in SQL2000? Also, how can I retrieve it?xp_crypt (http://www.activecrypt.com/xp_crypt_364d.zip)|||I have written my own encryption algo in all our in-house applications
and it is running great guns...
I handled both encryption and decrytion at app level,i.e both encrypt()
and decrypt() are defined in applications
just try writing ur own encrypt function or use std algo like
blowfish etc...