Prev: Linking Table to Output of TVF is Very Slow
Next: Query Help
From: Gav on 8 Jul 2008 05:17
I need to encrypt some fields in one of my SQL 2000 databases. The fields
are decimal fields and I need to be able to decrypt them too, so a one way
hash is no good. I want to encrypt/decrypt these fields from within stored
procedures but am unsure how to go about doing it. Can anybody offer me any
advice please.

thanks

Gav


From: ML on 8 Jul 2008 05:53
In SQL 2000 you could use third party solutions for encryption, but IMHO a
much better option would be to encrypt/decrypt data in the client application
- because that's where data is entered and used, and where its protection
through encryption should already be available.

For a more accurate answer, please, elaborate on your actual business
requirements. Data encryption should only be considered to complement
existing security measures (e.g. server/database/schema/object permissions).


ML

---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/
 | 
Pages: 1
Prev: Linking Table to Output of TVF is Very Slow
Next: Query Help