I had a strange problem last night. We updated a report stored procedure and Set the Transaction Isolation Read Uncommitted. And then when the report was run this morning
we got 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 query notifications and/or xml data type methods.
Should the isolation level affect this? I am running Sql Server 2005 And Sql Server 2008. I did test it when I first ran it in development and I did not get an error, but production doesn't seem to like it. Is there anything else that can cause this?
Any thoughts would be appreciated