How can I fix "SQL03042: The ALL clause is not supported"?

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:

revoke all from 开发者_开发百科StatsReports

Now I've taken a look at the Sql docs for the "revoke" command and according to that it is valid sql. Also searching for the error number or text brings up nothing!

Anyone have any ideas?

It is valid TSQL, but the error message is - I assume - coming from VSTSDB, not from SQL Server. Running your query directly against a SQL 2008 database gives the following message:

The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

My guess is that VSTSDB shows an error on this syntax in order to 'remind' you to update your code. The deprecation is documented under the main page for the REVOKE command.