Geeks With Blogs
Stephen Myers Good Times with .Net
Sometimes, when executing a new SQL script via osql or SQLCmd, generated by Visual Studio's "Add New", you will get an error due to a Unicode character. This character is usually at the beginning of the file. In order to get around this, you can open the file with notepad and select file -> save as… and then when saving the file, select ANSI in the encoding box. If this doesn’t solve your problem, you can change the file extension to .bin and open it with visual studio which will present you with a binary editor with which you can remove the culprit and then change the extension back to .sql. 
Posted on Wednesday, October 1, 2008 8:56 AM | Back to top

Comments on this post: Unicode SQL Server Scripting Error

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © smyers | Powered by: