title: Stored procedure doesn't show code in database
body: <p>I am having a weird problem. I have created a stored procedure and executed it successfully. </p>
  
  <p>But when I try to look for it in the database, it doesn't show the code inside the procedure. I mean if I right click and say modify to see my procedure's code, it shows only following code :</p>
  
  <pre><code>set ANSI_NULLS ON
  set QUOTED_IDENTIFIER ON
  go
  
  ALTER PROCEDURE Proc_Name
  </code></pre>
  
  <p>Why its not showing the complete code? I deleted the procedure from database and again executed then it says "There is already an object named 'Proc_Name'in the database." and it shows the same code.</p>