Tuesday, March 27, 2012
Failed to Net Send to the address '%s'
On the server locally i can open a command window, and enter
>net send TargetMachine message
and it works.
But SQL Server agent says, when i test send the message, "Failed to Net Send
to the address '%s'"
Agent is logging on with a valid domain account.Can you please post your code.
Peter
>--Original Message--
>i'm trying to setup operators on one of our SQL Server.
>On the server locally i can open a command window, and
enter
>>net send TargetMachine message
>and it works.
>But SQL Server agent says, when i test send the
message, "Failed to Net Send
>to the address '%s'"
>Agent is logging on with a valid domain account.
>
>.
>|||Start->Programs->Microsoft SQL Server->Enterprise Manager
Expand your server.
Managment->SQL Server Agent->Operators
Double click an operator
Net send address: Type in a user name or machine name
Click "Test"
"Peter the Spate" <anonymous@.discussions.microsoft.com> wrote in message
news:68cb01c4756f$b3a19fb0$a501280a@.phx.gbl...
> Can you please post your code.
> Peter
>
> >--Original Message--
> >i'm trying to setup operators on one of our SQL Server.
> >
> >On the server locally i can open a command window, and
> enter
> >>net send TargetMachine message
> >
> >and it works.
> >
> >But SQL Server agent says, when i test send the
> message, "Failed to Net Send
> >to the address '%s'"
> >
> >Agent is logging on with a valid domain account.
> >
> >
> >.
> >
Failed to install MSDE 2000a
the command prompt.
this is the command that i was using:
(setup INSTANCENAME="SA" SECURITYMODE=SQL SAPWD="SqlAdmin1"
TARGETDIR="C:\" )
but it gave me the following error message;
(Go to the control panel to install and configure system components)
now i really dont know what to do from here can you advice me?
hi Tino,
Tino wrote:
> I have been tring to install the MSDE 200Aon my marchine that is using
> the command prompt.
> this is the command that i was using:
> (setup INSTANCENAME="SA" SECURITYMODE=SQL SAPWD="SqlAdmin1"
> TARGETDIR="C:\" )
> but it gave me the following error message;
> (Go to the control panel to install and configure system components)
> now i really dont know what to do from here can you advice me?
did you navigate and posittioned your command prompt window in the folder
hosting the setup.exe boostrap installer of MSDE?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply
sql
Monday, March 19, 2012
Failed Installation Log
includes sapwd="password", so it shouldn't be encountering a blank password.
The user insists that server services are started and he is using admin
rights. The was an earlier version of msde sp3 on the machine that we
deleted manually.
I'd appreciate any words of wisdom here. Even a "I have no clue" answer
would be better than nothing.
Thanks
begin 666 MSDELog.zip
M4$L#!!0````(`" U<S"G1B5GTUX``%2!!P`+````35-$14QO9RYL;V?MO6ES
M'#F6)8HO\^$]L_D/M)X/U?6LI(Z%L3#?JQX+QI+):E)2BY2RRDQF+(ID2AR)
M2S%(9:K+JG[ZF[GG7'>Z>S 6#P_X@.G!8&(,>O@.#W'%Q<7 `7\/_]___1X+-C
MWIM+<V\^FELSE:,=\U6./LGGRMS(]XZ<?3!G<L>#7+TP/\B9MODWTS1[\MTR
M#?GLRKD=.=.0JRWYX+O-<_OF4=+Y*L_MR//?S9VD@.12.S4_FP+R1HW?FE1P-
MS6LS,F/YW3(OF>9+.>H&1TVFW66*0Y'EJWQ"Z>Y$LEMS+NE.Y?,#[_C!? # _
M2ZJO),W7<G0LOX\E]RDQ7(ML+3ES+;^OY/=O\G<NN>C1CE%>_KOYO\V1/'4@.
M9_Y5KO^>_W>)<5?R^#WS>LM\+R7=AR>)SD7"<_.9;$&^6TI[+ OGOF&^4_I%/
MI<OA*$@.-J5\N26_'_$[07DHY/HH4OY/?5Y+'CJ26+I__)_$!LD?)<4Q,FO</
M3&EG[F?VZ3<LE0M)XUR80?H7+!7(@.7)6O6F(]"@.9\/<HR'#\-\&C>3>DU%\&
MI90^YP%SO)+<;YAO^B>'\LRU?,[DR0MS^(1Z]D[]Y%%Z*+$S*<&O<N8=]>I>
MTK\):B"T?IJA9(^E#DS,B=2#@.3"+.H;O8SGSEC7O1+Y?2UU!J ;T6W#CW%SZI
MEN'*_"+21O4-B+[(]R?*_4(^_T[Y-RMAX$*:9\P)B&%Y;B7O!_,K[0]RNV...
M>:!443DG>4W'RBMYXB$HWR:_6[0X+1[A]W]CB4#[E?UC_KJ18V!1>=J\\X4\
MT92T>_*_+]\-.=\W.[F7SV:,AWIT0R:06ASM5VKH-, ,6^8&FCOJ[#5Q/ 0V
M^$$00G<>J2MG1/M "PV]Q=E9O<)SJI&/O/.65_Z+SX8ZAUKZ3?Z^B@.SIN!FR
M;3V3VA/6IDOJD];XB]3IC&FAM,3.@.O8Z*L=DFNE2?$U\:NF1XO-ZCC;QWS<N
MI732O)G)^U?Y_MV3!4":-T\,_L*6YCHFH;;_:/F'8D6/1,I_B@.0?1)K7XH^,
MY?])<.:0]PSD_W%PYL3 /P""ENE(3;Z0>KR>[ .1_@.W]F2/Y/Y 4?S#J4]W&
MROT7:A3TZTX^YT1P%VCF!?^C!,\"CPPE"MW\3BZNJ)&S;>R0Q ZK1?Q>4#?'/
M]D6NOGQWQ$*-::&:<K0KV'HBV0OYVY?[AG(T$HL%;ZLC=[1HQUIRW\#\0U)+
MJY7SD=^P[ET34]@.2?EHB/9AY#/3[BO5LEH^T\JS3]IZ(-&=L=[1D4.+0Y_/
MTJ_?ZH;M]_KY#@.3M,5FX-^>9\O8Z6!4=G%>^8%QM66BQIS%-2YOR:O\%>+3,
M;FG1;?@.J21]Y)^$E'PO?+_E):^7C[._$^+\CRU,3;[WC/9&7](JOV!:?L6[]
M5R##O,_OY+.I1%$KH_U-]3(>6!M4+[[ROH_RK25]R2O/2_\'8[]V%(7NC-ZX
M6K5%V*J"+JQ;*(E/M)\J>3B&\3$XG_0EKN0.W/F"NG5-U&%_1+WB]!Z:YA>F
M/92GX$5HK?R%WM8C.0P]RB/RJ3[/O:3R0^!1';(V/ 0MRD6B;4A;U]*U1LD>
MZ!%S0PW+J_4#OC,B^4P/](+/1+G]3OBXEKO3ZL! 4KAX8AR6XE>CO<B0K^E3
MVEJ:M_0MTWO>LYXIRDNU!*-'6B?"_D.R7B6?TW;V<V -%O>)LTFE%O.C"7O,
M\_1_\UQ7MT HCVN6QYN$7;D*2L)&BY1]A.7(A.,.Z^GV.CD.Y!BC%QA[3([D
MC(WV'\],U-O,HX[E*<&LS4U:RGA?&1XCSH5:>3F3MY['R.FC47_S\0E=6%]#
M7<*Q>A]WS_*?!BF%-B I43@.BBW1?T(N)RC&M!7@.[T_^<E<%VZQ?WMI^S=L<6
MYAO9O63MGRXH&>5P:N(C.NF]V+<BS2NY;R)V^BV?F.<K1.-)O_*YM"-&/PD_
MA_)ITV[\P#,_&K1]$VJVM@.MO`INI-DW'X!2'>J;:Z\=<P"-M,EK@.:4Q;M#4-
MQ^FG'!&XI;;<DZ-#I@.4&H1D?!#'Z15JOXKH\,MH7<!O=1+Z_&1W7>C#IYR.J
MBN<5[__)W%+OW<9RQ-KT/$6W4;TQZ@.UO2REA[N\\2,=M),=,XT+L_*WC2,+Q
MVZ]!&UG].C,(_*+0FYMN?<MSR+1TEF$>']N,?9%E#Z^\,3K_I&.!;FKOL0GC
M178XAG CJ7T(/-)/!CWDZ^#9T*/7WFDX%H(YM1W
M%W&,#"S)%X-1H>KKV"I/I5ZVQ0X;;ED9&YBW#Z/;B-RR0?.L:!5Z%K,QK7A^
MG9&!>2/V?;/'T78=L=>1O6.C,WO*C48`AJ/UR^[8Y1T-^>L$>2!F-^VH^K$9
M<G1Q+)]H_DXCIB[(1/0K''T]IS[!<X[F6J8SD;[(/XQU/C2;QS:WB7"=*.'L
M<Q1O>>=7QAU@.AB>O60+;N0X-HNO.8]$F^+].=,"QP0S G=&1"2W]*Q,?S=_A
M^0?FH^7WTH01V8]!Z_\I=7ZP$*&L.H<7Q1 ?<.S[Q Q8CY%>/,HXKD7/->7Y
M\^GG; ^,UJ^_L9QNS+G1V;UH1OYW<D^<$SPS^T14>G=&>Y5J`^/S**A%CT^V
M+?W,P 'QGU.OPE01@.?Y 5G3F(AYQHS.3JI'?`KU,1F>.@.WC\1THRBR6=5#_2
M#_C(]@.CX+F-IAF5V'>3PVUI8S\E@.V(K$K="C"6?\0T07B3H%U)^9YX7!_,@.-
MM74X\V0\PN+J67YJ7;/;^OSC@.XY3E3GN1&UX*R4UEJ.1I/I6K.F_!.W<OY@.P
MDNM KF,ER$CRP9S8KD@.S-J>4"V=.F7?#[,L1YM.&8KE/Y0X<MWBERV?VY(G]
M6 ZK5X>@.M"[H-7P33"_E&/4+DH&%EYRK&\EW5](>4Y*^Y K.3DV3UW!N7ZYV
M>=2@.+ U*,A29-'IV=RV9HMS;\@.SF%">27IOI#YEV(Y$[\NJ1&QNY0P,6X6\4
MC+\G3R.6=V1&@.48,Y-.5SVSN?<J67^Y=(BXF=YV#/2A-`F@.`ZOC\.+]I8!,Z
M!GY@.3W)6FZ M<MS'SKI&:E$.MM=(+<IG=L70MJR1>N[?I$MGDQ53=LIRLQ53
MBV1(]@.B?:VLRMN(\:$<U`BSI<]_PV@.LS&WD115_?/=."AN!JBBRP\!WY'K&>
MMVEMVVP#!W*F2[O7E19@.PB=Z?&(DU])A?$=YMA?IF68C YZ'CNS'.&^2++'
M-KG#MKI'A'V#ONTNO9,]^4;M'LIQFU%"(UID^%WYEV#UT959?FW13TBLTD_8
MPC8$6U_.8D1@.CVUO6Z1MRA]Z>;@.R)@.>M0FI@.]=&56WY#6A:LX&H028,8$7NW
M)]\303&1,[ MT,@..-17]HZ89.U!^1: KL_Q@.0W;9FX"7VY4_]'/VV%+TY<J8
M+423UJ8C9Z"C\'2!>3=U*U]6^16#KLSRVZ,V-JB=VBO5_D>;+7]3M!%MQ20X
MW^&];2+MLUVI=OD5@.ZX*Y=?D9UO++U]T52B_O:TNOWS1E5M^(UK^B?SO$^&0
MXVP].8LV8(\M1(N>0)N2ZTC?A!YXI_+E5P2Z,LL/?9\6]7-"C6QQ;*[#'E"7
M?UCY,:;_W>3?(/#0M)VO=OD5@.Z[<\AM0&]L&XQ'[!F.L`QY#=^&5H8?4-3I:
M,>2Y/=H:]>"J7GY%H"NS_"8B^T D0B\7[81ZUTWBP.AWCQ:F1VU5?)BU17]I
MWZ G5>WR*P;=Q%P%\Y;1VKW/YBR(H,/XG^Y8@.-F^[T00QFV'\D-NQ&.\EO/A
M6O.T<P;UWK-J$2O%[UEEOWS*W+.JJFBJL&?5(FXPNW5ALNPUM2C%UZ:,O:86
M23.[=C[+7E.S<Z<')KGJ^-Y\8#V%']M>4[[MW\MG/>3Y[^6S2)YU9B:S[R>U
MS-M8'<>WV7Y27@.>KKH.;[R>5W;<8FNSQ8HMR'9K%^TG-BQ!3>YM7=-AFL6'V
M(\/2RF,_*FS=G.=%@.T$#BL%M+QILDYPWB\-*GW,>46#I<T]&?[UZJIMC`S\9
M\?M_D?1&03T=TEL>\S[$)A_*\7N#]1!_-(V9ZV\,=NB$!A\3WTCN:=*R[Q)U
MY(?_T20CEI#..WGZ;9#2$3DYD*OOZ:_K+J"'K/=AWCHJW*!%:+"^M U:V6.#
M'4)?R;UX!FL&=F+V_Y6@.2UX;D/UH)]$_FK@._ND-,K\D2^A+O^5QHQ;27\2Y(
MK5D8RK2><7(4(VK/[DR^^_.M+Y%+^_/EAZX*^_.E15?,_GS+>K6:7YAV,?OS
M;>;=K[\_WV;Y`5^6_?D6>].V]N=+VYLO=G^^M%+9W9\ONT=O<W\^&[WF]?;G
MLY$C5GINNCO>9G4L3PEF;6[24L;'!=W;GV\1YFW>GV_QJ("-_?D6CXYOP_Y\
MKJ%;M3^?:WA>\?[Y.[^YAB7=_GRNH7ICEN_/YQH>K#N;OS^?:TB.C:Z"?[X_
MGVM(3LSR732JAV?>7B#;W?+8W)]O6RQ[NOWYW-#>8Y/G'EK;Q4%TW_.=L[8)
MZ;8@.<Q''R"S>&\L]3Z5>ML4.&VY9&1N8MP^CVXC<LD'SK&@.5>A9I]^=;9\2^
MZ/WY%H^JN[\_G_TYBK>\,\U.>9O-$MC.M;S=[M*.VZ^S#UP6E,D6*5SM,$W4
M^9>,I<$:B@.EGO32*`E$78\:680V-1AMAM7:'43>(L6A2+_'D+F<-NAE8+%:^
MEW,DU#$GK==5D%!WD@.HM;[*&-%/KV>8Z,2 >Q%[IJC;@.V*.=/J6T7;EVR@.A#
M/>K*W9AEZM'>(D*NPUC$O'3"EGSYZ80]":NB$Y@.G[!G=D0.Q>*><9V]1HW<9
M\=@.((O$PAXAS(V)![-@.>$>OZY+QTPI9\^>F$/0FKHA-8ZSJD#D_X?1IH[]!H
M7/*(NMTW3>(^-;J_CL9F`GF/Z'JYZ80M^?+3"7L25D4GAO+!>FC@.PAKX4THY
M>M+H-L]A1Y@.F([01OXVUGMBK:3_0<W"0ET[8DB\_G; G8?XZD1S7J8HF%"%5
MEO(O1JXB2CWJWU:GS/.6*5N)YR]552P_9,4N&<#49FNE:_2U'S2D]&C+]ME^
MX:KND-)F#TG7:Z"5R\ORVY(O/\MO3\+J> .JRUB+!DS08XSXC8BH35_FE'CU
M"/WB(;'"&\;^'!.1:B]';\".?'EZ`[8DK(I.8.<JW6]E:":T;5BK!U1 !*9T
M16&;/2&<:]$C'M-.HO>T;["[;EXZ84N^_'3"GH15T0GLU8H1-.S[,F#+-R&V
MOM&^,>PBUG5"^A[Q8C>F"?^C?J _W<NQUV!+OOQTPIZ$U=&)/:,KFH?D!1Z2
MH@.0BM8JZ'A2^U"GO@.WZCG9P02Y.6,C^=L"-?GCIA2\*JZ 2L5H=HL+/>Q&"\
M!+F$5DYU&QXRUKV?\FYXU;HJ".AUE#4OG; EWWHZT2Q%PJKHQ)[!6A7,N<#S
M:03V3E>&X_S Z)X`NG<`O&8@.&1*_KI 9L5:LHQ/K,&Y+OOQTPIZ$5=$)[!VW
M3VFQ_A]MX)":.S':N^[Q*-PE`#-V?>IVE]JM/2SL)Y>73MB2+S^=L"=A572B
M:W26!>U=AU9.W^2P'QQUC.ZB`GW7751Z;/\PAS>A3]5@.3<E+)VS)EY].V).P
M.FT'5D"VZ#6WZ0/ANT]?&?O4[Q(1>EHCMI CGH/?K&-P36KY>O[$>I;9CGQY
MMAVV)*Q2](/Z.5VF"]O6H[\$1&UZA*?4]A;/[=$^=FG[FO2I,(;7R$TG;,F7
MGT[8D[ J.H$Q-%BZ$;_[U.,1?VMK" 3PFK'SUBBP@.9C%;_(:ZD.']^>E$[;D
MRT\G[$E8YOR6SM+#KQFQQ3NEE/OT@.+1MW LTNT,\T/0A?27822#'WF6[&?0@.
M?YFRE'T14E7'!I15]L7*EZ<-<$<GPFC[JNA OO)D*?.\):I*O;>U^V9>]=Z6
M?/G5>WL2EAO15)XF%"%5MO:_"+G*]/C*+/.\9;+K\;E5WDC_P,3WYL(*I/M,
MY;0HK6S\+DZM*%["G2XV8R292G8N9M,I7CMT1=8KMG&7%C0DF 9X-+9E-L2B.
MAK0`\9WVLK+S/*7LO,Q+JSA&M,Z&*Q>S\Y%,9Q,V9E,JB@.M\Q]^A=&1TO]^L
MG"Q*+SLWBU,LBJ-WXC>I_[P),\E4LO,QFTXY+(0KANVP$:9FBY4H/3OL'/,-
M(]AS*@.M'/_.I/?,;T];WL%V8JQA&73?]"V7#,[^W+->B.I2'3&ELSIGT2G\U
MV%?R8@.-+$T]E$_N23*?<^K0Y+ZO2M5W'RN!N8,)]N?I0]Q(/;"C5:M3SLY?
MFK2+M5>ZNS?X3I9M\38AN;?$P'PBIY P/GJ1M533I;Y)_R==^L77CS^;$7OS
M>&LFGM'G-J\=\].U43<6I5Q4S1B92VKXHZ3^,#-Z&O9O;8VC%%G/DKAF>^SE
MC:$5(U<6S2Q*LB*LPG^:P^"MM-/@.?+GCIGG*D\T*Y2M1,;,B]^:2=NJ8[0WV
M<D(91',^9<^/%"=?6D:'@.4P/3[SJ,S^9`7=1P[O"\%R3S]]R!S/TH.Y8<CVC
M[R1'M%ST[DGLT*:I0MM:1M\>!GEFW_&+'7VQUQ;:F/"=S?/.A?JIK>6]^<;O
ML.U4W\+F&R4@.ZW-FL.8DFE/>"2SA);4`R+%CF'*JN^GA;63Z/K!_2@.[8_>^U
M0?306TE#ST1O+#L.SH2I?["*YT/ ?J2!:@.FF3_SAS3PVVW5]NTX5F9C%K.^-
M7,3/WP*KB3>*U(6?).95_,!#P_YP]6$G0KR:FT=Z\/?F:ZWXB:->S1'.3<U7
M]O_KPU$<]6J.L,__;V2T7IJDN%\&R)=;H0?Z`76R0HHXC87&G?73GI"AU=H 3
MZEG]:E:D/6E[C*U2^C-%C1WJB-==T.- BE@./%,4Q?"4VFVW5.GW)5JF2VNY5
M(MJV;OW*>3')X8AG57N.V!$\OJ.XOL<U;B$PNSJES;N>J5G8C _S*?#3WU.CO
M%46YR":ZI%G1;$M83LM*93T;@.O0G3/<B>#*JEYI&^![-Z(W9_Y]5A/]NGN_Z
M#^NHR'$^PKT*#=Y_^IU6"6.=228NR>#WN;DU4N2&J\CEW#Q8R &M,QK.45MK6
MO%URBY)_NX[TM1: Y:@.&OF%M@.?]2ULAPNP3Y;+?AG1JVX:B5#\PGY&;",8]X
MJ1\QS@.AU?ORDT_I6%'V[?7S&4TLDW;T1EZNMW'.K@.K<4OY.[X [9E<]G3VIK=
M4O0]?PNC;ZJ)2F VUKD,V[);J&2VK0K2]CT#WS/P/0,;FK6>?2[.9A1EF>,1
M:<KY%3&5;YGSE\R^9?9C-MXR>\M<GF4NPF:4Y3,CUT_F/^3[>P7]YGRDLVVA
M>\;[SMY">PM='=\Y+[M1EI7&?.]'4V;L_#*V\Y'.OI7V?K2WTMY*5\=*YV4W
MBK+2;\CS+^
M;XN]M^QML;?%9=KB_&Q%4198F:[:'&"^4MFVQ'O&>\7>$GM+7)XESM M>%&6-
M3^0LHOYTU5#Y=C@.O>>Q;8.\+>POL+7"Q%KA3B*7(W_;F']>WCOWM%"33>GLB
M%2=5\>5=YJSM?%[+W>NL*)F*+^GR9X#F<YOG[,]FI5[M$>;5>S?J+J;:6HY,
M?/<^O1+MFOW2BL9I'FBC9_=Q+4_;\I<IBZ85(57^%F81BE8E2]RF5#;+W*Y<
M19:Z6I&JU?/\I-JLU/.4*_]2/V3;@.7;QLWF^ZG.:H<16I9A6ZE=R/_K1/S ?
M?".?KFGQ:'5..T;77;^0N]%O1(^PSY)HR_^=#&6^&EFY_3KTC8%O*!)/J&%[
M!N^X/B7ZH5P]E3Q&<@.TZB?<B8BP);TCND:$N]<YNO\Z.3+;[=;:D*K.\^_(9
M&GW');Y/)<>N?(:!E8',0 &D>-\YM+Y%N8=DJF>ZO,=F>=N2R6YYVY.JO'Y\
M=4K;MD0V^_$NEW2R5UJ=\LY'+OO]^*J5_>I^_+RWPPT-6I\!L70,WDX/R49L
MD?!V^C;/[0O&)KU(^(QXA_%0?NV;/7J0P V)BGKGPF++:PN-S3;*EDQVVRA[
M4I5MN:I3YOG(9=]RN53VS^/#RBOO_&3)4L9Y2E/,KJA1G$F((5J#7F8Y%R=;
MEG(O4KJR]$#GZZNG`[;ELE?^]B4KZ_U)999YGO)D*^M\)<J_C&=C6LHKW;PD
MR5*N^<E2Y@.@.AY.M*6L !I)AI0"]W;+1'/."Y/B7N\6K?3(BNS3N'!J.A':N]
M+ULRV>U]V9.JO!'"ZI2V;8ELCA"Z7-+QGH5
MPMOIAL2'"$G$0T\,=O2U.ZYB1R;;XRJVI"JO9E>GM&U+9+-FNUS2L^-!52GO
M?.3*8P3-G;)/,UY05OD7)UM>(RVNZT$T;E M'; M5QXC+>[:_\A?&8L4>%\2
M8E,F[%LB$@.Q(@. *LX CX]DR'YS#7.93GT$]%3,N^W-6WZMG9DLFN9V=/JO(\
MN^J4MFV);'IV+I=TI*\C@.QB$B4@.YH!5"7!GP]"GQ'ONEI_(?$O>(L2,X)OP/
MRS:2Z^BIVJS9MF2R6[/M255>S:Y.:=N6R&;-=KFDX_JZ9S26>TCT&"U69$"A
M7LDI$6)<^93WP3)AM&E"^;%BU6Z;;4LFVS7;EE1EUNRJE+9MB >S6;'=+.M)7
M> T=(A@.9C ,CIA IAUZ&6B7,^6#=QBGOQCR1KE,`XGV>L5FS;<EDMV;;DZJ\
MFEV=TK8MD<V:[7)))T<-JU/>^<AE?YS5Y;*/;!7&>;#B;L1O^)HC2J9M$UJN
M%E%@.71[.#8SN*M+DM2%1X7Z;5MV63':MNCVIRK/JU2EMVQ+9M.HNEW321NGJ
MCXG!K#WV_SFEI/M&5_?M&:S=@._P=TR&FML&X4D_NA\<*]$V#\2;;5MV67/:M
MNCW)REPY8VO5-20J:N6,KB+^A77PFMQ=/944\)6Y\KXXV=+J1=J=\X#&[U[J
M]\[S>^?9T:SC)TL1EM.R4EEE-]9OO8JT1$7,^W^6]!X$[:WY5<XE9[6/V$:?
M,::AW/W;RI'3?EL`;'5K"]:K7V65=!%U#=9W&-B)C[S^I>1:E:]$V>)J\I:I
MJ'[!O#WQWO(7ZO14]'Q$C^A,4'XU&.G _;ISTQ?SAO46K1K\_Z_TG(KK"ZS>
MSV\]V;/HIET)LL9XV96A:-VKJGX-*#VDA Y@.#ZOU->1Y&O/*..V3.XG?H=QA
M2YST\51CSIC*5[9,4=\_U/79')"O<HX6'ZB^![*\D<^!V"M[-NX/1',E"&XH
MV2,M#G+#*+G=O-+IPNK]T^!7H\]S2(T\HV:"^=7[IMG('6-25QGR7K><(>O(
M8.U.$:6M(VMYY.EFJ2.M1BSWG\Q_",*_",ZH#WXJ*2,.X"=)_ 14]ZV.COO.O
M+./+A;[VL4F^)0/?'TSD68>H6AL@.*%]O,29_(G]EZ.^(U\^\'GL]-MGT^ W'
MWT[(TFO)[U!R/I;?Q6GSK-]U2/_*]KMHZJ/3Z<9!YNOT8EU_#+3GF-B_4/?5
M?T9Y?335J@./K]&GF^[[%]$K&DOX]<4&W(*5=7]1V#V8UHDG0(GV-8:LVIF6]
MLO!=7QB!T7%V:.RTU#&J_&7*8Y2WQ33\C)^?\?,S?IMJUJPW% XX1QZT!ZF>#
MM:\A2!N!-4S;,G8+LS1%M;0CYG+)L[/O87&WM=6RF3>JB9(^9VE-8RVQJW$X
M0]'YK&.CW05II-6M-/V"V;1M>JF+Y<]_ANZM/&^#_?GIN%4"BS L*X6&E5)X
MSQ2O1#*UP&K_+R0/W'<@.SZY?(JO37&]^*'VJQ<[X).<7%XTUZ$C$^R=)W&X3
MTN-^)1Z/.]A7S\\F6_;B2WO]>E@.-N;/4]:I(7LQ>,&F1YENC\M6O?&7/6\?R
MECY_/<,8()#HN">N:&OZ7Y)'%H]W<6I9RF)Y>OFS,Y%C]&]".=9G9#:%S?Q/
M],Y#_S/T-H\,]AT>F"G;M6OVR- _M^7GCI_&8Z9/J(N,!P@.9+"K7([D#(RI%
MYPM=1@.GJ>$ZH+_;[%,\ULHCU65/:3?70PSDM7-5]VM:+3>NF3-->7R^9U\6<
MW(K2DGUR?"'I7!N-P"TJYS=$G[:?FS7']AP+AW% '9N_#OH8IW)V-[@.VYIC_
M4%KB'?/7)^T^E>,_R!]:\[]1EW6=FYZ-L!P'K8F>'\A9Y(4QY4>C(X]_Y6SR
M*_$(,%/]!^8R3Z*_&M0MC#,?\9XH#USYV?S$T>>QV8G)N&/^*'__L[126L]R
MI*EQ^=L2O%4%L\$')KF"\;D\ZLF5Z0F7)VL>\VE]IN'GT_Q\FI]/*W8%W;IV
M!#F,^?N2K9GF,#'ZKN(HW2,I8^T_C)\L=63=DV-H:D_2W1O9`646-@.71@.Y'\
M403W?:R]T#/H4[^3NT,4%U9DCV)Z0C[NF/<WW@./NM=^$H[">//?RID_\OF/>
MFM*_K&'AFW+W^FUOF2U)<:,0$]YA8P1B-B5[?8%B_.#9&,#9^F4CYQ,R^8EE
MB]H`7$"E(_BW+.,HQ[ V?#4ZJ_V29?K(<V&YZMXA.N-]&[0@.*"^=)7[)S_JL
M/,R5$VWP5/+_:/Y7D.,.<]UAV9Q1HDNFC1I^9I996*2E]NHC6X9?G^IV^GF"
M*S[_KPEI]9KNJJ&,HV7Z4>K:B3QQ(,?_%WL4KV,HM,1_"%IS6SF'4=M8RP< ;
MAAJ-LK2W@.]-\)&&_R2:6GXWV@.;6<XK[9,C9_-@.?T:%_+T;%E=L/VK6>P<E;?
M&77.VH,^D:UW1Q7'<#S&'QY.CSY-F]HQ$(G&1G>"Z1$9= )[MJ*-P8XQZ!$,
MB1&VJ<MVI&@.]GVTGBT$"%.KQ%(,*/LVG$K#!U_^Q((Q_$HP?S;0$E']B'\>V
MK5B$L]@.Z%\<9YEP,SF0?H'BTR?SM8CZ6_T@.;_=ZL[5(\#;RCPJZ$:/?A2>K(
M?T\812]>]\WND_N!'&&/;=W)K<66"?MM8\?>!MNB!OG6MVN,67[5P8=TMA%7
M//5MQ(?11J2TC=@.6USGMEV]?G=L.7(OKW';@.2^IEAQ@.Z;$W'1- 7?"W6P"2^
M+H]<T<OMPY74R^W#E]3+ML%[>["?Z![STO[Q'I%&^("FQ]ZS*WJY?;B2>KE]
M^);9R]:6VLMMP+7,7FX#/HU.U6C5:Q-&ER1'1E_24]%W*V&68(_(QD2#?G;G
MR:=I&KPE#5R@.WF*.99=/8F<`L+8,=U*2G9@.LMDOT;QP[*!M3VKGD/-"_KTBY
MIN<`?G$>3)Q(ON'>;JZQ$<F>+S,:-^@.V/XKAIA3K.2!KZ -BW%'GT-'3V^,1
M6@.B=)6L%1UT3SHLUR3G>0XF9]BI9S[(Q5<%ZNL-!$=;3-3:*MIXN\Y./]9S/
ME*YEV!:^%,TMXY_.35[V>#Z'3;;3[:WF,L181KNN[ZT!2PV#^ 0;P!G8[`;_H
M^6EO$/U&C==HDEN\Y0BLXRW3_4JUZV5CJD*[[@.X'1;3KKK%1=+ON,C_Y MNO1
M'2\EA3[;'KP9K&5TWDO[DV!$6R>,IC7)Y2D9:1D=-P.;/3)67"R88G@.>"58$
M#F#((Q)L/J;7!A&Q:OF*1I>G_CV/!2M.$\O"&-JD[<<8]A+*0UJ,9[\,?>3?
M5XN%,GWR(I@.HVB<O&U,5?')W."C")W>-C
MOBCN/>^U3V5$6\13_[,\V]UZE-N)3Z_J^O[B=1:KH<^Y>C;<.V6'_8,+HS4<
M^]"@.'G]BK1T8K%79X9ISR#@.E/R$"1&XAE<=G5B5YWR/W8K#)8K1FJ0C.\I#\
M^>A0$4CR&AU:O8:N:'3%KJ$+UT,6C;+(]9#1;UT_5S369/[%8"[6SL31YK,V
M<M[HNFL6%-XE]AFZ=MYJ+IHGV#Y,\7F"HM&5,4^PS1C#<9+MP)AN9+@.(K$6/
M#)>-J0HCP^YPD/_(,/!B5S+W6"EJA'@.;^%$,Q3*F;\W<-MX451'\';#EQ:YH
M
M.>P\CUU0,7>GJ^&&Y CS?/N<V\-5[) (/MN\$^OA, -8I?Y$V9BJT)]PAX,B
M(DU<8Z-HZ^DR/V5$FFP'7]6(--E>+O.*-'D^<U($AT7,-Q2!H]CYAB(M;+GC
M\$7:QOE(JQ3+7BT6\K%$\3EI[6/AW0G B_X5]A,:$2W.8XTNN- C[*<Q) ]=
M2K8KV#MRI2C[LRSV)7\D>5F@.U3$AQ6(K9X_LHE'F$]^3=C8P?ZS%SP:6BZD:
MLX&N<%#$R+#G8]%(N5NL%#52[A8KQ8^4N\M/OF,]\1ZU:Q[MX@.@.^=_W955%?
MQ2(K3O?&(AGVW,">'!.#V2KL#PQT0(:^G.[9BMT+.SR'%5K8: Q@.S7]C!8]_@.
MG59EZUX1.,K1O:*1E3>:4Q[2*HWF5(N%,G<F*(*)HGN<96.J0 H_3'0Z*F"]V
MC8VB^Q N\U/&?/%V\%6-^>+MY;*X^>*1T1W0VV; 'A+>*0@.V^^1KSV#N"F\F
M`5\],MP1%B?\CUX7=@.C$;%;9/8PB<)33PR@.:69DQB$5@.+=JG+!M3%7Q*=S@.H
MPJ=TC8VB?4J7^2G7>N[1_\'[@..%!(/)=N01O.D:J;VI$C/PI[X,GA!B4"1EK
M&HR;5LMZEHNI&M;3%0Z*F0/V?,R;`W:-E?SF@.)^S$_:^7>6HF/[V(MZB'O<V
M\5=<'QMC#!TR-C*([<0.BD@.]')-0+P:KS[KR^Y1W8\4:1BM:9%C?75)V'[L(
M'.7TL8M&EH^7&$7ANJ9QBZ-P7=:YM+N6%8TQF7\9/94B$!?=4RD;4Q5Z*NYP
M4$Q/Q?,QKZ?B&BMY]%32V<D]@.[=KXZVTB%AK&!W_TK=RX_R 1W@.K[9#KB<9D
M:$A>]^4.Q,#!/Z^2G2P;4Q7LI#L<%#$>[AH;18^'N\Q/&3$6V\%7-6(LMI?+
MXL9_.D;...CN6#T:_3LG//CT?C)GU>*1OS("_TS!]>CE=^CFZ,G@.BGZ)ZX^E\
MDR)0%>V;E(VI"KZ).QP4X9NXQD;1OHG+_)0Y5]\U^BY=S)5TV-_=E2/T>?6H
MPZ,!6]@.]HWM&8.X$;SR?F '1H&VNDO4L&U,5K*<['!1A/5UCHVCKZ3(_9?3L
MMH.O:O3LMI?+,E?%(3X"ZPX0NX@.^\2F_\68\L#J6OWWZ0PW)% >/=(YY#]*+N
M/=ND/U2MF:VR,55CQ-85#HH9L76+C>)';-WEI\Q>$>+&='ZORQS07^QQGA"\
MP:8WV"9U>-<IVQ^PBOXD9A5UI[U&I:QGV9BJ8#W=X2!_ZXE1$7UGBVNL%&5%
MMX&?,M]ILUV\E?=.F^WB,8DN_UDO[*F$_N2(WWUZ.2/^UI%AL(4HG[%<'QGM
M:7:$MR:OP5OJ\/ZB9KT4P_,(U")P`$,>$:CS,85>:M'(RO0LB\!:M&=9-J8J
M>);N<%!,Q*GG(\Y'D9;.)BO%[(_J&BM%C^*XS$\^;>V)'%V;N V=M*R*S,8L_
M,I@.Y."4/B/X"3YACT/TW$2L`QN W#PTB`S!.!FZ;!COY+.-I).>'YIT@.&9M_
MROT8^7]-[M^*5'KFD/<,Y/]Q<":4-P]].>:U1TG=#09FI<Z7DS!?5[G)2W.^
MTQ._I*=:=!WZ63"\(E<_BR0?$M)@.E]S\L&XCOK3]COQQ%]_O*!=3-?H=KG!0
MQ'R@.:VP4[TFZRT]><3Z+6D*,I6+N%/M)X U8V-^I870O1^S9CET;3\G)T&A<
M"HY;O-+E,X@.V7>YUE]<2_ME@.A'C;46XG/KVJ'F+Q.CN2',\E[VNY<B-7IG(%
M([H71NOP@.WQ04S^QU@.X,UO;OB$\\I8Q3\A,BV!%6D,KC,[N1O "^O?D)RIJ (
M]HJ8*2@."1[$S!:_E^'.!.I[_;,%\G'\J4!/+PACZ(MN!,=KKQC7KL7BO&Y?M
MQZHW3A:-K9PW3A:-,I\W3J;=MZAHM,G\B\%<K)V)HPUS+F/4J@.BL18]:E8VI
M"J-6[G!0S&RYYV/>;+EKK!0Q6QY%[;K&3M%1NR[S4V;4[G;Q5E[4[G;Q6$34
M;C2/XVW;\GD<E_E9=QSFE3R)L70<-_F-O1<Q;X4C_-X1//A_)&E<"=*IP5CS
MM:#Z*CSN;)0/(NG3YK,;W'4L?!\:K$\^D5]_77#_7Z4<_RIG,5Y^3ROUR/RG
M<O8/*Y\+2P.E?">?KRP1]-2N!,...FFD<L9]Y)26)_!^"I_&\>F1W3%/'^_59
MU=$WS/&S_(9^O*7_LRS7/RQ,<\?\;'XRB),9!SDOD_QY"J=,XX\+TH<&+'H2
MSPTX?[-)KO\SM9ZAYD^-CAW<FE^-SI7L\'\TJA"5Y YKV(Z4[FSN2.WOK,U8
MZ]$SV .M;5[P-V*.7@.0Q@."TYPAH2K*E_03N!6JGSNGJV+ZG\0U*;4@.J,-^P8
M'7'?H:S7/'HNP0[EQYT[\G<E.'24?B>H_],`PR5GA[Y09WX)M&Y'_GXC%YA#
MVJ2.8J>WL(X>F"DMS1GONYA39F$M?B%/-"7]'NLX[&>;==V6)&KG+B2=:Y'F
M$Q$7D[/6RG.6BHT<;6LL=O +8U2Q/OD%__>"HU!C]PRB64>!QN(-Z>'N35BC
MC/@.$%S36-G>3('H#41@.M,C;@.F<XS[L"2YVZQWK6V6N^\I2S#4GK6/>N>=<^Z
M9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z
M9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z
M9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z
M9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z
M9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z
M9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z
M9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z
M9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z
M9]VS[EGWK'O6\V5]('<^B*Q@.
MS'_)_2_EVEOY_V >S3U3^L:KC\3=E.OIT(TD?:3\28[/8I+I-> ZDQ1N*,.9
M_#]GWBU)I4E<0Y%T8DX%U9X9R]E3HA[*U5/)8R37QG(TD:.>W#&4)WMDIBN_
M>G/XT'SNJ3?S^,A?II<92JD(J>R4]['Y(JCNY+-NJ;^39SY91 3ISIGKA>0>
M<7TEN>Z87XAN*OG^WH(F'YN_26K/2Z<OGR%K\X3?IR)?5SY#8AE2<F !WHX<
MH1:W*/V0&M"3>T>9]#AOB=+J@.[?POEWUK'O6/>N>=<^Z9]VS[EGWK'O6/>N>
M=<^Z9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>
M=<^Z9]VS[EGWK'O6MXWU]=8#Y!_=7=1J@./E(PK4`MO! MK+7`@.P-5BX,B*@.C
MWZ>4;V2:Q#*B[*>BKQ,YLR]'0RGW@.=PYE%_[@.JDA6(#^N;9D70M@.2R*_%L!;
M:\^Z9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>
M=<^Z9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>
M=<^Z9]VS[EGWK'O6/>N>=<^Z9]VS[EGWK'O6/>N>=<^Z9STMZW;VVK&W>TK^
M;UI&^F>"\-JJY,^Y7+4333YR9'FC<EZ2E/G6[/+*-7^9[+XUNVKEO?E;LVTA
M@.G3GS-7.3EFKD<5KHOMHEN]G5E5<6?8S@.Y1=20EHV@.:[KXT-]EL;&]V;;<!S
M?<K=X]4^W]7>E@._N'+)U[JQA;79YG+]$Z]B:XF2JQHY\MO 4J<'+V@.&M=2TY
M`A[4./B+(Z+!^3TY`E8]:@.O30^+LTJ/<%6P=N;*^#N<O4Q8M+D*JZK28=A!5
MP1:7I\=Y2^3WEO2C$YYUS[IGW;/N6?>L>]8]ZYYUS[IGW;/N6?>L>]8]ZYYU
MS[IG?3M8MS/KYMYLQ:IYX^V9JQB+++N<RQ[*$6:Y>_(-/,""4L814.Z9#L]!
MGX;R7"?0EGVYJS]'6[+.5=B2R.:\L3V9JJ'!MO!408-'!F^>FXBL`]:Y4SD&
MJC[EWN,,^:G\A]P](NT(F@.G_HQZ/Y#KFS.UIL"V);&JP/9FJH<&V\!2IP8OG
M\U&7$%?4E'L0H8$W*R+EL.XI!D0==>7W*>]&I)*V[2TYVN>9]74X?YGL1C[8
MDZHJD0^V$%7!%I>GQWE+Y",?..._/L^Y9]ZQ[UCWKGG7/NF?=L^Y9]ZQ[UCWK
MGG7/NF?=L^Y9]ZQO!^MV9MW<FZU8/NNV37,5B,$8B#PC?F/><$3Y-(IC9/9,
MBUC&<AWG!E+6'<';Y+4AL>'^Y]J2=:["ED0VYXWMR50-#;:%IT@.-7CP;BAJ%
M6(U=@.[@.CK/J'%=/H#<0;(4[CE$B'C$0:\[C%*UT^@.WT!LNAP_C+9G3>V)U55
MYHUM(;*MR6F0@.;]+GIU%-Z27,I56VF6$8]&->_EU3T_KXJG4[LT9?[F,;1+H
MY=<82E?0+;.R/U(K)^:2^%"[+\6K/#/7)5O:8N1*:[>&S/^,\BN/^LQ/DNXK
MD>50<L!S38/85Z1Q*^6T(_=_%QV!C>P9Q!TBW1;+$/J#ZY^#E&';6[RZ2YF.
MS6M!?V)^EAS>2NH?),<K81":-V7J#W//09?_4^3!_TNY\HW?^@.L\W@.GFOTMZ
M#9%G7_+"+CD=Z1.,V2=HRI%ZM ,Y`F>(E7QA$/?;->H3X&J+<@.[,/RCKB:2-
M?M7$H+=U$>2HVCH4_C[(\Z_EZ)W(.S;_E#0^"*;7!O[&6WE:S QSRGH'\/P[.
MA.E^L"KQ!\I\*+*>L7YI>5Z:WVB=HY;V7-B"EJ+/F*PW.X+RRGQDS;^7$JXF
MRBD]PG.1\3<I\PLY_NJ<9AT_68FPG):5RC*;H:GA>I26^LS)^_\8G' TKOV\R
M^&)%V:W\]WA<U#<JKTW(6R*;/4CW/._E/4AW/;?W3/-*\M-QP&A$[$QL^!6O
MH9UVTW][0QM]%]@.VM&J?>.^1N;7LE:Y?7XN3S;X?AQ;+^W'>C_-^7/%^W"J[
ML7XK7:0E*F+W[4LI292:XKJ0U'''\ E-LU2[7ZQ\V49,BY6P"CK1JKA.V)0O
M'YVP*V%Q(^K1N/,^QYEOY)EC^1_909?]^ZC'@.I8Q.2;[?,9_ZJB?KRW7:S.B
M5'$/;9JI)[TX-7MKOL+T1Y+NU9.?44S<0YCW"74!&J)Q(+<I95AW%& 9GT75
M=.1RE:@.-/THN5_09+^7L5"2["H[=K 7)NC[;LU^_'BQ/+VW))$?[M*RB,<3_
M]UD^T"/<-9"^QS2P2[AK)RC#OU$W<#_N@.I4^YY/A/8,95J([TO:"9ZWB_+.J
MU79](?9L.D%Y,_&*[G_:VY<M#T73USL>BZ>N.AX+IZXZ'HNGKCH>2 Z>N.A[
M+IZXV/-<Q+RMAF<CQH9;WF?>;'CO,\Z&]S_C;'@./-,Z&]T'C;-31"SV6=(#_
M@..>BD?USHZ-A6!>!4<.)P=L!,5MY:C"#B5E/,+(GU_;(2,=TR%+;8+:S)_=C
M;A3L- WVE,R?$5NC&B$GQXQ_N:><1P8SUQ@.9_>X4)S:T1'/Y0MG"T=$B. AE
M+U\GYC/P,\=@.]QASX 8;^6F#<O'*G-1,,S3R1&W$%>TEHFOJ5C^&_(TSYVQ+
MFK5L-V8Y:-2NI7C.@.5N:D \'+<\!>Z%UYV#7<V ZG@./V,^O-@.;>(WAYZ:^AM
MH;>$O=HST*\]`WNU8R ^LHH[<&1O!Y[\.; S8C"/!;VSCER<R]F?C*X/#*."
M!P9OG@.*.+E- K>@.1(UAHLQ9HK6CQ'%CIR[UXAP]V),.[?CIRCULL')IHQ=T5
MI:@.C$UA_-Y+G7YMP1=]+VCK,Q>'=3FUY\I3?P D6QO*W3^P->;+#.H-S>+O3
M/L\V#=[_U'.&!<7_-M"!;M 2#%C./6*&==@./CCIF/[ $`Z-SDSV./HT-XNWQ
M+JP&]<(5].'Z1T@.Y-5\,WNUU*)^7; 4Q`SN63XNU8<BZ,0FL8X]'F(D=L@.5M
MF#[K1==@.G6:?VH"VUA4F+@.Q6Y?PBGW"^I=Y,W(DV?/(L2-ZX5E\>1N1!UY#4
M%7TX!QNV$K#P6+N#M>A#>@.5H-49&(UC0-K3(0IM,H97 FC P!0:PEAV>YM Q
M%M[0(M2=`[4']69!K4&].3@.)/*9ZLS#F>EJ<0ZJ?:LG#@.3QY(A(<&*RG#V-3
M;.W6[0H/5X&,&J.#:$^-VZD?$]AC[]Y@.=_T'[@.(4]:WKQL3]DS:<&QUSJRL3
MV!GIC:0U,#\&$7SUU8E+.?<U9B?JKA,C^?;ZH/UMSP/:COO8'FOU92)L1^OK
M4X46XHW!SG_OO:T,F/BSKQW\?^XU0IY^9_:]/LA3W\U-K37BGGU0[/U4]][&
M5([.Y"S>Y((=RNK;@.F(&YY[Y8B^T;[76"8S&A+VN.ON7RD1H* SP3H9]=;R:F
M1G?KO/ LB)W\5'L6+N3LK^:F]CS@.3;'>,ERSO:@.["XB&^5A[%O3=!'7E`,_]
MZ,=A8N/64X/=C>L\$J-,X"I8\0SH[@.R>A993+-A8=?.<@.[;GP.QZ#DS'<V"Z
MG@./3\QR8ON? ['D.C.[?Y%EPRUO,BP7O+8:[.'D6O,<8[N3D6?!>XUM*@.#6 (
M6)V-79&';#M/B0QK)\ "UM^U#58G8R4[5F[C/JRZPQMBL2:[2RO;+X %.R,*
MQV8LSX8LO RP3K@.V'6NM3^48ZZ[[Q(^5A5VB[@.?ZT#-8JS_A?["#=8A@.P4W\
MH<1UYR&L#6,S(=H&L>\3)VJ'KC1J&MU1O&^P7WAH)[H&JXXZ1 M^SMT^[XC(+
MD4[4CPW$+@.RXSN: P#"XC59'U:PB&M7;A_1\OH_C[]X*AMFGQF:/#&Z+8<
M84>8/6<8T%WDP_T*[FO(P*P.Z+B[9Z'E% MV=KN:Y:#M.3"[G@./3\1RP!U5W
M#GJ>`]/W')@.]SX'1<7?/@.EO>8EXL>&\Q''?W+'B/,1QW]RQXKU''V)I$`ONP
M;W2/UP&YP"C:F..H8[*!47:<TUWN>KR*N8H1G\:=8 9CL/FSD<\(4]WY0,Y8
M(X054Z@.;F(4!=IUEP6P,YIR:1 ^4. >.FAR/'7+W*\QB[1O=*[?+6N8*>NR"
MC=VCO\J5<+RQ7@.Q@.)<Q4TKDSGYEWM"MHW9C0LSCSC>?JQ\!(I !E)*I"RGNB/
MS!GSK:<M4 9NS04M8OWP7T@.:. ][>,WYQS_+7QWUX%+D>>2*V;IAO^*Y.WJ)
M\;T5ZL;#GXR^W[QNN-\8V/Y?: ?#MS2[PX&-'F.2`=W9L6Y:<$P.OO$;=]R;
M.O:.XBR\HCUXQURPT\@.#WVA?9T9"+NK+PI6D=4F?&7LS?3+U])J/63-T!7W]
ML-_P;/V08Y^A"\IV66L_4?=;^F:P"U=]63B6C[:0`_8>(.<)4_U2:S8.> [M
M@.HZ[GU.:::TY.:*/CARTE_G ]&]K7F]>25K7E/(-F:FGOQVR$7_'YY%\7QOT
M0>KI<8><O)>T;RA!G5GXF2Q,F>H72>L-=RRJWUP-^J#Z6_WO!_+RJ9;:L8R-
M>H[?X+D1Y^/?R;5/1O?!+*9-"<?@.-F$AGW&\<"U)G4=T0QX:?ES71/&BGH>6
MY\%$,:.>AUW/@.XGB1CT/7<^#.?!6DBQX&PD6O(4$"]X^@.@.5O'<%"S[-@.PA69
M=6=AKW8L')OG,3/U''%8Q$3]QAP6,5&_48=%3-3/HU[$1/V\ZD5,U,^S7L1$
M_;SK14S4S\.>SX2WE\J#MY;*@.[>5RH.WE,J#MY/*0_W&(N;S4+_1B/D\^/$(
M\%#?*(AE;/AQB3@.;?FPBSH;WM^-L>*\[SH;WO>-L> \\SH;WPR,VO V-N/ 6
M-.+"V\^("V\](RZ\[8RX\.,8$1=^+"/BHH[C&=\DU2-SP_4L6"$(/A[DW*.I
MXTX]8:K0CF,YOC=8-QKN</I2G@.83>"/0A-^G1(?W`X$/O&T*^W?VY2SVZSPE
M/]CQM<>GP%V7][C#1W(OR[KR,,]F>"[F[^!3=U[F[6#C=66VWNB(N><CSD?#
M*4;R\L4B/MS2D/SY:'D^$GRT/1\)/G8]'PD^.IZ/!!]=ST>,#V]-XVQX6QIG
MPUO2.!O>CL;9\%8TSD;/LQ%CH^_9B+&Q5SLVDJLVE8<H/K!NHQW+V*C?6,<R
M-NHWTK&,C?IYYLO8J)]GOHR-^GGFR]BHGV>^C(WZ>>:+V? V-.+"6]"("V\_
M(RZ\]8RX\+8SXJ)^8QJ+N:C?B,9B+NHWGH'GYN]YG3\/H?QE<[!O\";CEZ8A
MUX&E)T<C(NX228>(]PS>Y'[*J,>.">,CFT0Y,AH)V2<+^9>\G=&;U_+<?YK#
M&B+7$M>:'[W%?1!H]3C08,7>ES\<`66/++2"(^#?)VM:,\#.OCSK"@.LC@.SA@.
MC.^&;R+3^CV2&@.].@.+LA;(R"]]AW3)M'`\$[IFXTY9XV&=SEDV"I8Y9%`]NH
M\S;1(_]/A2"O5MG_*,_?BD1(Y]2\IU4_$O1 TI(\7S'=<+S_)>O]B CWA($6
M+?] _O?)!:ZU`@.O1Y5]:41M >[9+(E_]UH%>>Q<R#2X*T8;?DU%L03:@."P
M#HFSD6 "N'N,F-\^)H8!$TF=:-1,)W"$__N2GKZ-ZXO1]Y7!DJ(5V:<%&3W9
MC@.&MS"PW?3)7'C?YV9.!:,GADRU)<M*EEE25D[QJCC+R3NY!# /EMX&G7BY=D
M/R.^!@.?Q\\#1I!\ZE'HS(1>P+KL&[3#P-FEGT%*C5DWHL>V9(7L<3;;&X,65
M>G,JGWDS[)OL-].5>UWPP)9AS[J[3/[8;=2!9<BSEKO[R+/N>. ^\JS[&[B/
M/.MN!NXCS[IW@.?O(L^Y4X#KR[#NZN(X\^_XMKB//OEN+Z\BS[\WB.O+L.[&X
MCCS[OBNN(\^^RXKKR+/OJ>*^)Y,=N1MS)/GTT//&7MT>NNO(L_?074>>O8?N
M.O+L/737D6?OH;N./'L/W6WDF_30W4:^20_=;>2;]-#=1KY)#]UMY)OTT-U&
MODD/W6WDF_30W4:^20_==4\F._*\(Y>KW$-W(6H[GQZZZ\BS]]!=1YZ]A^XZ
M\NP]=->19^^ANXX\>P_=;>2;]-#=1KY)#]UMY)OTT-U&ODD/W6WDF_30W4:^
M20_=;>2;]-#=1KY)#]T5Y'AV_DKCK,A=B1ZPC]R549GG5Z#_>.\,>N@.M0=@.P
M6/&Q:W2-%-9]X S0`RLP#PS6U&)%YKB ,K<W*K,8>ZNBV/,O]79MD>_6%GFG
MMLB[M47>JRWR?FV1[]46N<ZTK(M].Y!G\>.V`WD6+VX[D&?QXK8#>18O;CN0
M9_'BM@.-Y%B_.+>0W/(OT-6)"]WN;&.RML"LY8\<)[&RE>S!@.-Y<]HNW(!PRT
MC>X...N$UMWKH2>R-C="[7.J;E;O+R%NU1=ZN+?+=VB+OU!9YMZ;(-[-O1;3H
M>2'?S+ZYC'PS^^8R\LWLF\O(-[-O+B/OU19YO[;(]VJ#7/?H'DD:KP7S!=/$
M:/N^P?A#6_+%CK2G_.Z;+K%COT2,2&!76NS0>FI&/-<R17@.R]GKH%P:[0OXB
MGRO*^%)P'!KL6-XQNM?VVORSXU!+MQ3XA_Q%+677B'U(>&Z5-;7,-^)_GC
M^J;(1TYB_\*]N3='[A+V<\D9^4+*J3!0)YT?L=S'C(_#>:3\B=8.8Z_8D;UI
M,-JJ]EWWQ<7Y`8_VC.[-K?.*+3EV#_N;H+Z_I139D;M5WQ7[2:#Q]<*.W.\D
M'=QQ;\)5BTUYLF,0'3B2(]3K)M/4-W(@.2E#?1;$O6%'7<7>/W+B-O55Q[+:\
MNN?(V[5%OEM;Y)W
M3;PXMY%OXL6YC7P3+\YMY)MX<>X@.QTCD/7.^E=2^Q4;ALV%WJ8<^E8^N5[S8
M&+=KHQ,A]F\<@.ZPC]@.NY\JN<WQR]>]BO):W?:EKNUY*VC5)W$3MFW#[6%+N^
M!=@.&<I>P7QOLQO#)(.+_-_-0J_8=-OZ*.9_SGGIA5X]69YOKU<;=T\)?U;K<
M4>OO+;3Q;NJ\UOHZ8I^:[W+^O*;E/A49KFJ%?21/'IL3D>) 4+R4J[^9R]KT
M96XDG3OY_UFN/FR,WBWL?Y-40N^N7G9>L8=M?+VPOS5C\T;2>R-'K\V?:XG]
MV+RCK:N73ZMM'/YOWKJ[B3VT=G6R\WCV1VNUW;7V'78^].;K;.?UQ+[0#3_
ME?BV=<)^3)T?<,0.Y\/W?.B.F8@.`[LM_1,<C2GY$W#BOJX'ZP5';-/F,6U'B
MS[&W*H[=UBSL<^3MVB+?K2WR3FV1=VN+O%=;Y/W
MSFWDFWAQ;B/?Q(MS&_DF7IS;R#?QXMQ&OHD7YR[RS=KRAE,]]*'!O(N>TUU$
M'S@./\\E,398W?FP+=AVE6@.^_2]C?&(R\_R)IX!K0;O+^V<X68,_Z_EF7WNTS
M'_DF[QUV&_DF[V=T&_DF[V=T&_DF[V=T&_DF[V=T&_DF[V=T& 7EV^U9$BYXG
M\NSVS77DV>V;Z\BSVS?7D6>W;ZXCS_[^6=>19W__K.O(L[]_UB7D\]^]NTE?
MK9\S<GL]]$78L_;1\\>>=ZEG+7?WD6?U8=U'GM6'=1]Y5A_6?>19?5CWD6?U
M85U'OLD8I-O(-QF#=!OY)F.0;B/?9 S2;>2;C$&ZC3Q[']UUY-G[Z*XCS]Y'
M=QOY)C/I+LVA+\.>I9?N]KC,)C/IVX$\BQ>['<BS>+';@.3R+%[L=R+-XL=N!
M/(L7NPW(L_72MP%YME[Z-B#/UDO?!N39>NG;@.#Q;+WT;D&?KI6\#\FR]]&U
MGJV7[A+R;Y+RD4%,_[W\^DSTV$7RT3Q4TI.QWT._DO0N):4S@. [W5/O%L'4<G
MLHY'=1S#CGW IY+6G6C[E%H>OI$SZWB<.]BO>![O/[@.U\3<?9"UYE[#KWDK?
M#'97VARY^_7]+671L=@.^\>O[M_&-78:PZ_>0+. =G-AEJ"]G>P8[#VT/]L;:
MZ-WV:R+DZY?[MB!OU19YN[;(=VN+O%-;Y-V
MMB!?W[YM"_+U[=NV(._5%GF_MLCWMAIY<AV78HYBI=;%W2X`N ;T>^C+LZ_?/
MMZ74JSDN4P3R[?9?ER'?;O]U&?+M]E^7(=]N_W49\NWV7Q<CSV+?BFC1\T>>
MQ;YM!_(L]FT[D&>Q;]N!/(M]VP[D6?KGVX$\2_]\.Y!GZ9^[A'QD$!<%"? ^
M+D4U$IP-08$];AMF++_'1-J1<S@.:"-(QD3;E'NR"VS"[?+*(_7_M]=!_E#1N
MS4>F=6K>\PC_]R7-!^;R130#425XXWA/,.^3C=$3#P,R!A[P)B.7L0^)Y\3@.
M;4VOF&X2,=;G/4?<,H@.BV9-K[FC\8N3O#-Y$>2Y7+\QE:OSN(+?_+K*N,_I^
M;VR_=]$=[/;C8:N&_97!>X,O>=SD=XLM=8M'^+TOJ=^(A ?"D<;#[@.@.N7'DA
M=V"DIF>PUWN/+5]?SMO*^8U@._VBPYSC>;_R\E(J2`[,07\7'T;:^J%S'YC?>
M`4W1\BTJYPES*XY?]1K#F1Z4\[3 W.&Y(M^)L/PU9^UNR'UAOF$^I\1_/2/%
M&ZEK#Z+U]O,[HCZ%^?PD^4PWSJ<:>NMS]CG[G'W./F>?L\_9Y^QS]CG[G'W.
M/F>?L\_9Y^QS]CG[G'W./F>?L\_9Y^QSKF?.NK([S'G$F;8SQK5@.%A*S<7<;
M13@.HLI8<[...,761-EJB/&_!Q`_;SFS>C_3_,:3!?L[R/N/_RPUS:E'6M#GM
M!B4^-H?R-S0G\NNO\GU)W8,.WIGO<@.8L(8;LB-<7I8?[7LM]B!]]:U"7_L+[
MH5$:$71CSH/[-K$M+=;X$*/=E.*123N4&+&!%WRJ(?>U>/=NP&PR(NH]_U_)
MW6?,ZZ71*)$'P7[/]+[QCD=RCY61Z60?B32P2JB-9S.14^^DA#[)'9?,$=?V
M)0?L`OA%TCUC9-4G/OW2P%XVY'N7\B.B%=J-,QK7W&"TUT"^AXP%'O.X9?3]
M2WAF3Y[8G\.3<G#/6C2/IS*D3,OND#&"9T2C'.LS/S$R=L2:@.>?4)B"-6[&.
M.W+_=T&%DNQ)C@.VF"ZORBT&T':Y_#E*^H([M\@.\R'4LMF4@.M^ UER0(SF!\D1
M<:B(/)XR]8>YYU!3_U/D41L=KC#77] Q1"W_7=)KB#S[DE>?K>,+.0/9FW*D
M;>I CL!90["_8+Q?E_(W@.SH!.0?F'Y0UM 6PDE]9%Y CVB@.P]X/(.1(T0RGA
M(\GGGY+&!UJ*?=J D^#,(>\9R/_CX$R8[@.>K$G^@.S- FL!Z6Y^53VQ+6941"
M0F?1QB;KU YK\$=!"7W^7E&4N@.L@.(B9_>XIM=4VSCI]L1EA.RTHEO07Y5ZFC
M2'_,5ATXPO0GDOY-(M4C*6&-+!L_V6:UW4/>`1T*[U9KDN[>R J\IP2A3_.*
M+>Q]K$U0?3R1TGHGZ89R7UB1%O'M9_0I+VF/;FF[[E@.3=DP8NZ@.[Q[Y<^,0Y
MT[L)6$>Y3 /K=AG3FV1JH86X,;=\YIY8;H*2>!G#:;_L7V9HQ\MIGY9Y!^U,
M. X,UG*<T 8=ILS!A@.^M^O= F_+5I/&DPW4VE[0`WR77XR W+8M[6G#5[ O*
M^T?Y^SOM#&+7V_P_9!Z:RPOFA-T'7@.B[*)E]7L4J)JSCFK!$AG)^5TK@.'RND
M.*:%#7NN(RF!^T &;0_T2943&AM&ID[7L*\?4LF0S*E,22)O5_WX5\PQ+!OH
MD:9]S%;Q/;_3I(L:]I*?=&4"VQ):J5?4[U\-K&VX>DO7<D$3IX%LC14IS[/2
M>*XC3S97/*MU[5V ^CAX<O53;^7J*_:I7@.NF`RFWOZ1\%G;J%V$`ZRX>).>#
M6!\6SY_(-:SYP A&?T5:28L!7Q?E=ABDU%[Q]*$\?R1_)Y0BG?2Z1_DC$9P'
MMNGR2:?G:>R0I7O'[S,3;^$6YZ)7+B1UY#%K1>QZ,FFE."3R3 VRU/SU)TZ1=
M7,5T,J79FI?6GQO1+GQA#;DS.VR#M5V[7"O_9'U1*;!F&.T@.U M%U4V@.!GO[)
MH+>,DKF9N?>*DFK*ZUF)$]:M'P7;">O56Q.WEFE0AK8TLJ3QWH\]#R"M%5]E
M#;2-RD>N='G/M@.S%<Y2^I8O:J72M'JSI/>OK0RD<SV][MX/A1?J3KT[;1QG*
MFQ5O<AS1%=1)J;-B_Y/!ZNRI,ZC_Q'&?X\QXM2_I"EJ,:?V8TD95&5,6&ZMS
M@.:Z4E$I[DQ'KGTQ^[5O5L+XV.GI5AB]7!-[WE<?6EQS2>E^W1GORU<<3R;HN
MMEWVS+YM-<;J6]/G"->K=]&3+I:FRIR]?/7Y`]I8C#'KGCIN,Y!$DXV10X/Y
M1->94!3KM#\:P;0=K5 <D2MV;,BQY=7XPEE8S/+F/\Z%6!;,]6'T$B/6&..#
M7W81H'@.PX7PP, \,>I:8$]+Y19R+),8H(E)Y?,9<\CX@.6\W#=P,?\9+C?GFS
M\#/'W1%3\+,YIJQ1[IC96D?:ZDOX9X/]XJHJ)VI0<CS;MJ31R#CV3]Q-)1&\
M?\31)<=8=.979PV6I[)HKLXVMBRS?L]'^ZYRJ&F19.M)HW&O_R'?WW-E*[+8
MR^73N?5?A*-/B:=L1B*LGE4!*^>5D$1;X6N#6!>="<4]R?MU]LAVZ14W;QC'
MB.@.+L/_1P!M[>(J>/S-YS ,4AW$@.U]Y([1N7UC(@.SOZ"_L@.W\ZN)Q]&MLLZ(
M5D?9A//*MA&LBE=0[HXEG1-)Z?@.I7F%5JY!L6U"'OQJ-=TK?L@.SY]&S$!#RZ
MCSRGJ6 .>%7LP;R49EO,-'/)LQ;\^=H)]2S1_J[#TW+)TK7E\\= =%_IB7Q&
MK"NGK#^H<]"6/;FV1VWIR <:U&9=Z\G]J)G0G*8<[R;T/:^^8-8Q$+=09NT=
MY('1;N^@.FA)J1$<479R'E)O&;,]*N2ZJ,"57T$77EN-,UL%%43)%U_XT95-E
MF[1<_GGK,*JI5^G'TZK?0FS2<[2++4O/<;'WT6'Z(WYCKV_L>(_?D&PD^4.>
M?JH(\JHWGV3UX8&JW!Q?]6]#W=0IJ\SX:AZU=&MB\@.5W4P[JOX\<C /9&FD
M>!XY6%V.TT<.IO5!BD6:U@.>I*O]9]*GZ-7?S2!JWK>WBN0"[N&S.!>0EV7I>
MQ/R8AH'!V\&0>M?T*%O#])@.S9&O3DU//KL5SD!4S8"..96&?$[Q#J)&;-N0?
MT^ Z!UDPAW$<;B-/%\>1KG4MFHETK6MURV>=%J?J6K9>#8KB&UVJ/=EZU^B]
M8]ZG;;!*&6^;:[,]ZA(A5A_O$U=#,&&?JQ'/Z?IDG,6\PL3T"D&8O7?M$DH;
MMJYHO.EL775+81U;5W5=RF('].U@.X=I>O&E5Q_P&M&T](H-GNQ\<=8S.#S?D
M3^>'815;!KMR3<R DL 6%FL5%,4MUVB?!RF'F#;A99OXL&%=BF8CG76I;AFM
M8UVJKFGKMKPNU9QL'I2;MB$;U@.[18%>:,3W=4S.D=SPQ.L[1X Q%B@._"V;7C+
M?7K&78/8K#Y;0,PQ5=M;= FE#7M>--YT]KRZI;#^;$H>6-9I5:JNT39\5MC0
M7?F%^$_$*9[2+NM;T'=I?5O$V"8/L,/8$PP\`!_B1S%F.RS8-N7GLVX/'W9Z
MQ,6RD;9'7-4R6J]'7&U-6W^TR)V:DW74ST7;D%XGDU$:]O;MSP?M.E$:<7S5
M1[8<T>+]N*J+:_/=HJ+?NGN2&UB34J?3U>TLU^5Q)6X@.3&M3HYW-\L"U?C^J
M>"G2>9=%EWHZ[[*ZNKB.=^EV&[<XFLDN+IO13'E)MIXTR?CT_ -B*2C2;?SD[
M#H&(+ETW.>394^8.WQF28K2E;4XY6HS]O4]Y'\98L$(!\X*('-#WXN3K;6X^
M\K"("[<YL-$>%(T_77M0W5)9ISVHNFZMWXO;-D2A+^R*%<C:@.MO%9[,%STNR
M;*--FO.$$3.8[SR58\Q]]HV..R%*#C+T@.U8<[V-L48X.9<4\!&2JWFA3...30
M)939>N_516BK]^X&PG5U--Z#S@..A'8^I6.;3>DQ5U8?U/*9J6Z;L[:]-7';;
MWWPDR]+^SO9/QV9"&1J4
M;8WSFR?'CZRMWS5YV)^^Y<'"R[4E/1LK%M'XKY"'OBS>9YNE(0-/ZAHI.G\
MH.KROXFW[UK]7L?GJWJKMF[OVJ56.MLHB9M^2%;?W2Y:F[Y[7I)M8JD0E8LQ
M.\1@.(>=3RH,H+.2/\[H[4S\X:ILFGQD:['7:EB/L4+!7*4OUO)5W`^6ZEJNZ
MJ&Q9+I<0KA_YD@.>Z='EO=PV)]S2JPW'T?C\WN+;U?C\WT*9[OU^ZGE;1B-/U
MM*I;#NOT/JK>(J3'$L[1;QLB5]KN3>?H[>*SV<_(2[+UI$E&V>7'5E2RJS15
M[[Q*E.. GL)-#K["\](<\&WLK\1#R2*IIE<%O5MGI!LK0;%3T8"RHE<[YOS3
MF-(B*@.3G=!UHCU<1@.SGBT[@.3DF/NRIV1[N7S(-O 1Y:^7/7QYS$GMFK&='O8
MV&0V* \6LHT3N5$[;?11BD::KH]27?XW&6-US>:OTQ^KN@.5;=TS5)8N<;4S5
MS38G:R_-+EJ;O;2\),LZTHYX;LBB\=J(Z\8JIR:E0:XX!YF;!C-76-L/"8=F
MW^CN@.XCLKGHDM4LHLWDPU45H*Y+:#83KS@.9M9TDN0A>?`W,!9 2AOMO'=:MN<
M[..[U<:USMXGL_KY)Q/.'FZ3K9D_/VH?X7(I,'IP)OW0<!1]>ZU<]%OW8W$#
M:U+JS6=_7<"<;O8WWU8K&\_QJ (7F$X;59#,>?%,>[&8TXUB5;<DLK2%K^7X
M<TE\%SF2M0U^6M1_A,3ZII%MZ_-&][N(T,X[F Y8-Z,W<;G-0!)--D;"MU*Y
MS42ZMU(=TSKC+-Y7G7^+.)(<SB4O>.R(E)C*%;0.%P'&!_G XGXBAH&!W[AC
MWLDOR(1SD<08J40JC\]X3=Z7[CWCB]Y&GP<+=M]&7W4)_VSPWIEJRKEXM-^N
MM#9&^V>CH/*2+[(TJ_SJ*Y[/B[,/\GDI?W=!/O@.]I<7^(-^/E.C[2CU4-,LB
MM6S*_+R,;45JE:V->K]ZN%.1\C:'D;N^I-B0#W;2VY/GETMT(DS=R?5;7K$M
M2]/HN_/6JP/V-#>);AV9TL4+]<D35H5-^'U*[%@.C!K:P,P1F"OMR%C.#IV0/
M48 ]/@.5FN[RG"._&;KS0_&BR[>$C2\_<%2[L1A8N8\&%FI)7W&ER7#\ /_%E*
MQY62L#$:6332=*.1U>4_>VUWKWYGP1K.0M8!:WR4>1OQOJ\\M FSQDBYY8%D\
M35=]S*PC*';1VHR7S$NR3<9S\F,K*N=L6HL]1I G=@.T943+=K;Y#R?!64>S=
MBQYTQX1][2:E&06]ZCZEK9+6/K<^+J&TX6$6C3>=AUG=4EBG9:ZZ+MD8/QH$
M-FD<V!]%UC=[/ *&'C&V@.B.@.T[=;J%T#=NQ8M"WC1]O#APWK4C0;Z:Q+=<MH
M'>M2=4U;M^5UJ>9D\Z#<M W9L*K/BGVE856!$&_P' 5KD3JFS:.!(!NS/<1,
M3YLV>)=/@.H^.*29J(KNWZ!)*&_:\:+SI['EU2V$=>UYU75J%97[D3%R:3: ,T
MX*5<B-1XYB5]YA$1[YFQT7TN\2[@./KG!M991[[K+HP8M;,.$;XX?\:E=JQ*B
MOUU-R9*Q0M7E3M_BW!0=VN-3.C^/WE!<,LB!G4Z+D2RI=U64,%FZ591P7LUH
M5$+OEEF5:DBXK.Y60T(M77BV^VRS1D^MU8#MVJQD?<I=?.E64 <)DZ591PN>E
MVZ6V5;ETJR+AXM*MBH0#>?I8TJBF=&E70B)?S(E@.S+5M)I0=]A'OU]VE?!AA
MQ9YV$]8J['O1,WB7(.9,$%'7)0[[WK/]E9"NH$V'+A\TV9C-5R;[#*?=16#U
M6D\W\-K:0=H-M.G6$"^>>;>+,LO,^QN1Y=Q\D6]$$6*W!XP*:'I_9WNR9_#^
M.;Q-;F!>&,QK[\GGA4&$<T_^7DAY#PSFSUX8O'6N+3)A;R.,H2(V'-C^D6IL
MZ\(\BBP/<O:!VA'*\4+R7 ?%>8!B:#Z3\T\</?P4I+8JK6-!\Y*?Y?<-S3MA
M]ZW1-0,C*>6WQ'PB.O'6_"7(;93"U@.VEQ Z"=-[)T:$<H^P.@.S0::SS_1O)^
M;="[A"X<2/XAZEUJVRI/`_(?2 JO@.N<.Z'N<R)5#LRIN(LG($?V4`WGRO:1W
M*->.B&E #R;"!@.UITT<YY?JN/EW@.7Z_DK20IJ:TLU(Z[ WRAM[47]9\=F#@.
M<1V2V<&3[#HZ^%:T]F:E%_Q:/M"2M\+(^Z=\T[2$.OH8KN0([>9'^9L^U1#X
M?JNT))G.$8_TZ9;1U1S+G_^9M>A"KOYJ,(OP2.MY\91&-T4:H275M3-AK3TT
ME[2N7Y_0;);*$27%>HQT]4>YT-H3MT,G<M==C.-U^$D[PKI.FN^9IJ[)3*\_
M<7\>LU19QG[3]/*NY1KN'G"?%\A](M?3<7?"Y^\6RC9BS5,+\D])[0-KU#ZM
MP$EP)JJ=Q\&9,%4;,RMI_8A5-@.B[*5VS!FZ63SRE=208R-F[)RNRF.]U5O^^
M-?!1-:\=UL,+RG)-OU=S_,K:>L;G5.:TGO%$[OG&VGQ%_5K,ETVIG^>Z2LY7
MS.$G@._F\BT)D3.:X6LO5_H-]]&Z+D/!()-B9DV*:&GG%>XOD\WFN:>S>>9!S
M$1+&\UMM]R^9"V:8BY MGM\JV4++_-6HGV]'OGF[$,SFM)Z-SL-:SI-R4QMY
M2 E0JXNW[U'>\]%NA@.P6Y V?F#L6U'V?['ETBNS,JUN=R.O*(SXR$^?M >M
MR);MO1%)I2/T]T$9P8_>62N>*LQO=G>2<G EY5G/_PO3+1]%6L[+DGBY?"/6
MBR]R]C97G4CFL]J;O WR2=L/BIY8E?:/<@.U]GD?:O.1^`,N?,TQ']3&;^8A
M4PK'7$GWE2U ]E0.B#3>$^^LK#N?V4^\"MH`:,<U\_P>I('9\-:*5-Z;*Z.U
M=7X:S6",**V-#?4C'6H=<[Y]]MRR%F)YBF$Z\1&X8XYCOA ^,$Z*HRY'?C&>
MBUC31G"EQ7'5!D=>&_S_@.F.N&D76X)AK)SC;X%/I9#DT.A8*CC%*&A\;;*08
M=5._Z$Z>?^#5Y$X:Q^(SH\9@.]!"]]%7:&HTM;"K7L<&X_:6!_?AS[,G5HYWQ
M)\/QVA[G55<Q<2;G0U_F)[GC2B3__%3+,!:V/(5]:K?:GA/>DTY3X\\=2ZX7
M)NWH%/S@.W\S#'&F;*Z5%R7]ESHC#51N-)]LKZ_6)?(:9+%$X)H<68"#'4^K*
M1Y'C^X+T,(;Y,J@.['<ZM]%>6I.:BHVQ DR8GI-UD^CKB^3(8?5W%8A@.)`8T[
MI^Y?B*;#8L_+936S5[':A_Q_H.WX0;1^E=ZK[QT^VS;_1OOR; [1!C95/X\H5
M1U\QXO2).-*5Z4CX/>'X_\ <SXR!S[:ZT9S95^:#F;=6,-N%54W7++E5K>H]
M=1VEBW3FCYU?,'_,G6ET1(.?L$<;>I#QL?X&RS^-!#J;DQS=7KU3D?8H+HD[
MU)1T#$?[91WSZNPN5:&MGITC3+OW550JSU?&:MI9UK/.IHKZ\-'H&N#95%=9
M=)32&U[Y19Z"?7XNHZ:$F:YT>VDMXS+;#EU_8ZT/9SE#>[IZGN^6/*D_'+;'
MT)*H-J_V--%^OQ9V1NSS?9$K=^:,R-))$:7P2NYX&Y14EI34DERS9_$],;L1
MI300WL]H:\YHDVVF#<W +E]JDR\LIWQ-N6^"TDJ7MFK&Q%Q2,W1L(=39Y%PC
M].Y SO^K,/][_N^(Y?Y!K&/_J6W3_,<FG &_%(W_S#3/B/:*FG=O+H.\(EF;
M1M\;FLSI/,AIEZT-UKJ'7HG.P.V(3MQ3*W<"GU-K_TNCK5^8RP[+%*Q=\OGU
M<D-_3_VVL,\82HUY_\>@.!P/+@.1[ACM'HPTA[IL(!-%AGU6XHW8%(_OSY?P_*
M[ ]SGMJ1[ZN@.-_J1Z5Y0FBMJ$M+4^AI/[XQQ)7I\\0P%L(61#@./:_7"L3,=5
M54-G6WJUG_$Y^F5L[[#M3,<S:O?#4PGAN\46N,6CT!Y!\GO6`:2M& -"[0?0*
M/+ >2Q8KI.=K?IC;.SFK8Q] .AN'LLLT!_31\&9;[2<AEQ?,J1G$H2 >=Y]7
M.XRG03P*UN,A'@.(K^1;%H812).?(T1Z&/E]CH64-GU7VP]B$53.?T5-OY>HK
MQB:\-HB7F#SU158]BYKPBS#V*.P_T-<(QRKT^1.Y]IGU\6RA)QRFE=2AV0B4
M13Y+^/0A>WT'1N-7TDE_Q/;^D0BBD=2HQ7\>CP6MN#?J)T=CR<MST2OAC/ZL
M7B$Z?T\T9-?@.G6OH?X^I54WJ52N(>8+'VJ#6C1C=U C&-'K4PEVYODJODE+,
M]G@.C'WYQ;W=^2K.^2+H8MMFQN9U$&[%._LGZHE)$>X.B+[U:"_# T3P9]6;6@.
MR7NO3.0?A7[3V=+XK##E$]8M^+5A=%:\O['\664MB0X]OI'1<85=HY'_/:,C
M-*>TFPVSSP@.^6!Q$,XUYW.*5+I]![V7_&4_+]E"-[,0;^2#*R[8<JZ,_- H<
M+2!:OW/1HE]%B@.NV?FEX')O?S%6L]ME&$/<?5C%X+*F=F#%M73H[I1C"_B'J
M4?I^69C&D$_/MBZ/'&>(;-ZRL:=E*66I=WFN!HWJ=M766B8EJ](JO&6<E;N"
M+"E9E58_+9:L[+4QD<VIXLJ=J"TO,_9[OD>1/O9[/HILL=^155P>^QU9X4UC
MOZ.4LL5^SWL^6^QWI*M98K_G,V(_]CO,9]-HZ/GII(^I_?)!HZTC:<RQH-
MG3:5M-'028\\:S3T?'XVBX:>G^9ZT=#S_![;T=!A'EFCH</GPYBU8J.AD_8X
MSVCHR&:4%0T=V3Q7HJ%#B:L>#1W*6=5HZ$C+U?Y7.1HZ7B.O3 #PNN5K1T'&[
M5[5HZ'@.K6;5HZ%E[7Z5HZ'DVNNK1T*',VQ<-'?EF;D=#1^WN-D9#1[;&Q6CH
M^?Y?F&Y5HZ&?<UZ6Q,OE&YDJ14-'WJ3]:.@.P[?6CH<,GLT=#1]JP231TF,J!
MT;G[U='04=W9)!HZ3"5=-/3J^8[UHJ'CK:>=:.@.PQ2I$0\_*DC7J..D7;18-
M'6GKYM'045KK1D//>S)--'3$1-9HZ#"%=:.AYSV7+AHZ[G&O&PT=+_GUHJ&C
M7->-AH[\OCRCH9.YY!L-'>9E)QHZ8G;]:.BH9<X2#1WWEM:+AHXLT3J[F$3:
MM_XN)A'2Q?'7FXXI(N*J)]@.Q"[TL,CIJX\N*S8[X3Q^;';6IV?:!B;1^_7U@.
MHF<QK_,N5MZK- QU;&H>$S5C%2=WPKG6A\C+3:_3N+(\=OV/_(1>1C0[A_;O
MEO7^DJ4^KR;NF.=U>R=($6EGB6G4W;?"^,35*2CV<$Y$K::-J"O,=+XP\5AX
MV,+X&$'(>/P<8N?4\EP$<Y;I4/S(=#[2GT/YH#6\9,\C2OLZ\&U^,VDC1H>4
M!/Y+6*J/Q/D8G(FOY]#XX_BY':/1T^%,[I1QMU>,S$6:WP,YM6^>3B);,="A
MUNJLX4>6-<KL:PY:C+__`U!+`0(4`!0````(`" U<S"G1B5GTUX``%2!!P`+
M``````````$`( "V@.0````!-4T1%3&]G+FQO9U!+!08``````0`!`#D```#\
%7@.``````
`
end
I had the same error (1603)
The problem was that i tried to install over remote desktop.
It even failed if i tried it local but used remote desktop before
to access the machine. So i had to reboot, login directly at
the machine and installation worked.
I could reproduce that several times.
Ingo
|||Thanks
I'll see if this helps
"Ingo Eichenseher" <Mister_I@.gmx.de> wrote in message
news:%23YtWC20EEHA.2408@.TK2MSFTNGP10.phx.gbl...
> I had the same error (1603)
> The problem was that i tried to install over remote desktop.
> It even failed if i tried it local but used remote desktop before
> to access the machine. So i had to reboot, login directly at
> the machine and installation worked.
> I could reproduce that several times.
> Ingo
>
Monday, March 12, 2012
Failed Backup Error Message SQL 2000
database.
3041 :
BACKUP failed to complete the command BACKUP DATABASE [Data] TO DISK =
N'd:\data\MSSQL\BACKUP\Data\Data_db_200502160202.B AK' WITH INIT , NOUNLOAD
, NOSKIP , STATS = 10, NOFORMAT
www.synecology.com
If you check the SQL server error log you should see a message just before
this one that should have some further detail on why it is failing. If you
run it through QA do you get additional error messages ?
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ed Grossman" <VermontMCP@.community.nospam> wrote in message
news:56CF5A32-B0BC-45D8-879A-39CFFDD1873C@.microsoft.com...
>I continually receive the following error when trying to backup the one
> database.
> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [Data] TO DISK =
> N'd:\data\MSSQL\BACKUP\Data\Data_db_200502160202.B AK' WITH INIT ,
> NOUNLOAD
> , NOSKIP , STATS = 10, NOFORMAT
> --
> www.synecology.com
|||Here is the previous error message:
SPID 55
Internal I/O request 0x05BC0C18: Op: Write, pBuffer: 0x063E0000, Size:
983040, Position: 3707020800, UMS: Internal: 0x103, InternalHigh: 0x0,
Offset: 0xDCF4A600, OffsetHigh: 0x0, m_buf: 0x063E0000, m_len: 983040,
m_actualBytes: 0, m_errcode: 112, BackupFile:
L:\SQLDatabaseBackups\Data_db_200501090201.BAK
There was a space issue, but that has been resolved.
"Jasper Smith" wrote:
> If you check the SQL server error log you should see a message just before
> this one that should have some further detail on why it is failing. If you
> run it through QA do you get additional error messages ?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Ed Grossman" <VermontMCP@.community.nospam> wrote in message
> news:56CF5A32-B0BC-45D8-879A-39CFFDD1873C@.microsoft.com...
>
>
|||And you see the same errors when running it through Query Analyzer? Is it
possible to try writing the backup to a different drive just to see if that
has any effect?
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ed Grossman" <VermontMCP@.community.nospam> wrote in message
news:9DB9C460-40FC-4084-B426-FD3F1F64D109@.microsoft.com...[vbcol=seagreen]
> Here is the previous error message:
> SPID 55
> Internal I/O request 0x05BC0C18: Op: Write, pBuffer: 0x063E0000, Size:
> 983040, Position: 3707020800, UMS: Internal: 0x103, InternalHigh: 0x0,
> Offset: 0xDCF4A600, OffsetHigh: 0x0, m_buf: 0x063E0000, m_len: 983040,
> m_actualBytes: 0, m_errcode: 112, BackupFile:
> L:\SQLDatabaseBackups\Data_db_200501090201.BAK
> There was a space issue, but that has been resolved.
> "Jasper Smith" wrote:
|||I just ran the backup after cleaning up the 2 drives that had space issues.
and received no errors.
Is it possible that the failed backup could change the database to single
user mode?
"Jasper Smith" wrote:
> And you see the same errors when running it through Query Analyzer? Is it
> possible to try writing the backup to a different drive just to see if that
> has any effect?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Ed Grossman" <VermontMCP@.community.nospam> wrote in message
> news:9DB9C460-40FC-4084-B426-FD3F1F64D109@.microsoft.com...
>
>
|||A backup failure should have no effect on the recovery model of the
database. However, maintenance plans did in the past have a habit of leaving
databases in single user mode if you had the "Attempt to repair minor
problems" option selected although I believe this should be fixed by now in
one of the service packs
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ed Grossman" <VermontMCP@.community.nospam> wrote in message
news:A03F1658-EDFF-4DE3-8653-65AAE6EEF38B@.microsoft.com...[vbcol=seagreen]
>I just ran the backup after cleaning up the 2 drives that had space issues.
> and received no errors.
> Is it possible that the failed backup could change the database to single
> user mode?
>
> "Jasper Smith" wrote:
Failed Backup Error Message SQL 2000
database.
3041 :
BACKUP failed to complete the command BACKUP DATABASE [Data] TO DISK = N'd:\data\MSSQL\BACKUP\Data\Data_db_200502160202.BAK' WITH INIT , NOUNLOAD
, NOSKIP , STATS = 10, NOFORMAT
--
www.synecology.comIf you check the SQL server error log you should see a message just before
this one that should have some further detail on why it is failing. If you
run it through QA do you get additional error messages ?
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ed Grossman" <VermontMCP@.community.nospam> wrote in message
news:56CF5A32-B0BC-45D8-879A-39CFFDD1873C@.microsoft.com...
>I continually receive the following error when trying to backup the one
> database.
> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [Data] TO DISK => N'd:\data\MSSQL\BACKUP\Data\Data_db_200502160202.BAK' WITH INIT ,
> NOUNLOAD
> , NOSKIP , STATS = 10, NOFORMAT
> --
> www.synecology.com|||Here is the previous error message:
SPID 55
Internal I/O request 0x05BC0C18: Op: Write, pBuffer: 0x063E0000, Size:
983040, Position: 3707020800, UMS: Internal: 0x103, InternalHigh: 0x0,
Offset: 0xDCF4A600, OffsetHigh: 0x0, m_buf: 0x063E0000, m_len: 983040,
m_actualBytes: 0, m_errcode: 112, BackupFile:
L:\SQLDatabaseBackups\Data_db_200501090201.BAK
There was a space issue, but that has been resolved.
"Jasper Smith" wrote:
> If you check the SQL server error log you should see a message just before
> this one that should have some further detail on why it is failing. If you
> run it through QA do you get additional error messages ?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Ed Grossman" <VermontMCP@.community.nospam> wrote in message
> news:56CF5A32-B0BC-45D8-879A-39CFFDD1873C@.microsoft.com...
> >I continually receive the following error when trying to backup the one
> > database.
> >
> > 3041 :
> > BACKUP failed to complete the command BACKUP DATABASE [Data] TO DISK => > N'd:\data\MSSQL\BACKUP\Data\Data_db_200502160202.BAK' WITH INIT ,
> > NOUNLOAD
> > , NOSKIP , STATS = 10, NOFORMAT
> > --
> > www.synecology.com
>
>|||And you see the same errors when running it through Query Analyzer? Is it
possible to try writing the backup to a different drive just to see if that
has any effect?
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ed Grossman" <VermontMCP@.community.nospam> wrote in message
news:9DB9C460-40FC-4084-B426-FD3F1F64D109@.microsoft.com...
> Here is the previous error message:
> SPID 55
> Internal I/O request 0x05BC0C18: Op: Write, pBuffer: 0x063E0000, Size:
> 983040, Position: 3707020800, UMS: Internal: 0x103, InternalHigh: 0x0,
> Offset: 0xDCF4A600, OffsetHigh: 0x0, m_buf: 0x063E0000, m_len: 983040,
> m_actualBytes: 0, m_errcode: 112, BackupFile:
> L:\SQLDatabaseBackups\Data_db_200501090201.BAK
> There was a space issue, but that has been resolved.
> "Jasper Smith" wrote:
>> If you check the SQL server error log you should see a message just
>> before
>> this one that should have some further detail on why it is failing. If
>> you
>> run it through QA do you get additional error messages ?
>> --
>> HTH
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>> "Ed Grossman" <VermontMCP@.community.nospam> wrote in message
>> news:56CF5A32-B0BC-45D8-879A-39CFFDD1873C@.microsoft.com...
>> >I continually receive the following error when trying to backup the one
>> > database.
>> >
>> > 3041 :
>> > BACKUP failed to complete the command BACKUP DATABASE [Data] TO DISK =>> > N'd:\data\MSSQL\BACKUP\Data\Data_db_200502160202.BAK' WITH INIT ,
>> > NOUNLOAD
>> > , NOSKIP , STATS = 10, NOFORMAT
>> > --
>> > www.synecology.com
>>|||I just ran the backup after cleaning up the 2 drives that had space issues.
and received no errors.
Is it possible that the failed backup could change the database to single
user mode?
"Jasper Smith" wrote:
> And you see the same errors when running it through Query Analyzer? Is it
> possible to try writing the backup to a different drive just to see if that
> has any effect?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Ed Grossman" <VermontMCP@.community.nospam> wrote in message
> news:9DB9C460-40FC-4084-B426-FD3F1F64D109@.microsoft.com...
> > Here is the previous error message:
> > SPID 55
> > Internal I/O request 0x05BC0C18: Op: Write, pBuffer: 0x063E0000, Size:
> > 983040, Position: 3707020800, UMS: Internal: 0x103, InternalHigh: 0x0,
> > Offset: 0xDCF4A600, OffsetHigh: 0x0, m_buf: 0x063E0000, m_len: 983040,
> > m_actualBytes: 0, m_errcode: 112, BackupFile:
> > L:\SQLDatabaseBackups\Data_db_200501090201.BAK
> >
> > There was a space issue, but that has been resolved.
> >
> > "Jasper Smith" wrote:
> >
> >> If you check the SQL server error log you should see a message just
> >> before
> >> this one that should have some further detail on why it is failing. If
> >> you
> >> run it through QA do you get additional error messages ?
> >>
> >> --
> >> HTH
> >>
> >> Jasper Smith (SQL Server MVP)
> >> http://www.sqldbatips.com
> >> I support PASS - the definitive, global
> >> community for SQL Server professionals -
> >> http://www.sqlpass.org
> >>
> >> "Ed Grossman" <VermontMCP@.community.nospam> wrote in message
> >> news:56CF5A32-B0BC-45D8-879A-39CFFDD1873C@.microsoft.com...
> >> >I continually receive the following error when trying to backup the one
> >> > database.
> >> >
> >> > 3041 :
> >> > BACKUP failed to complete the command BACKUP DATABASE [Data] TO DISK => >> > N'd:\data\MSSQL\BACKUP\Data\Data_db_200502160202.BAK' WITH INIT ,
> >> > NOUNLOAD
> >> > , NOSKIP , STATS = 10, NOFORMAT
> >> > --
> >> > www.synecology.com
> >>
> >>
> >>
>
>|||A backup failure should have no effect on the recovery model of the
database. However, maintenance plans did in the past have a habit of leaving
databases in single user mode if you had the "Attempt to repair minor
problems" option selected although I believe this should be fixed by now in
one of the service packs
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ed Grossman" <VermontMCP@.community.nospam> wrote in message
news:A03F1658-EDFF-4DE3-8653-65AAE6EEF38B@.microsoft.com...
>I just ran the backup after cleaning up the 2 drives that had space issues.
> and received no errors.
> Is it possible that the failed backup could change the database to single
> user mode?
>
> "Jasper Smith" wrote:
>> And you see the same errors when running it through Query Analyzer? Is it
>> possible to try writing the backup to a different drive just to see if
>> that
>> has any effect?
>> --
>> HTH
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>> "Ed Grossman" <VermontMCP@.community.nospam> wrote in message
>> news:9DB9C460-40FC-4084-B426-FD3F1F64D109@.microsoft.com...
>> > Here is the previous error message:
>> > SPID 55
>> > Internal I/O request 0x05BC0C18: Op: Write, pBuffer: 0x063E0000, Size:
>> > 983040, Position: 3707020800, UMS: Internal: 0x103, InternalHigh: 0x0,
>> > Offset: 0xDCF4A600, OffsetHigh: 0x0, m_buf: 0x063E0000, m_len: 983040,
>> > m_actualBytes: 0, m_errcode: 112, BackupFile:
>> > L:\SQLDatabaseBackups\Data_db_200501090201.BAK
>> >
>> > There was a space issue, but that has been resolved.
>> >
>> > "Jasper Smith" wrote:
>> >
>> >> If you check the SQL server error log you should see a message just
>> >> before
>> >> this one that should have some further detail on why it is failing. If
>> >> you
>> >> run it through QA do you get additional error messages ?
>> >>
>> >> --
>> >> HTH
>> >>
>> >> Jasper Smith (SQL Server MVP)
>> >> http://www.sqldbatips.com
>> >> I support PASS - the definitive, global
>> >> community for SQL Server professionals -
>> >> http://www.sqlpass.org
>> >>
>> >> "Ed Grossman" <VermontMCP@.community.nospam> wrote in message
>> >> news:56CF5A32-B0BC-45D8-879A-39CFFDD1873C@.microsoft.com...
>> >> >I continually receive the following error when trying to backup the
>> >> >one
>> >> > database.
>> >> >
>> >> > 3041 :
>> >> > BACKUP failed to complete the command BACKUP DATABASE [Data] TO
>> >> > DISK =>> >> > N'd:\data\MSSQL\BACKUP\Data\Data_db_200502160202.BAK' WITH INIT ,
>> >> > NOUNLOAD
>> >> > , NOSKIP , STATS = 10, NOFORMAT
>> >> > --
>> >> > www.synecology.com
>> >>
>> >>
>> >>
>>
Failed Backup Error Message SQL 2000
database.
3041 :
BACKUP failed to complete the command BACKUP DATABASE [Data] TO DISK =
N'd:\data\MSSQL\BACKUP\Data\Data_db_2005
02160202.BAK' WITH INIT , NOUNLOAD
, NOSKIP , STATS = 10, NOFORMAT
--
www.synecology.comIf you check the SQL server error log you should see a message just before
this one that should have some further detail on why it is failing. If you
run it through QA do you get additional error messages ?
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ed Grossman" <VermontMCP@.community.nospam> wrote in message
news:56CF5A32-B0BC-45D8-879A-39CFFDD1873C@.microsoft.com...
>I continually receive the following error when trying to backup the one
> database.
> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [Data] TO DISK
=
> N'd:\data\MSSQL\BACKUP\Data\Data_db_2005
02160202.BAK' WITH INIT ,
> NOUNLOAD
> , NOSKIP , STATS = 10, NOFORMAT
> --
> www.synecology.com|||Here is the previous error message:
SPID 55
Internal I/O request 0x05BC0C18: Op: Write, pBuffer: 0x063E0000, Size:
983040, Position: 3707020800, UMS: Internal: 0x103, InternalHigh: 0x0,
Offset: 0xDCF4A600, OffsetHigh: 0x0, m_buf: 0x063E0000, m_len: 983040,
m_actualBytes: 0, m_errcode: 112, BackupFile:
L:\SQLDatabaseBackups\Data_db_2005010902
01.BAK
There was a space issue, but that has been resolved.
"Jasper Smith" wrote:
> If you check the SQL server error log you should see a message just before
> this one that should have some further detail on why it is failing. If you
> run it through QA do you get additional error messages ?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Ed Grossman" <VermontMCP@.community.nospam> wrote in message
> news:56CF5A32-B0BC-45D8-879A-39CFFDD1873C@.microsoft.com...
>
>|||And you see the same errors when running it through Query Analyzer? Is it
possible to try writing the backup to a different drive just to see if that
has any effect?
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ed Grossman" <VermontMCP@.community.nospam> wrote in message
news:9DB9C460-40FC-4084-B426-FD3F1F64D109@.microsoft.com...[vbcol=seagreen]
> Here is the previous error message:
> SPID 55
> Internal I/O request 0x05BC0C18: Op: Write, pBuffer: 0x063E0000, Size:
> 983040, Position: 3707020800, UMS: Internal: 0x103, InternalHigh: 0x0,
> Offset: 0xDCF4A600, OffsetHigh: 0x0, m_buf: 0x063E0000, m_len: 983040,
> m_actualBytes: 0, m_errcode: 112, BackupFile:
> L:\SQLDatabaseBackups\Data_db_2005010902
01.BAK
> There was a space issue, but that has been resolved.
> "Jasper Smith" wrote:
>|||I just ran the backup after cleaning up the 2 drives that had space issues.
and received no errors.
Is it possible that the failed backup could change the database to single
user mode?
"Jasper Smith" wrote:
> And you see the same errors when running it through Query Analyzer? Is it
> possible to try writing the backup to a different drive just to see if tha
t
> has any effect?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Ed Grossman" <VermontMCP@.community.nospam> wrote in message
> news:9DB9C460-40FC-4084-B426-FD3F1F64D109@.microsoft.com...
>
>|||A backup failure should have no effect on the recovery model of the
database. However, maintenance plans did in the past have a habit of leaving
databases in single user mode if you had the "Attempt to repair minor
problems" option selected although I believe this should be fixed by now in
one of the service packs
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ed Grossman" <VermontMCP@.community.nospam> wrote in message
news:A03F1658-EDFF-4DE3-8653-65AAE6EEF38B@.microsoft.com...[vbcol=seagreen]
>I just ran the backup after cleaning up the 2 drives that had space issues.
> and received no errors.
> Is it possible that the failed backup could change the database to single
> user mode?
>
> "Jasper Smith" wrote:
>
Friday, March 9, 2012
Fail to read entire table in .NET
The problem that I am having is that I am not getting the results from an entire table, just a small subset. The sql command is "Select * from login", which has always implied to me, get everything, to end of table, or, until I tell you to stop. I am getting exactly, 10 items as input, and then it stops. I am including the code below in the hopes that someone can spot what it is that I am doing wrong.
The purpose of the routine is to convert a user login database into a new, expanded format.
TIA, Tom
Imports Common.Utility.Utils
Partial Class UserDatabaseConversion
Inherits System.Web.UI.Page
Dim sqlConn As SqlConnection = getSQLConnection(ConfigurationManager.AppSettings("utilityDbName"))
Dim sqlConnN As SqlConnection = getSQLConnection(ConfigurationManager.AppSettings("utilityDbName"))
Dim sqlStringOld As String = "Select * from login"
Dim sqlStringNew As String = "usp_UT_AddNewUser"
Dim buildCnt As Integer = 0
Dim oldUserCnt As Integer = 0
Dim newUserCnt As Integer = 0
Dim oLocation As String = Nothing
Dim errors As Integer = 0
Dim mesg As String = Nothing
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
getOldUsers()
End Sub
Sub getOldUsers()
Dim odate As Date = Date.Today
Dim sqlCmdOld As SqlCommand = New SqlCommand()
sqlCmdOld.CommandText = sqlStringOld
sqlCmdOld.CommandType = CommandType.Text
sqlCmdOld.Connection = sqlConn
Dim dbReader As SqlDataReader = Nothing
Try
sqlConn.Open()
dbReader = sqlCmdOld.ExecuteReader()
If dbReader.HasRows Then
Do While dbReader.Read()
oldUserCnt += 1
Select Case IsDBNull(dbReader.Item("reg_date"))
Case True
buildNewUser(dbReader.Item("name"), dbReader.Item("password"), dbReader.Item("email"), dbReader.Item("type"), dbReader.Item("org"), dbReader.Item("occupation"), dbReader.Item("location"), odate)
Case False
buildNewUser(dbReader.Item("name"), dbReader.Item("password"), dbReader.Item("email"), dbReader.Item("type"), dbReader.Item("org"), dbReader.Item("occupation"), dbReader.Item("location"), dbReader.Item("reg_date"))
End Select
Loop
End If
Catch ex As Exception
Finally
sqlConn.Dispose()
End Try
If errors = 0 Then
lblMesg.Text = "Conversion completed succesfully.<br />Users In: " & oldUserCnt & " , Users Out:" & newUserCnt
Else
lblMesg.Text = "Conversion comleted with errors.<br />Users In: " & oldUserCnt & " , Users Out:" & newUserCnt & "<br />"
lblMesg.Text += mesg
End If
End Sub
Sub buildNewUser(ByVal oname As String, ByVal opassword As String, _
ByVal oemail As String, ByVal otype As String, _
ByVal oorg As String, ByVal oocc As String, _
ByVal oloc As String, ByVal oregdate As Date)
Dim sqlCmdNew As SqlCommand = New SqlCommand()
sqlCmdNew.CommandText = sqlStringNew
sqlCmdNew.CommandType = CommandType.StoredProcedure
sqlCmdNew.Connection = sqlConnN
Dim userName As String = Nothing
Dim firstName As String = Nothing
Dim middleName As String = Nothing
Dim lastName As String = Nothing
Dim title As String = Nothing
Dim emailAddress As String = Nothing
Dim passWord As String = Nothing
Dim userType As String = Nothing
Dim org As String = Nothing
Dim occ As String = Nothing
Dim loc As String = Nothing
Dim rdate As Date = Nothing
oLocation = oloc
' user name will be the first part of the email address
emailAddress = oemail
Dim uname() As String = oemail.Split("@.")
' extend the length of the user name to at least 5 characters
Select Case uname(0).Length
Case Is > 4
userName = uname(0)
Case Is = 4
userName = uname(0) & "1"
Case Is = 3
userName = uname(0) & "12"
Case Is = 2
userName = uname(0) & "123"
Case Is = 1
userName = uname(0) & "1234"
End Select
' check for suffixes
Dim suffix() As String = oname.Split(",")
Select Case suffix.Length > 1
Case True
title = suffix(1)
End Select
' split names out
Dim names() As String = suffix(0).Split(" ")
' possibly 3 components to the name
Select Case names.Length
Case Is = 1
firstName = names(0)
Case Is = 2
firstName = names(0)
lastName = names(1)
Case Is = 3
firstName = names(0)
middleName = names(1)
lastName = names(2)
End Select
' setup password. must be at least 6 characters.
' if less, extend to 6.
Select Case opassword
Case Is > 5
passWord = opassword
Case Is = 5
passWord = opassword & "1"
Case Is = 4
passWord = opassword & "12"
Case Is = 3
passWord = opassword & "123"
Case Is = 2
passWord = opassword & "1234"
Case Is = 1
passWord = opassword & "12345"
End Select
' user type, organization and occupation
userType = otype
org = oorg
occ = oocc
' registration date
Select Case IsDBNull(oregdate) Or IsNothing(oregdate)
Case True
rdate = Today.Date
Case False
rdate = oregdate
End Select
' try to extract the location
' get the country
Dim country As String = getCountry(oloc)
' get the state
Dim state As String = getState(oloc)
' only thing left is the city
Dim city() As String = oloc.Split(",")
' add parameter values
sqlCmdNew.Parameters.AddWithValue("@.NamePrefix", System.DBNull.Value)
sqlCmdNew.Parameters.AddWithValue("@.FirstName", replaceSingleQuote(firstName))
Select Case IsNothing(middleName)
Case True
sqlCmdNew.Parameters.AddWithValue("@.MiddleName", System.DBNull.Value)
Case False
sqlCmdNew.Parameters.AddWithValue("@.MiddleName", replaceSingleQuote(middleName))
End Select
Select Case IsNothing(lastName)
Case True
sqlCmdNew.Parameters.AddWithValue("@.LastName", System.DBNull.Value)
Case False
sqlCmdNew.Parameters.AddWithValue("@.LastName", replaceSingleQuote(lastName))
End Select
sqlCmdNew.Parameters.AddWithValue("@.UserName", replaceSingleQuote(userName))
Select Case IsNothing(title)
Case True
sqlCmdNew.Parameters.AddWithValue("@.NameTitle", System.DBNull.Value)
Case False
sqlCmdNew.Parameters.AddWithValue("@.NameTitle", title)
End Select
sqlCmdNew.Parameters.AddWithValue("@.Password", replaceSingleQuote(passWord))
sqlCmdNew.Parameters.AddWithValue("@.EmailAddress", emailAddress)
sqlCmdNew.Parameters.AddWithValue("@.PasswordHint", userName)
Select Case isEmpty(org)
Case True
sqlCmdNew.Parameters.AddWithValue("@.Organization", System.DBNull.Value)
Case False
sqlCmdNew.Parameters.AddWithValue("@.Organization", replaceSingleQuote(org))
End Select
Select Case isEmpty(occ)
Case True
sqlCmdNew.Parameters.AddWithValue("@.Occupation", System.DBNull.Value)
Case False
sqlCmdNew.Parameters.AddWithValue("@.Occupation", replaceSingleQuote(occ))
End Select
sqlCmdNew.Parameters.AddWithValue("@.Address1", System.DBNull.Value)
sqlCmdNew.Parameters.AddWithValue("@.Address2", System.DBNull.Value)
Select Case isEmpty(city(0))
Case True
sqlCmdNew.Parameters.AddWithValue("@.City", System.DBNull.Value)
Case False
sqlCmdNew.Parameters.AddWithValue("@.City", replaceSingleQuote(city(0)))
End Select
sqlCmdNew.Parameters.AddWithValue("@.ZipCode", System.DBNull.Value)
sqlCmdNew.Parameters.AddWithValue("@.PostalCode", System.DBNull.Value)
Select Case IsNothing(state)
Case True
sqlCmdNew.Parameters.AddWithValue("@.State", System.DBNull.Value)
Case False
sqlCmdNew.Parameters.AddWithValue("@.State", state)
End Select
sqlCmdNew.Parameters.AddWithValue("@.Other", System.DBNull.Value)
Select Case IsNothing(country)
Case True
sqlCmdNew.Parameters.AddWithValue("@.Country", System.DBNull.Value)
Case False
sqlCmdNew.Parameters.AddWithValue("@.Country", country)
End Select
sqlCmdNew.Parameters.AddWithValue("@.GeneralEmail", False)
sqlCmdNew.Parameters.AddWithValue("@.FundRaiseEmail", False)
sqlCmdNew.Parameters.AddWithValue("@.GeneralUSPSMail", False)
sqlCmdNew.Parameters.AddWithValue("@.FundRaiseUSPSMail", False)
sqlCmdNew.Parameters.AddWithValue("@.DateAdded", rdate)
sqlCmdNew.Parameters.AddWithValue("@.DateUpdated", rdate)
sqlCmdNew.Parameters.AddWithValue("@.Active", True)
sqlCmdNew.Parameters.AddWithValue("@.UserType", userType)
Dim iRows As Integer = 0
' try to insert the row into the table
Try
sqlConnN.Open()
iRows = sqlCmdNew.ExecuteNonQuery()
If iRows <> 1 Then
errors += 1
mesg += "<br />User: " & firstName & " " & lastName & " was not added.<br />"
End If
newUserCnt += 1
Catch ex As Exception
Dim exMsg As String = ex.Message.ToString()
writeApplicationLog(exMsg, ConfigurationManager.AppSettings("UtilityDBName"))
errors += 1
mesg += "<br />User: " & firstName & " " & lastName & " was not added due to " & exMsg & "<br />"
Finally
sqlConnN.Close()
sqlCmdNew.Dispose()
End Try
End Sub
Function getState(ByVal loc As String) As String
Dim state As String = Nothing
If loc.Contains("NY") Then
state = "NY"
ElseIf loc.Contains("WA") Then
state = "WA"
ElseIf loc.Contains("PA") Then
state = "PA"
ElseIf loc.Contains("AZ") Then
state = "AZ"
ElseIf loc.Contains("MI") Then
state = "MI"
ElseIf loc.Contains("WI") Then
state = "WI"
ElseIf loc.Contains("CT") Then
state = "CT"
ElseIf loc.Contains("NC") Then
state = "NC"
ElseIf loc.Contains("CA") Then
state = "CA"
ElseIf loc.Contains("NY") Then
state = "NJ"
End If
Return state
End Function
Function getCountry(ByVal cntry As String) As String
Dim country As String = "US"
If cntry.Contains("Canada") Then
country = "CA"
End If
Return country
End Function
End Class
To All and Sundry. Ignore the post please. It is amazing what trying to pass nulls into a string variable can do for you. I thought I knew better by now.
NOT!
Sorry, T
Sunday, February 19, 2012
Extracting the date from a datetime value
Is there a single command to extract the whole date part (day, month and
year) from a datetime value?
I have come across the Datepart function, which allows to extract, the day
or month or year depending on the parameters passed to it. Converting all of
the above to string, concatenating all the strings and converting to datetim
e
datatype seems to be a long procedure. Is there any other way to do this?
Thanks.
kdkd
SELECT CONVERT(CHAR(10),GETDATE(),121)
Note : take a look at 'style' the third parameter of the function
"kd" <kd@.discussions.microsoft.com> wrote in message
news:F330C878-4B5A-406C-B17B-7757CA603668@.microsoft.com...
> Hi,
> Is there a single command to extract the whole date part (day, month and
> year) from a datetime value?
> I have come across the Datepart function, which allows to extract, the day
> or month or year depending on the parameters passed to it. Converting all
of
> the above to string, concatenating all the strings and converting to
datetime
> datatype seems to be a long procedure. Is there any other way to do this?
> Thanks.
> kd|||Hi
Just go through this. This might be helpful
http://msdn.microsoft.com/library/d...br />
2f3o.asp
thanks and regards
Chandra
"kd" wrote:
> Hi,
> Is there a single command to extract the whole date part (day, month and
> year) from a datetime value?
> I have come across the Datepart function, which allows to extract, the day
> or month or year depending on the parameters passed to it. Converting all
of
> the above to string, concatenating all the strings and converting to datet
ime
> datatype seems to be a long procedure. Is there any other way to do this?
> Thanks.
> kd|||Here you go.
SELECT CONVERT(NVARCHAR, GETDATE(), 103)
Style 103 is the british/french output stype which gives you the following
output:
03/05/2005
Now to do this in the mm/dd/yy output you would do it as followed:
SELECT CONVERT(NVARCHAR, GETDATE(), 101)
Which gives you the output of:
05/03/2005
Just open books online and in search box type "convert date style" which
will give you the first returned results of "cast and convert" in transact
sql ,this shows you serveral was to convert the date into specific output
formats. Just pick one that is easiest for you to work with. The first one
I
listed above gives you exactly what you were asking for.
Hope this helps.
"kd" wrote:
> Hi,
> Is there a single command to extract the whole date part (day, month and
> year) from a datetime value?
> I have come across the Datepart function, which allows to extract, the day
> or month or year depending on the parameters passed to it. Converting all
of
> the above to string, concatenating all the strings and converting to datet
ime
> datatype seems to be a long procedure. Is there any other way to do this?
> Thanks.
> kd|||This will give the date part of @.dt as a datetime value, without
requiring any conversions to character formats.
dateadd(day,datediff(day,0,@.dt),0)
Steve Kass
Drew University
kd wrote:
>Hi,
>Is there a single command to extract the whole date part (day, month and
>year) from a datetime value?
>I have come across the Datepart function, which allows to extract, the day
>or month or year depending on the parameters passed to it. Converting all o
f
>the above to string, concatenating all the strings and converting to dateti
me
>datatype seems to be a long procedure. Is there any other way to do this?
>Thanks.
>kd
>|||The convert() solutiions presented all convert the datetime value to a
string, and truncate the characters representing the time portion...
Another option to add to your bag of tricks relies on the fact that
DateTimes are stored internally as two integers, which present as a decimal,
the integer portion of which is the date, and the fractional portion of whic
h
is the time. So if you just strip off the fractional portion, you have a
date by itself.
Set NoCount On
Declare @.D DateTime Set @.D = '20050503 14:23:12'
Select @.D OrigDate
Set @.D = Floor(Cast(@.D As Float))
Select @.D ChangedDate"kd" wrote:
> Hi,
> Is there a single command to extract the whole date part (day, month and
> year) from a datetime value?
> I have come across the Datepart function, which allows to extract, the day
> or month or year depending on the parameters passed to it. Converting all
of
> the above to string, concatenating all the strings and converting to datet
ime
> datatype seems to be a long procedure. Is there any other way to do this?
> Thanks.
> kd|||While your solution works, it is not based on the internal
representation of datetime (and that's probably a good thing).
Converting datetime to float and back is a lot of work, and
your example converts 0x0000964900ED15C0 to
0x40E2C9332EA61D95, then applies floor to yield
0x40E2C92000000000, then converts back to the internal
datetime value 0x0000964900000000.
The basis for your solution is the interpretation SQL Server
provides to the user who is asking for a numerical value for
a datetime - SQL Server presents and understands numbers
as dates in terms of number of days from January 1, 1900.
That's part of the abstraction seen by users, and has nothing
to do with the implemenation. Your solution only needs
the cast from datetime to float and vice versa to work as
documented, which it should regardless of the internals.
A (less wise) solution that does depend on the 8-byte
(calling it two-integer is a stretch - bytes are bytes)
implementation of datetime values could use
Substring(Cast(@.D As Binary(8)),1,4)+0x00000000
In any case, I think it's best to avoid implicit and explicit
conversions altogether, except for the one that converts
something typed in the query into a datetime value. I think
it was Gert-Jan who did some testing and found that this
is faster, too.
dateadd(d,datediff(d,0,@.D),0)
SK
CBretana wrote:
>The convert() solutiions presented all convert the datetime value to a
>string, and truncate the characters representing the time portion...
>Another option to add to your bag of tricks relies on the fact that
>DateTimes are stored internally as two integers, which present as a decimal
,
>the integer portion of which is the date, and the fractional portion of whi
ch
>is the time. So if you just strip off the fractional portion, you have a
>date by itself.
>Set NoCount On
>Declare @.D DateTime Set @.D = '20050503 14:23:12'
>Select @.D OrigDate
>Set @.D = Floor(Cast(@.D As Float))
>Select @.D ChangedDate"kd" wrote:
>
>|||Actually it sets the time to midnight that day. And depending on the
appliation you are using to view it it may shoul 12:00 PM in additon to the
date.
KD the real question is what do you intend to do with it? Is it for use in a
query or for presentation, if for presentation and you have mixed locals
where the standard date format i different then it is many times better to d
o
on the client side fo distributed apps. If web based then you need to take
into their local the proper format or opt for a specific format that you can
enforce.
"Steve Kass" wrote:
> This will give the date part of @.dt as a datetime value, without
> requiring any conversions to character formats.
> dateadd(day,datediff(day,0,@.dt),0)
> Steve Kass
> Drew University
> kd wrote:
>
>|||Steve,
I never thought to directly read the binary values and see what they
were... Thisis interesting... The binary value of '20050503 14:23:12' is
0x00009649 00ED15C0 -- I separated high 4 bytes from Low 4 bytes
If you take the high 4 bytes, 0x9649, that is indeed hex for 38,473,
( 9*16*16*16 + 6*16*16 + 4*16 + 9), which is integer for May 3rd 2005, but
no matter what I do, I can't figure out what SQL is doing with the low 4
bytes...
0x00ED15C0 hex is decimal 15,537,600. which is only .1798333333 of a full
24 hour day (86,400,000 millesconds) and it should be 51,791,971
(0.599444111110 of a 24 hr day).
The only thing I'm not clear on is why Casting to a Float should be
"expensive"... Is it because the system has to convert the binary data into
a
binary IEEE Mantissa/Exponent structure? I would have thought that would be
fairly performant, because it's a binary represeentation, which I "imagine"
all computers would somehow be internally optimized for, outside the scope o
f
whatever software was initiating this task. Not so? Why Not? (if you know
!)
Anyway,
"Steve Kass" wrote:
> While your solution works, it is not based on the internal
> representation of datetime (and that's probably a good thing).
> Converting datetime to float and back is a lot of work, and
> your example converts 0x0000964900ED15C0 to
> 0x40E2C9332EA61D95, then applies floor to yield
> 0x40E2C92000000000, then converts back to the internal
> datetime value 0x0000964900000000.
> The basis for your solution is the interpretation SQL Server
> provides to the user who is asking for a numerical value for
> a datetime - SQL Server presents and understands numbers
> as dates in terms of number of days from January 1, 1900.
> That's part of the abstraction seen by users, and has nothing
> to do with the implemenation. Your solution only needs
> the cast from datetime to float and vice versa to work as
> documented, which it should regardless of the internals.
> A (less wise) solution that does depend on the 8-byte
> (calling it two-integer is a stretch - bytes are bytes)
> implementation of datetime values could use
> Substring(Cast(@.D As Binary(8)),1,4)+0x00000000
> In any case, I think it's best to avoid implicit and explicit
> conversions altogether, except for the one that converts
> something typed in the query into a datetime value. I think
> it was Gert-Jan who did some testing and found that this
> is faster, too.
> dateadd(d,datediff(d,0,@.D),0)
> SK
> CBretana wrote:
>
>|||I think this is the thread that Steve is referring to:
http://groups.google.nl/groups?hl=n...>
dy.nl&rnum=4
(url may wrap)
HTH,
Gert-Jan
CBretana wrote:
> Steve,
> I never thought to directly read the binary values and see what they
> were... Thisis interesting... The binary value of '20050503 14:23:12' is
> 0x00009649 00ED15C0 -- I separated high 4 bytes from Low 4 bytes
> If you take the high 4 bytes, 0x9649, that is indeed hex for 38,473,
> ( 9*16*16*16 + 6*16*16 + 4*16 + 9), which is integer for May 3rd 2005, bu
t
> no matter what I do, I can't figure out what SQL is doing with the low 4
> bytes...
> 0x00ED15C0 hex is decimal 15,537,600. which is only .1798333333 of a full
> 24 hour day (86,400,000 millesconds) and it should be 51,791,971
> (0.599444111110 of a 24 hr day).
> The only thing I'm not clear on is why Casting to a Float should be
> "expensive"... Is it because the system has to convert the binary data int
o a
> binary IEEE Mantissa/Exponent structure? I would have thought that would
be
> fairly performant, because it's a binary represeentation, which I "imagine
"
> all computers would somehow be internally optimized for, outside the scope
of
> whatever software was initiating this task. Not so? Why Not? (if you kn
ow!)
> Anyway,
> "Steve Kass" wrote:
>
Extracting info from an exec/sp_executesql command
Hi everyone,
Im trying to do the following code for a simple test on variable (not working but the logic show what i want to get).
Im trying to get informations from an exec/sp_executesql command using a variable declared before the command and use that extracted value in another query later. Am i far from the solution?
Code Snippet
DECLARE @.i int
DECLARE @.sql nvarchar(4000)
SELECT @.sql = 'SELECT @.i = Count(*) from tblTableTest'
exec sp_executesql @.sql
PRINT @.i
You have to declare the list of parameters.
Code Snippet
DECLARE @.i int
DECLARE @.sql nvarchar(4000)
SELECT @.sql = 'SELECT @.i = Count(*) from tblTableTest'
exec sp_executesql @.sql, N'@.i int output', @.i output
PRINT @.i
AMB