sql server - when was the last time Ansi_warning was set -

sql server - when was the last time Ansi_warning was set -

in our production database there sp working fine till 2nd nov 2014 , started giving warnings warning : null value eliminated aggregate or other set operation because ansi_warning on in our production database resolve had marked set ansi_warning off in origin sp

so can tell me there way can check when lastly time or whom ansi_warning set

you can see configuration changes using t-sql

declare @stracepath varchar(1024) select @stracepath=convert(varchar(500),value) fn_trace_getinfo(default) property=2 select textdata,hostname,applicationname,databasename,loginname,spid,starttime,eventsequence fn_trace_gettable(@stracepath,1) textdata '%configure%' , spid<>@@spid order starttime desc

this of cource based on have default trace enabled on server.

sql-server