AnsiNulls and QuatedIdentifiers default values
-
Hi, Not sure it is the right forum... I'm using VisualStudio 2010 and trying to use schema compare tool to deploy changes from my db project to my database (SQL server 2008). when trying to deploy the changes I made in my db project I get anexception with the following message: "Cannot create index. Object 'v_TQ_IFCR_DATA_COVERAGE' was created with the following SET options off: 'ANSI_NULLS, QUOTED_IDENTIFIER'." If I will go the the index properties,I see that AnsiNulls and QuatedIdentifiers are set to project default. When changing those settings to ON I manage to deploy all updates without any exception. How can I change project default settings? I have more then 200 different objects(tables,stored procedures,functions,indexes etc.) and I don't want to change the settings of each object. Anyone? Thanks, Eli
-
Hi, Not sure it is the right forum... I'm using VisualStudio 2010 and trying to use schema compare tool to deploy changes from my db project to my database (SQL server 2008). when trying to deploy the changes I made in my db project I get anexception with the following message: "Cannot create index. Object 'v_TQ_IFCR_DATA_COVERAGE' was created with the following SET options off: 'ANSI_NULLS, QUOTED_IDENTIFIER'." If I will go the the index properties,I see that AnsiNulls and QuatedIdentifiers are set to project default. When changing those settings to ON I manage to deploy all updates without any exception. How can I change project default settings? I have more then 200 different objects(tables,stored procedures,functions,indexes etc.) and I don't want to change the settings of each object. Anyone? Thanks, Eli
problem solved. In my schema compare the options if "Ignore AnsiNulls" and "Ignore QuatedIdentifiers" where checked,so updated AnsiNulls and QuatedIdentifiers settings was not marked as needs to be updated during the schema compare. Also,I've set AnsiNulls and QuatedIdentifiers default settings to true in database.sqlsettings file.