Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

  1. Is there is any setting from which I can control QUOTED_IDENTIFIER settings in my database project?.
  2. Is there any place within database project from where i can switch it on by default at the time of creation or altering..?
share|improve this question
4  
Please consider working on your acceptance rate by accepting previous answers to your questions. –  Thomas Stringer May 16 '12 at 12:49
add comment

1 Answer 1

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:

enter image description here

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.