My database has quoted Identifier Enabled set to FALSE. So why does
select * from mytable where LastName = "D'Amico" fail?
If I explicitly set quoted_Identifier OFF before executing the query. It works.
Why must I explicitly set quoted_identifier OFF to make the above query work, is there a way to permanently make LastName = "D'Amico" server wide.