title: What is a stored procedure with a padlock icon in SQL Server 2005?
body: <p>I see some stored procedures in one database I'm managing that have the regular stored procedure icon, but with a little padlock next to them.<br>
  The differences I see is that I can't "modify" them, and if I try to script them, it says:</p>
  
  <blockquote>
    <p>Text is Encrypted.</p>
  </blockquote>
  
  <p>Is this because these are CLR stored procedures?<br>
  Are they "regular" procedures, but encrypted/protected somehow?<br>
  Is there any way to get to the code of those (either the T-SQL or the IL)?</p>