We have received some feedback regarding the “SQL Server 2005 Encryption – Encryption and data length limitations” article, but unfortunately the owner of this blog is no longer a member of our team and we really don’t have access to it in order to answer to your feedback properly.
I would like to invite anyone who would like to contact us to give us feedback or ask any question regarding this article to use this page instead of the original article.
Thanks a lot,
Corrected formula (there was a missing parenthesis):
@CipherLen = FLOOR(((8 + @PTLen + (@UsesAuth * @HASHLEN))/ @BLOCK) + 1 ) * @BLOCK + 16 + @BLOCK + 4