Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Error when using for xml auto in SELECT

Author  Topic  Haseet Starting Member 6 Posts Posted - 2009-08-17 : 00:54:50 Hello everyone, I am getting this error when i use for xml auto in my select statement: SELECT 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. I executed these statements: SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO but i still get the same error. What could be the problem? Thanks in advance,