View Single Post
  #1 (permalink)  
Old January 12th, 2006, 09:01 AM
ocliff ocliff is offline
Registered User
 
Join Date: Jan 2006
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Database options changed on Audit Login

I have set concat_null_yields_null to off on my database. When I connect from Access XP, VB6 with DAO or ADO or other that use OLE or ODBC I can see in the profiler that they set concat_null_yields_null to on:

-- network protocol: Named Pipes
set quoted_identifier on
set implicit_transactions off
set cursor_close_on_commit off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set language us_english
set dateformat mdy
set datefirst 7

Can I configure SQL Server to ignore turning the setting back on again, or is it not an SQL Server issue?

Best regards,
ocliff

Reply With Quote