I am trying to generate a script from Visual Studio --> Publish-->Generate script. it is failing for on server with an error "Incorrect Syntax Near *=" and same is getting generated for other server. How I can find what could be wrong. is there a way to get the exact error as Data Tool windows doesn't show much details.
SQL Deployment Script generation using Visual Studio
1条答案
按热度按时间oaxa6hgo1#
JOIN syntax as
*=
or=*
was deprecated in SQL Server 2008 and is not supported in higher versionsIt is highly recommended to use ANSI JOINS instead of this unsupported, treated as a bad practice syntax. Use
LEFT JOIN
,RIGHT JOIN
,FULL JOIN
.see also SQL Server *= Operator?
If you don't get such error on some of managed servers I guess it's because there is a very old version of SQL Server installed. On newer SQL Server instances you won't be able to use such code.