title: How do you leave comments in SQL Server 2008 R2 view with SSMS?
body: <p>According to multiple sources <a href="http://technet.microsoft.com/en-us/library/ms181627.aspx" rel="noreferrer">Microsoft</a> , <a href="http://zarez.net/?p=1581" rel="noreferrer">SQL Server Administration Blog | zarez.net</a> adding comments to SQL and doing so with SSMS is a piece of cake. And for the most part they are probably right. But when I log in and create a view I have been unable to leave comments in it.  </p>
  
  <p>If I use two hyphens (--) the comments get deleted when I save the view, it does not matter if I am creating it from scratch or updating a view that I created some time ago.</p>
  
  <p>If I try the <code>Edit -&gt; Advanced -&gt; Click ‘Comment Selection’</code> the <code>Advanced</code> option is not displayed (see screen shot)</p>
  
  <p><img src="https://i.stack.imgur.com/8odFt.jpg" alt="enter image description here"></p>
  
  <p>Am I missing something or is it just impossible to leave comments in a SQL Server view?</p>