Showing posts with label command. Show all posts
Showing posts with label command. Show all posts

Tuesday, March 27, 2012

Failed to Net Send to the address '%s'

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.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

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?
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

I still don't know what's happening with this installation. The command line
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(YM1WDB^W1Q$]V'>;'N1;@.LR
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+^YZOE21<AFVT+W3?>C_86VEOH\BQT,5:C./M\10M2G7G!_"2R
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<P9`@.<L$&:W1D2!\YA7!$8]
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]<I?Y*6.L;3OXJL98V_9RF4^[
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^VC<<DNORLO>Y8Z&U^DH\BO3F;K. -SD<YUS[?$JZ:*W69GS+[$V"D*SF
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@.<<79 YI-Z0IUM,M6WVF!+XG,K]$Z([$Z:O
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?VV&#ORSXU!+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)WN_6%GFOMLC[M46^5UOD.J>>%;O;R#?QX ]Q&OHD7YS;R
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/WM^K+?+PO5W9L+N-?!,_
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-VE_?OKD^!ATB7]^^;0OR]>W;
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^YPU?0N1_<AZ.^P1X_8>^Z:S /U#'Z7JQ]]L:+
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

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
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

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.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

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.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

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 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