Michael Coles: Sergeant SQL : asymmetric keys, c#, security, certificateshttp://sqlblog.com/blogs/michael_coles/archive/tags/asymmetric+keys/c_2300_/security/certificates/default.aspxTags: asymmetric keys, c#, security, certificatesenCommunityServer 2.1 SP2 (Build: 61129.1)Encrypt it in .NET/Decrypt it on SQL Server?http://sqlblog.com/blogs/michael_coles/archive/2010/01/29/encrypt-it-in-net-decrypt-it-on-sql-server.aspxFri, 29 Jan 2010 16:52:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:21600Mike C4http://sqlblog.com/blogs/michael_coles/comments/21600.aspxhttp://sqlblog.com/blogs/michael_coles/commentrss.aspx?PostID=21600http://sqlblog.com/blogs/michael_coles/rsscomments.aspx?PostID=21600A common question on the newsgroups is "how do you encrypt data in a .NET [or other] client application and then decrypt it on SQL Server [or vice versa]?" I actually ran down my list of answers to someone who asked this in the newsgroups a few weeks...(<a href="http://sqlblog.com/blogs/michael_coles/archive/2010/01/29/encrypt-it-in-net-decrypt-it-on-sql-server.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=21600" width="1" height="1">SQLprogrammingc sharpencryptionc#SQL Servercertificatesasymmetric keyssecurityalgorithmsSQL 2008scriptsdatabasesql 2005stored procedures