Best Practices question:

Hi,
When I run BPA I get this message:
Database Name ANSI_NULLS ANSI_PADDING_ENABLED ANSI_WARNINGS ARITHABORT
CONCAT_NULL_YIELDS_NULL QUOTED_IDENTIFIERS NUMERIC_ROUNDABORT Result
[Recommended Settings] ON ON ON ON ON ON OFF -
Axapta OFF OFF OFF OFF OFF OFF OFF Failed
Even though I have turn them ON in the server properties, and in the
database properties as well
(2 total qualifying rows in repository table
[bpa_rule_tbl!DBSQLOPTIONS!1.0] )
Copy Close
begin 666 copy.gif
M1TE&.#EA$ `0`.8``/___U&#T35)8Y.BM[+"V(JN_/S]_J[$\%R,VIFLQW.A
MWH&NY:Z_U)BKQI*P[=G=XBE4JBE4K&Z<VF".Y[_+W=+>\,?2X 25,FW^G\R-(
MEOO]_IRUYV:"I=OD]Z[0__7V^Y:FNZFYST=NNJO"[Z.RQ];>[*"Y[^OO]H6G
MZZFXSIRKP;K:_]+;\62%R2=0HMGD^9_%^I>IQ#5EQ=[BZ<_9YB!!AO?X^]?
MZBI7LW.2T9RPSK[.\/GZ_-/>]?;Y_;+)\*^^U"5-G<73\I>FN_#T^_#S^&B7
MU9NOS)JNS")%CIJMRIJNREMRCZ*QQRM7L2=0I(*?V.KO^U5YP <_;\9"JX*:]
M[*.RR+K%U/#R^&Z7YW*:ZJK![^#F\8ZX\*_#[2-'DB%#B25*F")&CR%#BLW7
M[>;J\____P``````````````````````````````````````` ```````````
M````````````````````````````````````````````````` "'Y! $``&8`
M+ `````0`! ```>F@.&:"@.X2%9@.0$# PI5C.&@.P0`D@.!-' ^/9D"3!B!73)>&
M(0`K'A4#!R-;)@.X.+X,DDCQ890>3`"@.R4X(J`#!="PI5MEH_3F1F0P8?)UPE
M&P`%!2P3.!%/9@.,VP!)&5)-$'4)(0=A%-S06%% `&%D(`0%+8=@."]?4Y`!I1
M/3M>"5^/6@.!X!R] @.R2/I/C0<41)@.@.8QP#P2`0&"BPL9Q(RI@.:FC1T.!```[
`
end
begin 666 arrow.gif
M1TE&.#EA'@.`9`/<``,# P !P``!O``&1`0)\`@.)Y`@.2?! 6?!05^!0BC" JM
M"@.=\!PZQ#@.VD#0I^"@.N "P^C#PU_#1.R$Q2O%!6D%1BV&!&#$0]O#Q*"$AJS
M&AFL&1BB&!-]$QRQ'!RC'!F-&2&U(1B!&!=Y%Q9T%A^>'QAX&"2O)!EW&1^,
M'QIV&B2>)!U_'2*1(B61YZ'B:9)B.,(R%^(2F:*2F7*2J7* B-^(R-](RN8
M*RJ1*BR6+"V5+2Z4+C"9,#"8,"^4+R^3+S&8,3"5,#BJ.#.9, S:<-C6:-3FA
M.3><-SB<.#J=.CN>.T"J0#R?/#V?/4&H03^@./T*F0C^?/T&A04.B0T*@.0D*?
M0D:G1D6E14:C1D6B14FG24BD2$FD24BB2$JD2DRG3$NE2TRE3 $ZH3DZG3DRC
M3$^G3U*H4E&F45.I4U*F4E2I5%:K5E2H5%JL6EFK65NM6UJK6 EVN75ZO7EZM
M7F&O86"N8&*P8F.Q8V.P8V6R96BT:&>S9V>R9VJT:FRV;&NU: W"X<&^W;W:[
M=G>[=WF\>7J]>H# @.(S&C(W&C7^P?X6WA8J[BJ/6HYW/G;+8LK39M/___^;F
MY@.``````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M`````````````````````"'Y! $`````+ `````>`!D`0 C_``$('$BPH,&#
M!B/)*00(#YPTD"(.X='#AXU(DA 6C/0AQY$F3(PP@.F2B@.P0%!@.I@.U,BRI4N!
MD6+*G#GS)<PH:"+JW F)1(B5-B4)'4ITJ,VC2",-:G2($* ^>>S$63-&BH\3
M0%M&*G.'CILS70T?F"1HRL+"/EH *FS!<K2W1FF #A`5J-D11=&)$B10D1
M'"(X6$ @.0**[2!,K7LP8821'@.O:\45/&"Q@.L3Y0`@.;$HDLU(?Q 9"L2GSB-(
M8;A(21+$!>*#D=#XT3.'#9DJ.F?<T%'C=<(L;7CR;+'"]\8B8,R@.$:/%B1"=
M&C9@.,$XP$@.LD4[9<@.31 4&"1!0'Q\8R0(*'#]VY)"AP@..%!@.<&"!A/GJ;]
*F!D;Z]\_," `.P``
`
end
Is there some client connection that's chaging tehse settings? You could
run a profiler for some time to check.
Cheers,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.