SET QUOTED_IDENTIFIER OFF (Allows use of Double Quotes)

SET QUOTED_IDENTIFIER ON 

example:
  use northwind
  go
  exec('select * from products where productname = ''tofu''')  --All single quotes