InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 13:36:34 GMT20http://www.sqlservercentral.com/Forums/Topic469522-359-1.aspxThanks Steve, I will have a read up on asymmetric keys.PhilSat, 15 Mar 2008 10:22:30 GMT2Tallhttp://www.sqlservercentral.com/Forums/Topic469522-359-1.aspxI don't believe that AES is available in XP.No one is likely to crack them. I'd use one of the shorter and quicker algorithms like RSA for the asymmetric key.Sat, 15 Mar 2008 09:19:51 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic469522-359-1.aspxBack again. I am running SQL 2005 on a XP Pro machine. Here is what I did:create master key encryption by password = 'Pufd&s@))%';create certificate cert_sk_admin with subject = 'Certificate for accessing symmetric keys - for use by admin';create certificate cert_sk_charles with subject = 'Certificate for accessing symmetric keys - for use by Charles';create symmetric key sk_users with algorithm = aes_192 encryption by certificate cert_sk_admin;The above command generates an error:Msg 15314, Level 16, State 1, Line 1Either no algorithm has been specified or the bitlength and the algorithm specified for the key are not available in this installation of Windows.Any Ideas?Thanks,Phil.Sat, 15 Mar 2008 07:09:48 GMT2Tallhttp://www.sqlservercentral.com/Forums/Topic469522-359-1.aspxThanks I will have a read.PhilFri, 14 Mar 2008 13:38:16 GMT2Tallhttp://www.sqlservercentral.com/Forums/Topic469522-359-1.aspxCheck out Encryption:Columns in SQL Server BOLDABFri, 14 Mar 2008 10:39:11 GMTScalability Doughttp://www.sqlservercentral.com/Forums/Topic469522-359-1.aspxI am attempting to create a backend database that is to accessed by a front end web site. I have created a single table in my sql db 'dbo.Users'. One of the fields contains the users password. Currently it is stored in plain text. In access I know how to mask this but how is it achieved in SQL?Many Thanks,Phil.Fri, 14 Mar 2008 10:17:25 GMT2Tall