• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1373
  • Last Modified:

Changing ANSI_NULLS option on existing table

Hi,

Is it at all possible to change "set options' on existing tables, or do I have to drop and recreate with desired option set to on/off?


Thanks
0
davidlars99
Asked:
davidlars99
  • 3
  • 3
  • 2
2 Solutions
 
chapmandewCommented:
drop and recreate...
0
 
Anthony PerkinsCommented:
The SET ANSI_NULLS setting is only used at run time.
0
 
chapmandewCommented:
Yeah, but its set for objects when they're created, so it can cause some funky results if the settings aren't right when you create the object.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Anthony PerkinsCommented:
You are right.  I stand corrected.
0
 
davidlars99Author Commented:
ok thank.

how about this?
select OBJECTPROPERTY(object_id(N'mytable'), N'ExecIsAnsiNullsOn')

above doesn't work for tables. is there similar thing for tables as well?
0
 
chapmandewCommented:
you can't change it once the object has been created....you can view the property, but cant change it unless you drop and recreate it.
0
 
davidlars99Author Commented:
chapmandew, plz tell me how i can vew this property on table...
0
 
davidlars99Author Commented:
Please someone tell how I can view ANSI_NULLS settings on the existing table...
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now