encrypting values stored in a column? 1

[hvisionexpo]

is there a way to encrypt values in the database?

i need to store user id, password, credit card info in the database and would like to store encrypted with a key so if anyone has access to the db cannot just read it unless they know the key

thanks

 

[ptheriault]

What version of SQL Server are you on.

Please run SELECT @@Version and post the results.

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[hvisionexpo]

Thanks for quick reply.


presently am using sql 2000 but in the next month i will be moving to sql 2005. if there is something new in 2005 to helpwith this i could use those features.

here is the current version info:

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)

 

[ptheriault]

Yes, SQL 2005 has it's own encryption. With 2000 you would need a thrid party encryption tool.

Here is some info on 2005.

http://www.databasejournal.com/features/mssql/article.php/3483931

- Paul

- If at first you don't succeed, find out if the loser gets anything.