# MSSQLExecute SQL Fails with Unicode Scripts

**URL:** https://www.finalbuilder.com/forums/t/mssqlexecute-sql-fails-with-unicode-scripts/2821
**Category:** Bugs
**Created:** [May 1, 2007, 5:32am UTC](https://www.finalbuilder.com/forums/t/mssqlexecute-sql-fails-with-unicode-scripts/2821 "2007-05-01T05:32:06Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![jodywinfield](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/j/8491ac/32.png) [@jodywinfield](https://www.finalbuilder.com/forums/u/jodywinfield)
#### Post date: [May 1, 2007, 5:32am UTC](https://www.finalbuilder.com/forums/t/mssqlexecute-sql-fails-with-unicode-scripts/2821/1 "2007-05-01T05:32:06Z")

</div>

When a SQL script is created with a file format of Unicode the script fails&nbsp;with an error

Msg 156, Level 15, State 1, Server NYCINTSQL01, Procedure fnParseField, Line 29  
Incorrect syntax near the keyword 'SET'.  
1\> 2\>   
Execute failed, return code: 1

SQL2005 only creates files in Unicode format

&nbsp;

&nbsp;

---

<div class="post-metadata">

### Author: ![paulsamways](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/p/e8c25b/32.png) [@paulsamways](https://www.finalbuilder.com/forums/u/paulsamways)
#### Post date: [May 2, 2007, 1:59am UTC](https://www.finalbuilder.com/forums/t/mssqlexecute-sql-fails-with-unicode-scripts/2821/2 "2007-05-02T01:59:26Z")

</div>

Hi Jody,  
  
I was not able to reproduce the problem here when executing a Unicode encoded script against a SQL 2005 database, using the SqlCmd tool.  
  
Which version of SQL Server are you executing the SQL Script on, and which SQL Server Tool are you using? (ISQL, OSQL or SqlCmd).  
  
Regards,  
Paul.

---

<div class="post-metadata">

### Author: ![jodywinfield](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/j/8491ac/32.png) [@jodywinfield](https://www.finalbuilder.com/forums/u/jodywinfield)
#### Post date: [May 7, 2007, 8:41am UTC](https://www.finalbuilder.com/forums/t/mssqlexecute-sql-fails-with-unicode-scripts/2821/3 "2007-05-07T08:41:50Z")

</div>

Paul,

This error occurs with when running a script against a SQL2000 database using the ISQL Server Tool.

Jody

&nbsp;

---

<div class="post-metadata">

### Author: ![angus](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/a/b3f665/32.png) [@angus](https://www.finalbuilder.com/forums/u/angus)
#### Post date: [May 8, 2007, 2:38am UTC](https://www.finalbuilder.com/forums/t/mssqlexecute-sql-fails-with-unicode-scripts/2821/4 "2007-05-08T02:38:34Z")

</div>

Hi Jody,  
  
The ISQL tool does not support Unicode input files. Either OSql or SqlCmd should work without a problem.  
  
Regards,  
  
Angus