ANSI NULLS- QUOTED IDENTIFIER ON

Question

ANSI NULLS- QUOTED IDENTIFIER ON

curious_sqldba

SSC-Dedicated

Points: 36494
More actions
November 8, 2010 at 12:49 pm

#142331

In my tools i took off all the ansi null options. I want to turn on ANSI NULLS- QUOTED IDENTIFIER ON at server level. I ran the below script
EXEC sys.sp_configure N'user options', N'1312'
GO
RECONFIGURE WITH OVERRIDE
GO
But surprisingly still the procs and view show as off . I have recycled the sql server and also tried closing my management studio but still the procedure shows as OFF. The goal is to have these settings ON assuming the options are turned off in the client. I want to create the mentioned below view and when i recreate it ,it should show as ON for ANSI_NULLS and QUOTED_IDENTIFIER
create view [dbo].[view_Test_ANSI]
as
select * from sys.databases
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

NJ-DBA SSChampion Points: 13834 More actions · Answer 1

Why not set these options at the database level using ALTER DATABASE <dbname> set ANSI_NULL_DEFAULT ON, QUOTED_IDENTIFIER ON; or using the SSMS(database properties > options)?

@SQLFRNDZ SSCrazy Eights Points: 9095 More actions · Answer 2

Follow these steps.

goto tools--> options--> set defaults.

[font="Tahoma"]
--SQLFRNDZ[/url]
[/font]

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 3

thanks..after doing enough testing...watever settings are there in client while deploying the code is what the code takes with irrespective of the settings on the server and database..client settings always wins in this case !!!