Dear Team,
I am facing very big issue, please help me. I am having "FileName.sql" file , in that file when I try to deploy to server using Powershell script (that's our company deployment tool), its always saying that there is a special character inside the file, hence deployment is getting failed, it never says on which line it has special cheater , could you please help me, how to identify the special character in SQL file. When I execute this FileName.sql fiel manually in SQL server management studio without any error it will execute, but through Powershall script I am not able to deploy, so please help me , how to identify the special character inside my sql file.