SQL2k table encryption

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mecn - 29 Mar 2006 22:28 GMT

Is sql2k sp4 has internal tables encryption function?
I need to encrypt the tables in one database?

Don't know how?

ANy ideas?

Thanks

Reply to this Message

Mike Hodgson - 29 Mar 2006 22:40 GMT

There is no in-built encryption functionality with SQL 2000 (except for
the the undocumented pwdencrypt() and pwdcompare() functions but they
almost certainly won't be of any use to you). You'll need to either
acquire a 3rd party encryption package or write your own with something
like VisualStudio (you could either write extended stored procedures,
which is pretty easy with VS, to encrypt & decrypt the data or handle
the encryption on a middle tier rather than in the data layer).

--
*mike hodgson*
http://sqlnerd.blogspot.com

>Is sql2k sp4 has internal tables encryption function?
>I need to encrypt the tables in one database?
[quoted text clipped - 6 lines]
>
>

Reply to this Message

mecn - 29 Mar 2006 22:51 GMT

Mike,

Thanks a lot, It's very helpful to me.

Henry
There is no in-built encryption functionality with SQL 2000 (except for the the undocumented pwdencrypt() and pwdcompare() functions but they almost certainly won't be of any use to you). You'll need to either acquire a 3rd party encryption package or write your own with something like VisualStudio (you could either write extended stored procedures, which is pretty easy with VS, to encrypt & decrypt the data or handle the encryption on a middle tier rather than in the data layer).

--
mike hodgson
http://sqlnerd.blogspot.com

mecn wrote:
Is sql2k sp4 has internal tables encryption function?
I need to encrypt the tables in one database?

Don't know how?

ANy ideas?

Thanks

Reply to this Message

hongju - 31 Mar 2006 05:42 GMT

S2k have Encryption Function but undocumented.

select ENCRYPT('hello')
select CONVERT(nvarchar(100),ENCRYPT('hello'))

Exactly this function don't support standard Encryption.

You can support encryption using extended procedure.

MD5 Hashing example:
http://www.codeproject.com/database/xp_md5.asp

"mecn"님이 작성한 내용:

> Is sql2k sp4 has internal tables encryption function?
> I need to encrypt the tables in one database?
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message