Single quote paste problem MSSQL When I'm pasting text in to my query window from Office the single quotes are being changed to a backtick. I have been through all the options in both Office and SQL but I can't find the/a setting to stop this happening. Is there such an option?
What I believe you're talking about is Microsoft Office changing single quotes to Smart Quotes.

It's an Autoformatting setting that you can change through the Options menu in Microsoft Word.

Go to Options -> Proofing -> Autocorrect Options

There are two places to change this:


Under 'Autoformat', untick Replace -> Straight Quotes with Smart Quotes
Under 'Autoformat as you type', untick Replace as you Type -> Straight Quotes with Smart Quotes


Alternatively, stop copying SQL from Microsoft Word.

https://www.simple-talk.com/blogs/2011/11/09/how-to-stop-office-2010-changing-and-to-smart-quotes/