Hello dmbaker, the code you give me didn't solve my problem.
This is how the stored procedure looks inside the .sql file
This how the stored procedures ends up in the database when i execute the .sql file with your code or mine.
Is there a particular reason for your using the Microsoft.SqlServer.Management assemblies?
No there is no particular reason. I just googled how to execute sql files on sql server databases.
This is what my app is doing:
1. List available servers
2. After choosing a server, lists its databases
3. Choose the databases to work on, (one or many)
4. Choose the .sql files (one or many)
5. Execute every .sql file on the selected databases
But I think that you are right about an unicode conversion problem. I read about it but I can't get my head around it
Thank you for you reply.