Visual studio build error 2015 using microsoft azure sql

Question

Hi  once i am tired to build my project .I am getting build error in the below code. CREATE PROCEDURE [dlm].[uspScriptTableInsertionForADW] ( ----- - - ----- some code------- CREATE TABLE #selectColListTable WITH ( DISTRIBUTION = ROUND_ROBIN ) Error: SQL80001:Incorrect syntax near 'WITH' .Excepting '(' or AS.

Nilesh Jadav · Answer

hey there! Yes it might be the case for the new IDE you can do one thing here go to the Project Properties tab in VS Project Setting -- > Target Platform choose suitable SQL server there - SQL Server 2005 and Press OK. Then close the IDE and restart it. Might that error will not come it is the filthy TSQL that is hindering the IDE. TSQL is having a whole different line of code for query that's why such problem occurs. I would suggest to use external SQL Server rather than to use internal one. Hope that might help you !