Compile error in Visual Studio sql71006:only One statement is allowed per batch. A batch separator, such as ' GO ', might be required between statements.

Copy the SQL script that was written and the stored procedure script that compiles successfully inside Mssqlmanager to the VS project, with the following error message: Sql71006:only One statement is allowed per batch. A batch separator, such as ' GO ', might be required between statements. Plus GO, appear

Error 5 Sql70001:this statement is not recognized in this context.

The main idea is not to allow multiple statements inside a script.

Solution: vs Wrong Think your file is a DDL file, so it tries to compile, the solution is, right-click File---properties-----Build Action---None