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

  • Anyone? 😉

    Ok for example one of the .sql files could be something like this

    --------------------------------------------------

    CREATE PROCEDURE my_procedure

    AS

    DECLARE @my_value varchar(100)

    SET @my_value = 'This will select everything fróm my táblé'

    UPDATE my_table SET my_column = @my_value

    --------------------------------------------------

    This "fróm my tablé" will generate the error posted earlier

    Any ideas?