Home Forums Programming SMO/RMO/DMO Running .sql file using C# .Net - Accents Problem RE: Running .sql file using C# .Net - Accents Problem

  • 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.