1.0sqlity.nethttps://sqlity.net/enSebastian Meinehttps://sqlity.net/en/author/sebastian/rich600338<blockquote class="wp-embedded-content" data-secret="pgi0GjDytw"><a href="https://sqlity.net/en/1617/decrypting-encrypted-database-objects/">Decrypting Encrypted Database Objects</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://sqlity.net/en/1617/decrypting-encrypted-database-objects/embed/#?secret=pgi0GjDytw" width="600" height="338" title="“Decrypting Encrypted Database Objects” — sqlity.net" data-secret="pgi0GjDytw" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script> /*! This file is auto-generated */ !function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document); //# sourceURL=https://sqlity.net/wp-includes/js/wp-embed.min.js </script> Did you ever have to fix something in an encrypted stored procedure but did not have access to the original anymore? This article shows how to decrypt encrypted SQL Server object using a simple method called Known Plaintext Attack.http://sqlity.net/wp-content/uploads/2013/01/Brent-Ozars-response.jpg