Upgrade import resources does not work

I upgraded my database to work with 3.9. The resource names were not correct so I wanted to re-import the resource file.  When I do, I get the error. "Could not find stored procedure 'LanguagePackImport'."

Go to /App_Data/Install/, and look for SqlServer.StoredProcedures.sql. Search for "LanguagePackImport", and copy the stored procedure. Execute that to your SQL Server. :)

I tried that. Now I am getting this error.

INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.

wooncherk wrote:

This worked just fine. Thank you.

what happenned after you got the error message? first you get the error message, you responded by saying you had another error message then you replied by saying worked fine for you. What happenned?

still have error message after running sql file

Thanks

My issue is the english language file I can not ''import resources'' error message:
INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations

I tried running the entire SqlServer.StoredProcedures.sql file. That caused errors. I then just ran the [LanguagePackImport] function.

That corrected my issue.

did not work for me

how did you run the fonction?

OK got it. Nothing worked until I went in the database lookup the store procedures to see if LanguagePackImport was there and it was. Whatever I was trying didn't worked so I deleted the procedure and ran a query with just the LanguagePackImport portion and it reinstalled with no errors then went back to the admin of my store and tried re-importing a language and it worked perfectly !

Thanks for the info!