http://blogs.technet.com/b/andrew/archive/2007/12/21/sql-server-2008-transparent-data-encryption-and-replication.aspxSQL Server 2008 will have a mechanism to encrypt the database at rest, with little overhead, and you can try this in CTP5.&#160; While it is on the instance where it was encrypted it can be accessed by any application with out modification.&#160; Howeveren-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/andrew/archive/2007/12/21/sql-server-2008-transparent-data-encryption-and-replication.aspx#2965130Thu, 06 Mar 2008 00:31:02 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:2965130mnemzow<p>Looking for stored procedure code to automate this hybrid encryption stuff so that existing applications do not need to be grossly redesigned. Also, would love if someone figured out how to trap or tigger on SELECT to check if data encrypted and decrypt it somewhat automatically so that views, joins, etc. would still work without having to rewrite.</p><div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=2965130" width="1" height="1">http://blogs.technet.com/b/andrew/archive/2007/12/21/sql-server-2008-transparent-data-encryption-and-replication.aspx#2723018Tue, 08 Jan 2008 15:03:46 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:2723018Andrew.Fryer<p>Regan</p> <p>I have silverlight on my machine (well I'd be shot if I didn't!) and I can hit the links no problem @ work &amp; @home</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=2723018" width="1" height="1">http://blogs.technet.com/b/andrew/archive/2007/12/21/sql-server-2008-transparent-data-encryption-and-replication.aspx#2717453Sun, 06 Jan 2008 23:25:09 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:2717453Regan<p>FYI - I got the following error trying to follow the link:</p> <p>Content not found &nbsp;</p> <p>We apologize for the inconvenience, but the location you are seeking cannot be found. If you are looking for a particular document, please try one of the following areas: </p> <p>If ALSO recommended a Silverlight install. After the Silverlight install, the content was there - so I don't know if it was just a strange issue, or if it the MSDN page requires Silverlight. Just as fyi</p><div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=2717453" width="1" height="1">http://blogs.technet.com/b/andrew/archive/2007/12/21/sql-server-2008-transparent-data-encryption-and-replication.aspx#2685877Fri, 28 Dec 2007 13:10:15 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:2685877Microsoft Switzerland Security Blog<p>Two interesting blogs found on Microsoft SQL Server 2008 and Encription: SQL Server 2008 Encryption Keys</p> <img src="http://blogs.technet.com/aggbug.aspx?PostID=2685877" width="1" height="1">http://blogs.technet.com/b/andrew/archive/2007/12/21/sql-server-2008-transparent-data-encryption-and-replication.aspx#2676129Mon, 24 Dec 2007 19:25:31 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:2676129Steve Lamb's Blog<p>Click here to see the Evangelist Elfs dance! - remember to turn the sound on first! Sadly Viral 's image</p> <img src="http://blogs.technet.com/aggbug.aspx?PostID=2676129" width="1" height="1">http://blogs.technet.com/b/andrew/archive/2007/12/21/sql-server-2008-transparent-data-encryption-and-replication.aspx#2667420Fri, 21 Dec 2007 20:09:25 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:2667420Geek Lectures - Things geeks should know about » Blog Archive » SQL Server 2008 Transparent Data Encryption and Replication<p>PingBack from <a rel="nofollow" target="_new" href="http://geeklectures.info/2007/12/21/sql-server-2008-transparent-data-encryption-and-replication/">http://geeklectures.info/2007/12/21/sql-server-2008-transparent-data-encryption-and-replication/</a></p> <img src="http://blogs.technet.com/aggbug.aspx?PostID=2667420" width="1" height="1">