SQL Server 2005: A great post by Aaron Morton about using MARS to access opened keys

SQL Server 2005: A great post by Aaron Morton about using MARS to access opened keyshttp://blogs.msdn.com/lcris/archive/2008/01/17/sql-server-2005-a-great-post-by-aaron-morton-about-using-mars-to-access-opened-keys.aspxAaron Morton has a very interesting post and demo that show how MARS can be used to access keys temporarily opened by a procedure. This is a must-read for anyone that is interested in implementing custom restrictions around the use of encryption keys.en-USCommunityServer 2.1 SP1 (Build: 61025.2)