title: How to decrypt stored procedure in SQL Server 2008
body: <p>I have a stored procedure which is encrypted using the WITH ENCRYPTION option. Now I want to decrypt that procedure. I have already tried a stored procedure called "Decryptsp2K" which is given for SQL 2000 in this forum: <a href="http://forums.asp.net/t/1516587.aspx/1">http://forums.asp.net/t/1516587.aspx/1</a></p>
  
  <p>But it deletes my stored procedure, rather than decrypting it.</p>
  
  <p>Is there a way to decrypt a stored procedure in SQL Server 2008?</p>