SET QUOTED_IDENTIFIER issue I have created a Database Project in Visual Studio 2010 for a database which is in 2008.
I am having issues in deploying the database as I don't know why, but at the time of deployment in some procedures

QUOTED_IDENTIFIER is set to OFF

But I intended to switch in ON at the time of deployment.


Is there is any setting from which I can control QUOTED_IDENTIFIER settings in my database project?.
Is there any place within database project from where i can switch it on by default at the time of creation or altering..?
QUOTED_IDENTIFIER is a connect-specific setting.  You can see what sessions have it set through the sys.dm_exec_sessions DMV.

But if you are looking to set the default of the instance, you can configure this through sp_configure:

exec sys.sp_configure 'user options', 256
go
reconfigure with override
go


See this BOL reference on user options config.

To set this on the database level, you would do:

alter database YourDB
set quoted_identifier on
go


BOL reference

Within Visual Studio 2010, the option can be found under Properties -> Database.sqlsettings.  Below is a screenshot showing the option: