http://blogs.msdn.com/lcris/archive/2008/01/31/sql-server-2005-how-to-debug-errors-in-code-that-does-encryption.aspxEncryption builtin functions in SQL Server have no known issues and, if used properly, they will produce the expected results. However, if they are used incorrectly, it can be hard to figure out what exactly is the problem, so in this post I am goingen-USCommunityServer 2.1 SP1 (Build: 61025.2)