QuotedIdentifiers and AnsiNulls on Tables - Version 7

• Ben Fidge

  SSC Eights!

  Points: 832

  More actions

  March 26, 2004 at 6:24 am

  #107808

  When calling OBJECTPROPERTY with IsAnsilNullsOn and IsQuotedIdentOn against version 7 tables in a select statement, I get nulls returned.

  Does this mean these values aren't applicable to version 7 tables fullstop, or are not configurable (can be switched on/off) like in version 2000?

  If the former, does this mean that both options are always set to "on" in all version 7 tables?

   

  Ben

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 26, 2004 at 12:49 pm

  #500727

  Works like 2000 and I know by default IsQuotedIdentOn is off.