MS SQL Encryption

dman

Perch
Hello,

Here's another question about MS SQL that I could use help with. I'm a bit green when it comes to MS SQL so any help is appreciated.

I would like to encrypt data in MS SQL. My Jodo account is using MSSQL9 which is 2000. I'm running MS SQL Developer Editions 2005.

What is the best way to encrypt the data? Some may need full text searches. I think MS SQL 2000 and 2005 provide encryption with in the server. IS this implemented or possible at Jodohost or other hosting companies?

Is it better to use a programmatic encryption method like MD5 to encrypt and decrypt? What is the most secure way to encrypt data in MS SQL while not killing the performance?

Thanks!
 
Back
Top