MS SQL Encryption

Discussion in 'Database Support' started by dman, May 16, 2008.

  1. dman

    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!
  2. Stephen

    Stephen US Operations Staff Member

    Probably best to look at programatically doing it :)

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services