title: How can I fix "SQL03042: The ALL clause is not supported"?
body: <p>I have just recently added our db schema into a VSTSDB project and one of the sp's is coming up with a strange error on the line:</p>
  
  <pre><code>revoke all from StatsReports
  </code></pre>
  
  <p>Now I've taken a look at the Sql docs for the "<a href="http://msdn.microsoft.com/en-us/library/ms187719.aspx" rel="nofollow">revoke</a>" command and according to that it is valid sql. Also searching for the error number or text brings up nothing!</p>
  
  <p>Anyone have any ideas?</p>