Kannan AU

Kannan AU

  • NA
  • 57
  • 23.1k

How to remove the special Character in SQL File

Jan 22 2019 7:27 PM

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.

This is the error message on Pwoershall script - Microsoft.SqlServer.Management.PowerShell.SqlPowerShellSqlExecutionException: Incorrect syntax near '"'. 

Answers (5)