Deployment Failed in the UAT due to SQL Script

Posted on by Pankaj_93

392

Hi All,

Hope all are doing well...

We are facing issue while deploying Retail Package to UAT.

Deployment has failed with the error message: 'There was an error when applying the channel database extension file '222_FUNC_LTAXREGISTRATIONNUMBER.sql'. Incorrect syntax near '�'. Must declare the scalar variable "@nvc_CutsId". Near statement: CREATE �FUNCTION�[ext].[LTAXREGISTRATIONNUMBER]--TRNNUMBER ( ��@nvc_CutsId NVARCHAR(25) ) RETURNS�[NVARCHAR] (MAX) AS� BEGIN RETURN ��(SELECT top(1)p.REGISTRATIONNUMBER FROM ... '

Could you please suggest how can we find out the special characters? Any specific tool is there...

Thanks in Advance....