I had a Visual Studio 2012 Database Project along with my Visual Studio Asp.Net Project
for storing my Stored Procedures in TFS. However whenever I tried to Build my Project I kept getting Error 2 SQL70001: This statement is not recognized in this context. I had made sure that my Database Project wasn't included in the build process so why was I getting these errors. I then took a look at the properties of the Stored Procedures and noticed the following:-
The Build Action was set to Build!
So the fix was fairly easy, just change to None:-