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.
| Author |
Topic |
|
alina_costin
Starting Member
8 Posts |
 Posted - 2003-11-11 : 01:59:04
|
| Hi !My problem is that when i'm trying to update a table it gives me an error UPDATE failed because the following SET options have incorrect settings:'QUOTED_IDENTIFIER'.SET QUOTED_IDENTIFIER is ON.THanks !Alina Costin |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-11-11 : 02:26:19
|
Can you post the update statement?Owais
Where there's a will, I want to be in it. |
 |
|
|
alina_costin
Starting Member
8 Posts |
Posted - 2003-11-13 : 03:26:28
|
| Thank you .My problem is solved.The problem was that i had an indexed view on that table.So I found out that before creating an index on a view the following properties must be set on:ANSI_NULLANSI_PADDINGANSI_WARNINGSARITHABORTCONCAT_NULL_YIELDS_NULLQUATED_IDENTIFIERSThat was the problem : altought SET QUATED_IDENTIFIERS was ON, the others were not.Thanks!Alina Costin |
|
|
|
|
|
|
QUOTED_IDENTIFIER