Dear friends,
I tried to install my SQLServer2000 Developer
Edition in my server machine, which is running on the OS
Windows Server 2000.
I am getting the following errors
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
driver={sql server};server=CSPL\CSPL2K;UID=sa;PWD=;database=ma ster
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
driver={sql server};server=CSPL\CSPL2K;UID=sa;PWD=;database=ma ster
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead (recv()).
SQL Server configuration failed.
What is the problem?
Also, i herewith attached the error log file.
Kindly give me the solution and it is very urgent.
with regards,
T.Thirumalairajan B.E
begin 666 sqlstp.log
M,3@.Z,#0Z-# @.0F5G:6X@.4V5T=7 -"C$X.C T.C0P(#@.N,# N,3DT#0HQ.#HP
M-#HT,"!-;V1E(#T@.3F]R;6%L#0HQ.#HP-#HT,"!-;V1E5'EP92 ]($Y/4DU!
M3 T*,3@.Z,#0Z-# @.1V5T1&5F:6YI=&EO;D5X(')E='5R;F5D.B P+"!%>'1E
M;F1E9#H@.,'AF,# P,# -"C$X.C T.C0P(%9A;'5E1E13(')E='5R;F5D.B Q
M#0HQ.#HP-#HT,"!686QU95!)1"!R971U<FYE9#H@.,0T*,3@.Z,#0Z-# @.5F%L
M=65,:6,@.<F5T=7)N960Z(# -"C$X.C T.C0P(%-Y<W1E;3H@.5VEN9&]W<R!.
M5"!497)M:6YA;"!397)V97(-"C$X.C T.C0P(%-13"!397)V97(@.4')O9'5C
M=%1Y<&4Z($1E=F5L;W!E<B!%9&ET:6]N(%LP>#-=#0HQ.#HP-#HT,"!"96=I
M;B!!8W1I;VXZ(%-E='5P26YI=&EA;&EZ92 -"C$X.C T.C0P($5N9"!!8W1I
M;VX@.4V5T=7!);FET:6%L:7IE#0HQ.#HP-#HT,"!"96=I;B!!8W1I;VXZ("!3
M971U<$EN<W1A;&P-"C$X.C T.C0P(%)E861I;F<@.4V]F='=A<F5<36EC<F]S
M;V9T7%=I;F1O=W-<0W5R<F5N=%9E<G-I;VY<0V]M;6]N1FEL97-$:7(@.+BXN
M#0HQ.#HP-#HT,"!#;VUM;VY&:6QE<T1I<CU#.EQ0<F]G<F%M($9I;&5S7$-O
M;6UO;B!&:6QE<PT*,3@.Z,#0Z-# @.5VEN9&]W<R!$:7)E8W1O<GD]0SI<5TE.
M3E1<#0HQ.#HP-#HT,"!0<F]G<F%M($9I;&5S/4,Z7%!R;V=R86T@.1FEL97-<
M#0HQ.#HP-#HT,"!414U01$E2/4,Z7$1/0U5-17XQ7$%$34E.27XQ7$Q/0T%,
M4WXQ7%1E;7!<#0HQ.#HP-#HT,"!"96=I;B!!8W1I;VXZ("!3971U<$EN<W1A
M;&P-"C$X.C T.C0P(&1I9W!I9"!S:7IE(#H@.,C4V#0HQ.#HP-#HT,"!D:6=P
M:60@.<VEZ92 Z(#$V- T*,3@.Z,#0Z-# @.0F5G:6X@.06-T:6]N.B @.0VAE8VM&
M:7AE9%)E<75I<F5M96YT<PT*,3@.Z,#0Z-# @.4&QA=&9O<FT@.240Z(#!X9C P
M#0HQ.#HP-#HT,"!697)S:6]N.B U+C N,C$Y-0T*,3@.Z,#0Z-# @.1FEL92!6
M97)S:6]N("T@.0SI<5TE.3E1<<WES=&5M,S)<<VAD;V-V=RYD;&PZ(#4N,"XS
M-3(V+C@.P, T*,3@.Z,#0Z-# @.16YD($%C=&EO;CH@.($-H96-K1FEX961297%U
M:7)E;65N=',-"C$X.C T.C0P($)E9VEN($%C=&EO;CH@.(%-H;W=$:6%L;V=S
M#0HQ.#HP-#HT,"!);FET:6%L($1I86QO9R!-87-K.B P>#@.S,# P9C<L($1I
M<V%B;&4@.0F%C:STP>#$-"C$X.C T.C0Q($)E9VEN($%C=&EO;B!3:&]W1&EA
M;&]G<TAL<'(Z(#!X,0T*,3@.Z,#0Z-#$@.0F5G:6X@.06-T:6]N.B @.1&EA;&]G
M4VAO=U-D5V5L8V]M90T*,3@.Z,#0Z-#(@.16YD($%C=&EO;B @.1&EA;&]G4VAO
M=U-D5V5L8V]M90T*,3@.Z,#0Z-#(@.1&EA;&]G(#!X,2!R971U<FYE9#H@.,0T*
M,3@.Z,#0Z-#(@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C$X.C T.C0R
M(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N=#TP>#(L
M:6YD97@.],0T*,3@.Z,#0Z-#(@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP
M<CH@.,'@.R#0HQ.#HP-#HT,B!"96=I;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V1-
M86-H:6YE3F%M90T*,3@.Z,#0Z-#0@.4VAO=T1L9TUA8VAI;F4@.<F5T=7)N960Z
M(#$-"C$X.C T.C0T($YA;64@./2!#4U!,+"!4>7!E(#T@.,'@.Q#0HQ.#HP-#HT
M-"!"96=I;B!!8W1I;VXZ("!#:&5C:U)E<75I<F5M96YT<PT*,3@. Z,#0Z-#0@.
M4')O8V5S<V]R($%R8VAI=&5C='5R93H@.>#@.V("A096YT:75M*0T*,3@.Z,#0Z
M-#0@.4V5R=FEC92!086-K.B @.-S8X#0HQ.#HP-#HT-"!#;VUP=71E<DYA;64Z
M($-34$P-"C$X.C T.C0T(%5S97(@.3F%M93H@.061M:6YI<W1R871O<@.T*,3@.Z
M,#0Z-#0@.27-!;&Q!8V-E<W-!;&QO=V5D(')E='5R;F5D.B Q#0HQ.#HP-#HT
M-"!/4R!,86YG=6%G93H@.,'@.T,#D-"C$X.C T.C0T($5N9"!!8W1I;VX@.0VAE
M8VM297%U:7)E;65N=',-"C$X.C T.C0T($-R96%T95-E='5P5&]P;VQO9WDH
M0U-03"DL($AA;F1L92 Z(#!X,3@.Y-#$T,"P@.<F5T=7)N960@..B P#0HQ.#HP
M-#HT-"!#<F5A=&53971U<%1O<&]L;V=Y(')E='5R;F5D(#H@.,"P@.2&%N9&QE
M(#H@.,'@.Q.#DT,30P#0HQ.#HP-#HT-"!4;W!O;&]G>2!4>7!E(#H@.,2P@.4F5T
M=7)N(%9A;'5E(#H@., T*,3@.Z,#0Z-#0@.4U1?1V5T4&AY<VEC86Q.;V1E(')E
M='5R;F5D(#H@.,"P@.4$Y(86YD;&4@..B P>#$X.30Q-C@.-"C$X.C T.C0T(%!.
M7T5N=6UE<F%T945X(')E='5R;F5D(#H@., T*,3@.Z,#0Z-#0@.4$Y?1V5T4U%,
M4W1A=&5S(')E='5R;F5D(#H@.,"P@.4W%L4W1A=&5S(#H@.,'@.R, C<-"C$X.C T
M.C0T(%!.7U-T87)T4V-A;B!;,'@.Q.#DT,38X72!R971U<FYE9" Z(# -"C$X
M.C T.C0T(%!.7T=E=$YE>'0@.6S!X,3@.Y-#$V.%T@.<F5T=7)N960@..B Q."P@.
M2&%N9&QE.B!;,'@.P70T*,3@.Z,#0Z-#0@.3F\@.;6]R92!I=&5M<R!I;B!E;G5M
M97)A=&EO;BX-"C$X.C T.C0T(%)E;&5A<V53971U<%1O<&]L;V=Y#0HQ.#HP
M-#HT-"!.86UE9"!I;G-T86YC92!L:6UI=#H@.,3 P+"!Q=6]T83H@., T*,3@.Z
M,#0Z-#0@.16YD($%C=&EO;B @.1&EA;&]G4VAO=U-D36%C:&EN94YA;64-"C$X
M.C T.C0T(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z,#0Z-#0@.
M;D9U;&Q-87-K(#T@.,'@.X,S P,&8W+"!N0W5R<F5N=" ](#!X,BP@.;D1I<F5C
M=&EO;B ](# -"C$X.C T.C0T(%5P9&%T960@.1&EA;&]G($UA<VLZ(#!X8F8P
M,# S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ.#HP-#HT-"!$:6%L;V<@.,'@.R
M(')E='5R;F5D.B P#0HQ.#HP-#HT-"!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S
M2&QP<@.T*,3@.Z,#0Z-#0@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z
M(&Y#=7)R96YT/3!X-"QI;F1E>#TR#0HQ.#HP-#HT-"!"96=I;B!!8W1I;VX@.
M4VAO=T1I86QO9W-(;'!R.B P>#0-"C$X.C T.C0T($)E9VEN($%C=&EO;CH@.
M($1I86QO9U-H;W=39$EN<W1A;&Q-;V1E#0HQ.#HP-#HU-2!3:&]W1&QG26YS
M=&%L;$UO9&4@.<F5T=7)N960Z(#$-"C$X.C T.C4U($EN<W1A;&Q-;V1E(#H@.
M,'@.Q#0HQ.#HP-#HU-2!%;F0@.06-T:6]N("!$:6%L;V=3:&]W4V1);G-T86QL
M36]D90T*,3@.Z,#0Z-34@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ
M.#HP-#HU-2!N1G5L;$UA<VL@./2 P>&)F,# P,S<L(&Y#=7)R96YT(#T@.,'@.T
M+"!N1&ER96-T:6]N(#T@.,0T*,3@.Z,#0Z-34@.57!D871E9"!$:6%L;V<@.36%S
M:SH@.,'AB9C0P,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$X.C T.C4U($1I
M86QO9R P>#0@.<F5T=7)N960Z(#$-"C$X.C T.C4U($5N9"!!8W1I;VX@.4VAO
M=T1I86QO9W-(;'!R#0HQ.#HP-#HU-2!3:&]W1&EA;&]G<T=E=$1I86QO9R!R
M971U<FYE9#H@.;D-U<G)E;G0],'@.Q,"QI;F1E>#TT#0HQ.#HP-#HU-2!"96=I
M;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#$P#0HQ.#HP-#HU-2!"96=I
M;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V1296=I<W1E<E5S97)%> T*,3@.Z,#0Z
M-38@.16YD($%C=&EO;B!$:6%L;V=3:&]W4V1296=I<W1E<E5S97)%> T*,3@.Z
M,#0Z-38@.1&EA;&]G(#!X,3 @.<F5T=7)N960Z(#$-"C$X.C T.C4V($5N9"!!
M8W1I;VX@.4VAO=T1I86QO9W-(;'!R#0HQ.#HP-#HU-B!3:&]W1&EA;&]G<T=E
M=$1I86QO9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.R,"QI;F1E>#TU#0HQ.#HP
M-#HU-B!"96=I;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#(P#0HQ.#HP
M-#HU-B!"96=I;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V1,:6-E;G-E#0HQ.#HP
M-#HU.2!%;F0@.06-T:6]N($1I86QO9U-H;W=39$QI8V5N<V4-"C$X.C T.C4Y
M($1I86QO9R P>#(P(')E='5R;F5D.B Q#0HQ.#HP-#HU.2!%;F0@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#0Z-3D@.4VAO=T1I86QO9W-'971$:6%L
M;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X-# P,# L:6YD97@.],3@.-"C$X.C T
M.C4Y($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X-# P,# -"C$X
M.C T.C4Y($)E9VEN($%C=&EO;CH@.($1I86QO9U-H;W=39$-L:5-V<@.T*,3@.Z
M,#0Z-3D@.1&ES<&QA>5-Y<W1E;5!R95)E<0T*,3@.Z,#4Z,#,@.4VAO=T1L9T-L
M:65N=%-E<G9E<E-E;&5C="!R971U<FYE9#H@.,0T*,3@.Z,#4Z,#,@.5'EP92 Z
M(#!X,@.T*,3@.Z,#4Z,#,@.16YD($%C=&EO;B @.1&EA;&]G4VAO=U-D0VQI4W9R
M#0HQ.#HP-3HP,R!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-"C$X.C U
M.C S(&Y&=6QL36%S:R ](#!X8F8T,# S-RP@.;D-U<G)E;G0@./2 P>#0P,# P
M+"!N1&ER96-T:6]N(#T@.,0T*,3@.Z,#4Z,#,@.57!D871E9"!$:6%L;V<@.36%S
M:SH@.,'AB9F,P,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$X.C U.C S($1I
M86QO9R P>#0P,# P(')E='5R;F5D.B Q#0HQ.#HP-3HP,R!%;F0@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#4Z,#,@.4VAO=T1I86QO9W-'971$:6%L
M;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X.# P,# L:6YD97@.],3D-"C$X.C U
M.C S($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X.# P,# -"C$X
M.C U.C S($)E9VEN($%C=&EO;CH@.($1I86QO9U-H;W=39$EN<W1A;F-E3F%M
M90T*,3@.Z,#4Z,#,@.0F5G:6X@.06-T:6]N.B!3:&]W1&QG26YS=&%N8V5.86UE
M#0HQ.#HP-3HP."!%;F0@.06-T:6]N.B!3:&]W1&QG26YS=&%N8V5.86UE#0HQ
M.#HP-3HP."!3:&]W1&QG26YS=&%N8V5.86UE(')E='5R;F5D(#H@.,0T*,3@.Z
M,#4Z,#@.@.26YS=&%N8V5.86UE(#H@.0U-03#)+#0HQ.#HP-3HP."!%;F0@.06-T
M:6]N("!$:6%L;V=3:&]W4V1);G-T86YC94YA;64-"C$X.C U.C X(&)E9VEN
M(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z,#4Z,#@.@.;D9U;&Q-87-K(#T@.
M,'AB9F,P,#,W+"!N0W5R<F5N=" ](#!X.# P,# L(&Y$:7)E8W1I;VX@./2 Q
M#0HQ.#HP-3HP."!5<&1A=&5D($1I86QO9R!-87-K.B P>&)F8S P,S<L($1I
M<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#4Z,#@.@.1&EA;&]G(#!X.# P,# @.<F5T
M=7)N960Z(#$-"C$X.C U.C X($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R
M#0HQ.#HP-3HP."!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U
M<G)E;G0],'@.Q,# P,# L:6YD97@.],C -"C$X.C U.C X($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,3 P,# P#0HQ.#HP-3HP."!"96=I;B!!
M8W1I;VXZ("!$:6%L;V=3:&]W4V13971U<%1Y<&4-"C$X.C U.C X($)E9VEN
M($%C=&EO;CH@.4V5T=7 @.5'EP90T*,3@.Z,#4Z-3(@.4U%,('!R;V=R86T@.9F]L
M9&5R.B!$.EQ0<F]G<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R#0HQ
M.#HP-3HU,B!344P@.9&%T82!F;VQD97(Z($0Z7%!R;V=R86T@.1FEL97-<36EC
M<F]S;V9T(%-13"!397)V97(-"C$X.C U.C4R(%=I;F1O=W,@.<WES=&5M(&9O
M;&1E<CH@.0SI<5TE.3E1<<WES=&5M,S)<#0HQ.#HP-3HU,B!0<F]G(')E<3H@.
M,S0W.#DL($1A=&$@.<F5Q.B S-#0S,BP@.4WES(')E<3H@.,3,R,38X#0HQ.#HP
M-3HU,B!0<F]G(&%V86EL.B Q-30S.3$R+"!$871A(&%V86EL.B Q-30S.3$R
M+"!3>7,@.879A:6PZ(#4U,C<S,S8-"C$X.C U.C4R(%!R;V<@.<F5Q('9S+B!A
M=F%I;"P@.-CDR,C$L(#$U-#,Y,3(-"C$X.C U.C4R($1A=&$@.<F5Q('9S+B!A
M=F%I;"P@.,S0T,S(L(#$U-#,Y,3(-"C$X.C U.C4R(%-Y<R!R97$@.=G,N(&%V
M86EL+" Q,S(Q-C@.L(#4U,C<S,S8-"C$X.C U.C4R($1I<W!L87E3>7-T96U0
M<F5297$-"C$X.C U.C4R(%M3971U<%1Y<&5344Q=#0HQ.#HP-3HU,B!S>D1I
M<B ]($0Z7%!R;V=R86T@.1FEL97-<36EC<F]S;V9T(%-13"!397)V97(-"C$X
M.C U.C4R('-Z1&ER(#T@.1#I<4')O9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,
M(%-E<G9E<@.T*,3@.Z,#4Z-3(@.4F5S=6QT(#T@.,S Q#0HQ.#HP-3HU,B!S>D1A
M=&%$:7(@./2!$.EQ0<F]G<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R
M#0HQ.#HP-3HU,B!S>D1A=&%$:7(@./2!$.EQ0<F]G<F%M($9I;&5S7$UI8W)O
M<V]F="!344P@.4V5R=F5R#0HQ.#HP-3HU,B!%;F0@.06-T:6]N.B!3971U<"!4
M>7!E#0HQ.#HP-3HU,B!3971U<"!4>7!E.B!4>7!I8V%L("@.S,#$I#0HQ.#HP
M-3HU,B!%;F0@.06-T:6]N("!$:6%L;V=3:&]W4V13971U<%1Y<&4-"C$X.C U
M.C4R(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z,#4Z-3(@.;D9U
M;&Q-87-K(#T@.,'AB9F,P,#,W+"!N0W5R<F5N=" ](#!X,3 P,# P+"!N1&ER
M96-T:6]N(#T@.,S Q#0HQ.#HP-3HU,R!5<&1A=&5D($1I86QO9R!-87-K.B P
M>&)D8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#4Z-3,@.1&EA;&]G
M(#!X,3 P,# P(')E='5R;F5D.B S,#$-"C$X.C U.C4S($5N9"!!8W1I;VX@.
M4VAO=T1I86QO9W-(;'!R#0HQ.#HP-3HU,R!3:&]W1&EA;&]G<T=E=$1I86QO
M9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.T,# P,# L:6YD97@.],C(-"C$X.C U
M.C4S($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X-# P,# P#0HQ
M.#HP-3HU,R!"96=I;B!!8W1I;VXZ("!$;&=397)V:6-E<PT*,3@.Z,#8Z,#$@.
M4VAO=T1L9U-E<G9I8V5S(')E='5R;F5D.B Q#0HQ.#HP-CHP,2!;1&QG4V5R
M=FEC97-=#0HQ.#HP-CHP,2!,;V-A;"U$;VUA:6X)/2 V,38X, T*,3@.Z,#8Z
M,#$@.075T;U-T87)T"0D](#$U#0HQ.#HP-CHP,2!344Q$;VUA:6X)"3T@.0TA%
M3%-/1E0-"C$X.C V.C Q(%-13$1O;6%I;D%C8W0)/2!!9&UI;FES=')A=&]R
M#0HQ.#HP-CHP,2!344Q$;VUA:6Y0=V0-"C$X.C V.C Q($%G=$1O;6%I;@.D)
M/2!#2$5,4T]&5 T*,3@.Z,#8Z,#$@.06=T1&]M86EN06-C= D]($%D;6EN:7-T
M<F%T;W(-"C$X.C V.C Q($%G=$1O;6%I;E!W9 T*,3@.Z,#8Z,#$@.4F5S=6QT
M"3T@.,0T*,3@.Z,#8Z,#$@.16YD($%C=&EO;B!$;&=397)V:6 -E<PT*,3@.Z,#8Z
M,#$@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ.#HP-CHP,2!N1G5L
M;$UA<VL@./2 P>&)D8S P,S<L(&Y#=7)R96YT(#T@.,'@.T,# P,# L(&Y$:7)E
M8W1I;VX@./2 Q#0HQ.#HP-CHP,2!5<&1A=&5D($1I86QO9R!-87-K.B P>&)D
M8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#8Z,#$@.1&EA;&]G(#!X
M-# P,# P(')E='5R;F5D.B Q#0HQ.#HP-CHP,2!%;F0@.06-T:6]N(%-H;W=$
M:6%L;V=S2&QP<@.T*,3@.Z,#8Z,#$@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T
M=7)N960Z(&Y#=7)R96YT/3!X.# P,# P+&EN9&5X/3(S#0HQ.#HP-CHP,2!"
M96=I;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#@.P,# P, T*,3@.Z,#8Z
M,#$@.0F5G:6X@.06-T:6]N.B @.1&QG4U%,4V5C=7)I='D-"C$X.C V.C,S(%-H
M;W=$;&=344Q396-U<FET>2!R971U<FYE9#H@.,0T*,3@.Z,#8Z,S,@.3&]G:6Y-
M;V1E(#T@.,BQS>E!W9 T*,3@.Z,#8Z,S,@.16YD($%C=&EO;B!$;&=344Q396-U
M<FET>0T*,3@.Z,#8Z,S,@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ
M.#HP-CHS,R!N1G5L;$UA<VL@./2 P>&)D8S P,S<L(&Y#=7)R96YT(#T@.,'@.X
M,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ.#HP-CHS,R!5<&1A=&5D($1I86QO
M9R!-87-K.B P>&)D8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z,#8Z
M,S,@.1&EA;&]G(#!X.# P,# P(')E='5R;F5D.B Q#0HQ.#HP-CHS,R!%;F0@.
M06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#8Z,S,@.4VAO=T1I86QO9W-'
M971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X,3 P,# P,"QI;F1E>#TR
M- T*,3@.Z,#8Z,S,@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.Q
M,# P,# P#0HQ.#HP-CHS,R!"96=I;B!!8W1I;VXZ("!$;&=#;VQL871I;VX-
M"C$X.C V.C,S(%-H;W=$;&=#;VQL871I;VX@.<F5T=7)N960Z(#$-"C$X.C V
M.C,S(&-O;&QA=&EO;E]N86UE(#T@.4U%,7TQA=&EN,5]'96YE<F%L7T-0,5]#
M25]!4RQL;V-A;&5?;F%M92 ]($QA=&EN,5]'96YE<F%L+&QC:60@./2 P>#0P
M.2Q3;W)T260@./2 U,BQD=T-O;7!&;&%G<R ](#!X,S P,#$-"C$X.C V.C,S
M($5N9"!!8W1I;VX@.1&QG0V]L;&%T:6]N#0HQ.#HP-CHS,R!B96=I;B!3:&]W
M1&EA;&]G<U5P9&%T94UA<VL-"C$X.C V.C,S(&Y&=6QL36%S:R ](#!X8F1C
M,# S-RP@.;D-U<G)E;G0@./2 P>#$P,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ
M.#HP-CHS,R!5<&1A=&5D($1I86QO9R!-87-K.B P>&)D8S P,S<L($1I<V%B
M;&4@.0F%C:R ](#!X,0T*,3@.Z,#8Z,S,@.1&EA;&]G(#!X,3 P,# P,"!R971U
M<FYE9#H@.,0T*,3@.Z,#8Z,S,@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-
M"C$X.C V.C,S(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R
M<F5N=#TP>#(P,# P,# L:6YD97@.],C4-"C$X.C V.C,S($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,C P,# P, T*,3@.Z,#8Z,S,@.0F5G:6X@.
M06-T:6]N.B @.1&QG3F5T=V]R:PT*,3@.Z,#8Z,S,@.4VAO=T1L9TYE='=O<FL@.
M<F5T=7)N960Z(#$-"C$X.C V.C,S(%M$;&=397)V97).971W;W)K70T*,3@.Z
M,#8Z,S,@.3F5T=V]R:TQI8G,@./2 R-34-"C$X.C V.C,S(%1#4%!O<G0@./2 P
M#0HQ.#HP-CHS,R!40U!0<GAY(#T@.1&5F875L= T*,3@.Z,#8Z,S,@.3DU04&EP
M94YA;64@./2!<7"Y<<&EP95Q-4U-13"1#4U!,,DM<<W%L7'%U97)Y#0HQ.#HP
M-CHS,R!297-U;'0@./2 Q#0HQ.#HP-CHS,R!%;F0@.06-T:6]N($1L9TYE='=O
M<FL-"C$X.C V.C,S(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,3@.Z
M,#8Z,S,@.;D9U;&Q-87-K(#T@.,'AB9&,P,#,W+"!N0W5R<F5N=" ](#!X,C P
M,# P,"P@.;D1I<F5C=&EO;B ](#$-"C$X.C V.C,S(%5P9&%T960@.1&EA;&]G
M($UA<VLZ(#!X8F1C,# S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ.#HP-CHS
M,R!$:6%L;V<@.,'@.R,# P,# P(')E='5R;F5D.B Q#0HQ.#HP-CHS,R!%;F0@.
M06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,3@.Z,#8Z,S,@.4VAO=T1I86QO9W-'
M971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X.# P,# P,"QI;F1E>#TR
M-PT*,3@.Z,#8Z,S,@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.X
M,# P,# P#0HQ.#HP-CHS,R!"96=I;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V13
M=&%R=$-O<'D-"C$X.C V.C,T($5N9"!!8W1I;VX@.1&EA;&]G4VAO=U-D4W1A
M<G1#;W!Y#0HQ.#HP-CHS-"!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-
M"C$X.C V.C,T(&Y&=6QL36%S:R ](#!X8F1C,# S-RP@.;D-U<G)E;G0@./2 P
M>#@.P,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ.#HP-CHS-"!5<&1A=&5D($1I
M86QO9R!-87-K.B P>&)D8S P,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,3@.Z
M,#8Z,S0@.1&EA;&]G(#!X.# P,# P,"!R971U<FYE9#H@.,0T*,3@.Z,#8Z,S0@.
M16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C$X.C V.C,T(%-H;W=$:6%L
M;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N=#TP># L:6YD97@.], T*
M,3@.Z,#8Z,S0@.16YD($%C=&EO;B!3:&]W1&EA;&]G<PT*,3@.Z,#8Z,S0@.0F5G
M:6X@.06-T:6]N(%!R;V-E<W-"969O<F5$871A36]V93H-"C$X.C V.C,T($1E
M:6YS=&%L;%-T87)T(')E='5R;F5D("A$.EQ0<F]G<F%M($9I;&5S7$UI8W)O
M<V]F="!344P@.4V5R=F5R7$U34U%,)$-34$PR2RDZ(# -"C$X.C V.C,T($5N
M9"!!8W1I;VX@.("!0<F]C97-S0F5F;W)E1&%T84UO=F4Z#0HQ.#HP-CHS-"!"
M96=I;B!!8W1I;VX@.4V5T5&]O;'-#;VUP;VYE;G1396QE8W1I;VXZ#0HQ.#HP
M-CHS-"!#<F5A=&53971U<%1O<&]L;V=Y*$-34$PI+"!(86YD;&4@..B P>#$X
M.30Q-# L(')E='5R;F5D(#H@., T*,3@.Z,#8Z,S0@.0W)E871E4V5T=7!4;W!O
M;&]G>2!R971U<FYE9" Z(# L($AA;F1L92 Z(#!X,3@.Y-#$T, T*,3@.Z,#8Z
M,S0@.5&]P;VQO9WD@.5'EP92 Z(#$L(%)E='5R;B!686QU92 Z(# -"C$X.C V
M.C,T(%-47T=E=%!H>7-I8V%L3F]D92!R971U<FYE9" Z(# L(%!.2&%N9&QE
M(#H@.,'@.Q.#DT,38X#0HQ.#HP-CHS-"!03E]%;G5M97)A=&5%>"!R971U<FYE
M9" Z(# -"C$X.C V.C,T(%!.7T=E=%-13%-T871E<R!R971U<FYE9" Z(# L
M(%-Q;%-T871E<R Z(#!X,C(W#0HQ.#HP-CHS-"!03E]3=&%R=%-C86X@.6S!X
M,3@.Y-#$V.%T@.<F5T=7)N960@..B P#0HQ.#HP-CHS-"!03E]'971.97AT(%LP
M>#$X.30Q-CA=(')E='5R;F5D(#H@.,"P@.2&%N9&QE.B!;,'@.Q.#DU,#@.P70T *
M,3@.Z,#8Z,S0@.4U%,25]'9714>7!E(%LP>#$X.34P.#!=(')E='5R;F5D(#H@.
M,"P@.;E1Y<&4Z(#!X,PT*,3@.Z,#8Z,S0@.4U%,25]'971);G-T86QL4&%T:"!;
M,'@.Q.#DU,#@.P72!R971U<FYE9" Z(# L(%!A=&@.@./2!$.EQ0<F]G<F%M($9I
M;&5S7$U34U%,-PT*,3@.Z,#8Z,S0@.4U%,25]'971$871A4&%T:"!;,'@.Q.#DU
M,#@.P72!R971U<FYE9" Z(# L($1A=&%0871H(#T@.1#I<4')O9W)A;2!&:6QE
M<UQ-4U-13#<-"C$X.C V.C,T(%-13$E?1V5T5F5R<VEO;B!;,'@.Q.#DU,#@.P
M72!R971U<FYE9" Z(# L(%9E<G-I;VX@./2 W+C P+C8R,PT*,3@.Z,#8Z,S0@.
M4U%,25]'971296=+97E2;V]T(%LP>#$X.34P.#!=(')E='5R;F5D(#H@.,"P@.
M4F5G2V5Y4F]O=" ](%-O9G1W87)E7$UI8W)O<V]F=%Q-4U-13%-E<G9E<@.T*
M,3@.Z,#8Z,S0@.5&]O;',@.4&%T:#H@.(" @.($0Z7%!R;V=R86T@.1FEL97-<35-3
M44PW#0HQ.#HP-CHS-"!4;V]L<R!697)S:6]N.B @.-RXP,"XV,C,-"C$X.C V
M.C,T(%1O;VQS(%)E9VES=')Y.B!3;V9T=V%R95Q-:6-R;W-O9G1<35-344Q3
M97)V97(-"C$X.C V.C,T(%!.7T=E=$YE>'0@.6S!X,3@.Y-#$V.%T@.<F5T=7)N
M960@..B Q."P@.2&%N9&QE.B!;,'@.P70T*,3@.Z,#8Z,S0@.1F]R8V4@.4'5R9V4-
M"C$X.C V.C,T(%!.7U-T87)T4V-A;B!;,'@.Q.#DT,38X72!R971U<FYE9" Z
M(# -"C$X.C V.C,T(%!.7T=E=$YE>'0@.6S!X,3@.Y-#$V.%T@.<F5T=7)N960@.
M.B P+"!(86YD;&4Z(%LP>#$X.30V9CA=#0HQ.#HP-CHS-"!344Q)7T=E=$EN
M<W1A;&Q0871H(%LP>#$X.30V9CA=(')E='5R;F5D(#H@.,"P@.4 &%T:" ]($0Z
M7%!R;V=R86T@.1FEL97-<35-344PW#0HQ.#HP-CHS-"!344Q)7T=E=$1A=&%0
M871H(%LP>#$X.30V9CA=(')E='5R;F5D(#H@.,"P@.1&%T85!A= &@.@./2!$.EQ0
M<F]G<F%M($9I;&5S7$U34U%,-PT*,3@.Z,#8Z,S0@.4U%,25]'971697)S:6]N
M(%LP>#$X.30V9CA=(')E='5R;F5D(#H@.,"P@.5F5R<VEO;B ](#<N,# N-C(S
M#0HQ.#HP-CHS-"!344Q)7T=E=%)E9TME>5)O;W0@.6S!X,3@.Y-#9F.%T@.<F5T
M=7)N960@..B P+"!296=+97E2;V]T(#T@.4V]F='=A<F5<36EC<F]S;V9T7$U3
M4U%,4V5R=F5R#0HQ.#HP-CHS-"!03E]'971.97AT(%LP>#$X.30Q-CA=(')E
M='5R;F5D(#H@.,3@.L($AA;F1L93H@.6S!X,%T-"C$X.C V.C,T(%)E;&5A<V53
M971U<%1O<&]L;V=Y#0HQ.#HP-CHS-"!%;F0@.06-T:6]N(%-E=%1O;VQS0V]M
M<&]N96YT4V5L96-T:6]N.@.T*,3@.Z,#8Z,S0@.0F5G:6X@.06-T:6]N(%!R;V-E
M<W-#;VUP;VYE;G1396QE8W1I;VXZ#0HQ.#HP-CHS-"!%;F0@.06-T:6]N(%!R
M;V-E<W-#;VUP;VYE;G1396QE8W1I;VX-"C$X.C V.C,T($)E9VEN($%C=&EO
M;B!,;V=396QE8W1E9$-O;7!O;F5N=',Z#0HQ.#HP-CHS-"!344Q0<F]G#0HQ
M.#HP-CHS-"!344Q0<F]G7%-13%-E<G9R#0HQ.#HP-CHS-"!344Q0<F]G7%-1
M3%-E<G9R7$AE;' -"C$X.C V.C,T(%-13%!R;V=<4U%,4V5R=G)<4T--1&5V
M#0HQ.#HP-CHS-"!344Q0<F]G7%-13%-E<G9R7%-#341E=EQ30TUH#0HQ.#HP
M-CHS-"!344Q0<F]G7%-13%-E<G9R7%-#341E=EQ30TU8.#9,8@.T*,3@.Z,#8Z
M,S0@.4U%,4')O9UQ344Q397)V<EQ30TU$979<4T--04QB#0HQ.#HP-CHS-"!3
M44Q0<F]G7%-13%-E<G9R7%)S,3 S,PT*,3@.Z,#8Z,S0@.4U%,4')O9UQ344Q3
M97)V<EQ2<TEN=&P-"C$X.C V.C,T(%-13%!R;V=<4U%,4V5R=G)<06-T:79E
M6 T*,3@.Z,#8Z,S0@.4U%,4')O9UQ344Q397)V<EQ3>7-T96T-"C$X.C V.C,T
M(%-13%!R;V=<4F5P;%-U<' -"C$X.C V.C,T(%-13%!R;V=<4F5P;%-U<'!<
M4F5P;$1A= T*,3@.Z,#8Z,S0@.4U%,4')O9UQ297!L4W5P<%Q297!#;VUM#0HQ
M.#HP-CHS-"!344Q0<F]G7%)E<&Q3=7!P7%)E<$YO1&L-"C$X.C V.C,T(%-1
M3%!R;V=<4F5P;%-U<'!<06-T:79E6 T*,3@.Z,#8Z,S0@.4U%,4')O9UQ);G-T
M86QL#0HQ.#HP-CHS-"!344Q0<F]G7%-Y<W1E;0T*,3@.Z,#8Z,S0@.4U%,4')O
M9UQ3=G)%>'0-"C$X.C V.C,T(%-13%!R;V=<4W9R17AT7$AE;' -"C$X.C V
M.C,T(%-13%!R;V=<4W9R17AT7%-V<D5X=%)S#0HQ.#HP-CHS-"!344Q0<F]G
M7%-V<D5X=%Q297-);G1L#0HQ.#HP-CHS-"!344Q0<F]G7$1A= T*,3@.Z,#8Z
M,S0@.4U%,4')O9UQ$8713;7!L#0HQ.#HP-CHS-"!344Q0<F]G7$)A<V53>7,-
M"C$X.C V.C,T(%-13%!R;V=<0F%S94)I;FX-"C$X.C V.C,T(%-13%!R;V=<
M35-396%R8V@.-"C$X.C V.C,T(%-13%!R;V=<35-396%R8VA<2&5L< T*,3@.Z
M,#8Z,S0@.4U%,4')O9UQ-4U-E87)C:%Q!8W1I=F58#0HQ.#HP-CHS-"!344Q0
M<F]G7$)A<V5);G-T#0HQ.#HP-CHS-"!344Q0<F]G7%-Y;6)O;',-"C$X.C V
M.C,T(%-13%!R;V=<4WEM8F]L<UQ%6$4-"C$X.C V.C,T(%-13%!R;V=<4WEM
M8F]L<UQ$3$P-"C$X.C V.C,T(%-13%!R;V=<4&5R9FUO;@.T*,3@.Z,#8Z,S0@.
M4U%,4')O9UQ097)F;6]N7%-Y<W1E;0T*,3@.Z,#8Z,S0@.4U%,4')O9UQ2;V]T
M#0HQ.#HP-CHS-"!-9W14;V]L#0HQ.#HP-CHS-"!-9W14;V]L7%-%30T*,3@.Z
M,#8Z,S0@.36=T5&]O;%Q314U<2%1-3 T*,3@.Z,#8Z,S0@.36=T5&]O;%Q314U<
M35-$.3@.-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$U31#DX4UE3#0HQ.#HP-CHS
M-"!-9W14;V]L7%-%35Q-4T0Y.%)E<PT*,3@.Z,#8Z,S0@.36=T5&]O;%Q314U<
M35-$.3A(;' -"C$X.C V.C,T($UG=%1O;VQ<4T5-7$AE;' -"C$X.C V.C,T
M($UG=%1O;VQ<4T5-7%)E<S$P,S,-"C$X.C V.C,T($UG=%1O;VQ<4T5-7%)E
M<TEN=&P-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$U31#DX4G-)#0HQ.#HP-CHS
M-"!-9W14;V]L7%-%35Q!8W1I=F58#0HQ.#HP-CHS-"!-9W14;V]L7%-%35Q!
M8W1I=F587%)E<S$P,S,-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$%C=&EV95A<
M4F5S26YT; T*,3@.Z,#8Z,S0@.36=T5&]O;%Q314U<4V-R:7!T<PT*,3@.Z,#8Z
M,S0@.36=T5&]O;%Q314U<3TQ%1$(-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$],
M141"7%)E<S$P,S,-"C$X.C V.C,T($UG=%1O;VQ<4T5-7$],141"7%)E<TEN
M=&P-"C$X.C V.C,T($UG=%1O;VQ<4')O9FEL97(-"C$X.C V.C,T($UG=%1O
M;VQ<4')O9FEL97)<2&5L< T*,3@.Z,#8Z,S0@.36=T5&]O;%Q0<F]F:6QE<EQ2
M97,Q,#,S#0HQ.#HP-CHS-"!-9W14;V]L7%!R;V9I;&5R7%)E<TEN=&P-"C$X
M.C V.C,T($UG=%1O;VQ<47)Y86YL>@.T*,3@.Z,#8Z,S0@.36=T5&]O;%Q1<GEA
M;FQZ7$AE;' -"C$X.C V.C,T($UG=%1O;VQ<47)Y86YL>EQ297,Q,#,S#0HQ
M.#HP-CHS-"!-9W14;V]L7%%R>6%N;'I<4F5S26YT; T*,3@.Z,#8Z,S0@.36=T
M5&]O;%Q$5$-#3&D-"C$X.C V.C,T($UG=%1O;VQ<5WIC;F9L8W0-"C$X.C V
M.C,T($UG=%1O;VQ<5WIC;F9L8W1<5WIC;DAL< T*,3@.Z,#8Z,S0@.36=T5&]O
M;%Q7>F-N9FQC=%Q7>F-N,3 S,PT*,3@.Z,#8Z,S0@.36=T5&]O;%Q7>F-N9FQC
M=%Q7>F-N3W1H<@.T*,3@.Z,#8Z,S0@.36=T5&]O;%Q7>F-N9FQC=%Q7>F-N0VUN
M#0HQ.#HP-CHS-"!-9W14;V]L7%5T:6Q3>7,-"C$X.C V.C,T($UG=%1O;VQ<
M571I;$)I;FX-"C$X.C V.C,T($-O;FYE8W0-"C$X.C V.C,T($-O;FYE8W1<
M0V]N;E-Y<PT*,3@.Z,#8Z,S0@.0F]O:W,-"C$X.C V.C,T($)O;VMS7$)O;VMS
M;PT*,3@.Z,#8Z,S0@.0F]O:W-<0F]O:W-O7%5T:6QS#0HQ.#HP-CHS-"!$9794
M;V]L<PT*,3@.Z,#8Z,S0@.1&5V5&]O;'-<1&)G($EN= T*,3@.Z,#8Z,S0@.1&5V
M5&]O;'-<1&)G($EN=%Q$8F<@.26YT($-O;6UO;@.T*,3@.Z,#8Z,S0@.1&5V5&]O
M;'-<1&)G($EN=%Q%6$4-"C$X.C V.C,T($-O<F5297!L#0HQ.#HP-CHS-"!#
M;W)E4F5P;%Q297,Q,#,S#0HQ.#HP-CHS-"!#;W)E4F5P;%Q297-);G1L#0HQ
M.#HP-CHS-"!#;W)E#0HQ.#HP-CHS-"!#;W)E7%)E<S$P,S,-"C$X.C V.C,T
M($-O<F5<4F5S3W1H97(-"C$X.C V.C,T(%)E<&]S=')Y#0HQ.#HP-CHS-"!2
M97!O<W1R>5Q297!S=%-Y<PT*,3@.Z,#8Z,S0@.4F5P;W-T<GE<4F5S,3 S,PT*
M,3@.Z,#8Z,S0@.4F5P;W-T<GE<4F5S26YT; T*,3@.Z,#8Z,S0@.0V]R94UI<V,-
M"C$X.C V.C,T($-O<F5-:7-C7$%C=&EV95@.-"C$X.C V.C,T($-O<F5-:7-C
M7$%C=&EV95A<4F5S,3 S,PT*,3@.Z,#8Z,S0@.0V]R94UI<V-<06-T:79E6%Q2
M97-);G1L#0HQ.#HP-CHS-"!#;W)E36ES8UQ297,Q,#,S#0HQ.#HP-CHS-"!-
M;VYA<F-H#0HQ.#HP-CHS-"!-;VYA<F-H7$UO;G(Q,#,S#0HQ.#HP-CHS-"!-
M;VYA<F-H7$UO;G));G1L#0HQ.#HP-CHS-"!*970-"C$X.C V.C,T($-O<F5)
M;G-T#0HQ.#HP-CHS-"!#;W)E0T]-#0HQ.#HP-CHS-"!#;W)E0T]-7%)E<S$P
M,S,-"C$X.C V.C,T($-O<F5#3TU<4F5S26YT; T*,3@.Z,#8Z,S0@.0V]R951O
M;VP-"C$X.C V.C,T($-O<F54;V]L7%)E<S$P,S,-"C$X.C V.C,T($-O<F54
M;V]L7%)E<T]T:&5R#0HQ.#HP-CHS-"!$0DQI8D-L:0T*,3@.Z,#8Z,S0@.4T9%
M>'0-"C$X.C V.C,T(%-&17AT7$%C=&EV95@.-"C$X.C V.C,T(%-&17AT7$%C
M=&EV95A<4F5S,3 S,PT*,3@.Z,#8Z,S0@.4T9%>'1<06-T:79E6%Q297-);G1L
M#0HQ.#HP-CHS-"!31D5X=%Q297,Q,#,S#0HQ.#HP-CHS-"!31D5X=%Q297-)
M;G1L#0HQ.#HP-CHS-"!4<F%C90T*,3@.Z,#8Z,S0@.5')A8V5<4F5S,3 S,PT*
M,3@.Z,#8Z,S0@.5')A8V5<4F5S3W1H97(-"C$X.C V.C,T($UI<V-#;W)E#0HQ
M.#HP-CHS-"!-0PT*,3@.Z,#8Z,S0@.34-<34,Q,#,S#0HQ.#HP-CHS-"!-0UQ-
M0TEN=&P-"C$X.C V.C,T($U#7$AE;' -"C$X.C V.C,T(%-13$UG<@.T*,3@.Z
M,#8Z,S0@.4U%,36=R7%)E<S$P,S,-"C$X.C V.C,T(%-13$UG<EQ297-);G1L
M#0HQ.#HP-CHS-"!3=G)4;V]L#0HQ.#HP-CHS-"!3=G)4;V]L7%)E<S$P,S,-
M"C$X.C V.C,T(%-V<E1O;VQ<4F5S26YT; T*,3@.Z,#8Z,S0@.1%1354D-"C$X
M.C V.C,T($144U5)7%)E<S$P,S,-"C$X.C V.C,T($144U5)7%)E<TEN=&P-
M"C$X.C V.C,T($U33VQA< T*,3@.Z,#8Z,S0@.35-/;&%P7%)E<S$P,S,-"C$X
M.C V.C,T($U33VQA<%Q297-);G1L#0HQ.#HP-CHS-"!!5$P-"C$X.C V.C,T
M($%43%QW:6YN= T*,3@.Z,#8Z,S0@.051,7'=I;CEX#0HQ.#HP-CHS-"!-1D,T
M,E4-"C$X.C V.C,T(%9##0HQ.#HP-CHS-"!60@.T*,3@.Z,#8Z,S0@.4U%,061(
M;' -"C$X.C V.C,T(%-13$%D2&QP7%)E<S$P,S,-"C$X.C V.C,T(%-13$%D
M2&QP7%)E<T]T:&5R#0HQ.#HP-CHS-"![13 W1D1$0D4M-4$R,2TQ,60R+3E$
M040M,#!#,#1&-SE$-#,T?0T*,3@.Z,#8Z,S0@.>T4P-T9$1$,W+35!,C$M,3%D
M,BTY1$%$+3 P0S T1C<Y1#0S-'T-"C$X.C V.C,T('M%,#=&1$1#,"TU03(Q
M+3$Q9#(M.41!1"TP,$,P-$8W.40T,S1]#0HQ.#HP-CHS-"![13 W1D1$0D8M
M-4$R,2TQ,60R+3E$040M,#!#,#1&-SE$-#,T?0T*,3@.Z,#8Z,S0@.16YD($%C
M=&EO;B!,;V=396QE8W1E9$-O;7!O;F5N=',-"C$X.C V.C,T($)E9VEN($%C
M=&EO;B!);G-T86QL4&MG<SH-"C$X.C V.C,T($)E9VEN($%C=&EO;CH@.3&]C
M:V5D($-O;FYE8W1I=FET>2!&:6QE<R!#:&5C:PT*,3@.Z,#8Z,S8@.0V]N;F5C
M=&EV:71Y3&]C:V5D(')E='5R;F5D.B P#0HQ.#HP-CHS-B!4:&4@.;W!E<F%T
M:6]N(&-O;7!L971E9"!S=6-C97-S9G5L;'DN#0H-"C$X.C V.C,V($5N9"!!
M8W1I;VXZ($QO8VME9"!#;VYN96-T:79I='D@.1FEL97,@.0VAE8VL-"C$X.C V
M.C,V(%-E='5P(&ES(&EN<W1A;&QI;F<@.36EC<F]S;V9T($1A=&$@.06-C97-S
M($-O;7!O;F5N=',@.*$U$04,I("XN+@.T*,3@.Z,#8Z,S8@.7%Q#4U!,7 %-O9G1W
M87)E7$]T:&5R<UQ344PR,# P7$1%5D5,3U!%4EQ8.#9<3W1H97)<<W%L<F5D
M:7,N97AE("]Q.F$@.+T,Z(G-E='5P<F4N97AE(%=!4DX],2 M<R M4TU3(@.T*
M,3@.Z,#<Z,C @.17AI=$-O9&4Z(# -"C$X.C W.C(P(%-E='5P(&ES(&EN<W1A
M;&QI;F<@.36EC<F]S;V9T($1I<W1R:6)U=&5D(%1R86YS86-T:6]N($-O;W)D
M:6YA=&]R("A-4T140RD@.+BXN#0HQ.#HP-SHR," @.0SI<1$]#54U%?C%<041-
M24Y)?C%<3$]#04Q3?C%<5&5M<%Q3<6Q3971U<%Q":6Y<8VQD=&-S=' N97AE
M("U3=7!P;W)T1&ER(")#.EQ$3T-5345^,5Q!1$U)3DE^,5Q,3T-!3%-^,5Q4
M96UP7%-Q;%-E='5P7$)I;B(@.+4140U!K9R B7%Q#4U!,7%-O9G1W87)E7$]T
M:&5R<UQ344PR,# P7$1%5D5,3U!%4EQ8.#9<3W1H97)<9'1C<V5T=7 N97AE
M(B M3&]G1FEL92 B0SI<5TE.3E1<<W%L<W1P+FQO9R(-"C$X.C W.C(P(%!R
M;V-E<W,@.17AI="!#;V1E.B H,"D@.#0HQ.#HP-SHR,"!);G-T86QL35-396%R
M8V@.@.:6YS=&%N8V4Z($-34$PR2PT*,3@.Z,#<Z,C @.4V]F='=A<F5<36EC<F]S
M;V9T7%-E87)C:%Q);G-T86QL.E9E<G-I;VX@.;F]T('!R97-E;G0-"C$X.C W
M.C(P($U34V5A<F-H(#(N,"!O<B!G<F5A=&5R('9E<G-I;VX@.8VAE8VL@.<F5T
M=7)N960@.+3$-"C$X.C W.C(Q(%-E='5P(&ES(&EN<W1A;&QI;F<@.=&AE($UI
M8W)O<V]F="!&=6QL+51E>'0@.4V5A<F-H($5N9VEN92 N+BX-"C$X.C W.C(Q
M(" B7%Q#4U!,7%-O9G1W87)E7$]T:&5R<UQ344PR,# P7$1%5D5,3U!%4EQ8
M.#9<1G5L;%1E>'1<35-396%R8VA<4V5A<F-H7%-E87)C:%-T<"YE>&4B("]S
M("]A.E-13%-E<G9E<B1#4U!,,DL-"C$X.C W.C0U(%!R;V-E<W,@.17AI="!#
M;V1E.B H,"D@.#0HQ.#HP-SHT-2 @.+U$Z02 O5#I#.EQ$3T-5345^,5Q!1$U)
M3DE^,5Q,3T-!3%-^,5Q496UP7&EX<# P,2YT;7 -"C$X.C W.C0U(%-E='5P
M(&ES(&EN<W1A;&QI;F<@.2%1-3"!(96QP("XN+@.T*,3@.Z,#<Z-#8@.2%1-3"!(
M96QP(&EN<W1A;&QE<B!E>&ET(&-O9&4Z(# -"C$X.C X.C X($5N9"!!8W1I
M;VX@.26YS=&%L;%!K9W,-"C$X.C X.C X($)E9VEN($%C=&EO;B!-;W9E1FEL
M941A=&$Z#0HQ.#HP.#HP."!%;F%B;&5D(%-%3$9214=)4U1%4D)!5$-(#0HQ
M.#HP.#HP."!%;F%B;&5D($-/4D5#3TU03TY%3E1(04Y$3$E.1PT*,3@.Z,#DZ
M,# @.0F5G:6X@.06-T:6]N.B @.36]V949I;&5$871A4W!E8VEA; T*,3@.Z,#DZ
M,#$@.16YD($%C=&EO;CH@.($UO=F5&:6QE1&%T85-P96-I86P-"C$X.C Y.C Q
M($5N9"!!8W1I;VX@.("!-;W9E1FEL941A=&$-"C$X.C Y.C Q(%-E=%)E9D-O
M=6YT.B!#.EQ724Y.5%QS>7-T96TS,EQN='=D8FQI8BYD;&P@.*#4I#0HQ.#HP
M.3HP,2!"96=I;B!!8W1I;VX@.4')O8V5S<T%F=&5R1&%T84UO= F4Z#0HQ.#HP
M.3HP,2!<7$-34$Q<4V]F='=A<F5<3W1H97)S7%-13#(P,#!<1$5614Q/?C%<
M6#@.V7$)I;FY<:&AC;VPN97AE($,Z7%!R;V=R86T@.1FEL97-<36EC<F]S;V9T
M(%-13"!397)V97)<.#!<5&]O;'-<0F]O:W,-"C$X.C Y.C R($5N9"!!8W1I
M;VX@.("!0<F]C97-S069T97)$871A36]V90T*,3@.Z,#DZ,#(@.0F5G:6X@.06-T
M:6]N($)U:6QD4V5R=F5R.@.T*,3@.Z,#DZ,#(@.0SI<1$]#54U%?C%<041-24Y)
M?C%<3$]#04Q3?C%<5&5M<%Q3<6Q3971U<%Q":6Y<<V-M+F5X92 @.+5-I;&5N
M=" Q("U!8W1I;VX@.-2 M17AE4&%T:" B1#I<4')O9W)A;2!&:6QE<UQ-:6-R
M;W-O9G0@.4U%,(%-E<G9E<EQ-4U-13"1#4U!,,DM<8FEN;EQS<6QS97)V<BYE
M>&4B("U397)V:6-E(")-4U-13"1#4U!,,DLB#0HQ.#HP.3HP,R!0<F]C97-S
M($5X:70@.0V]D93H@.*# I( T*,3@.Z,#DZ,#,@.0F5G:6X@.06-T:6]N.B!#<F5A
M=&5296=I<W1R>5-E=%-13 T*,3@.Z,#DZ,#,@.16YD($%C=&EO;CH@.0W)E871E
M4F5G:7-T<GE3971344P-"C$X.C Y.C S($)E9VEN($%C=&EO;CH@.4F5G5W)I
M=&53971U<$5N=')Y#0HQ.#HP.3HP,R!%;F0@.06-T:6]N.B!296=7<FET95-E
M='5P16YT<GD-"C$X.C Y.C S($)E9VEN($%C=&EO;CH@.0W)E871E4V5R#0HQ
M.#HP.3HP,R!%;F0@.06-T:6]N.B!#<F5A=&5397(-"C$X.C Y.C S($)E9VEN
M($%C=&EO;CH@.4VMU270-"C$X.C Y.C S($5N9"!!8W1I;VXZ(%-K=4ET#0HQ
M.#HP.3HP-"!3971&:6QE4V5C=7)I='E344Q!;F1!9&UI;B!F;W(@.1#I<4') O
M9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,(%-E<G9E<EQ-4U-13"1#4U!,,DL@.
M<F5T=7)N960Z(# L(# -"C$X.C Y.C T(%-E=%)E9U-E8W5R:71Y4U%,06YD
M061M:6X@.9F]R(%-O9G1W87)E7$UI8W)O<V]F=%Q-:6-R;W-O9G0@.4U%,(%-E
M<G9E<EQ#4U!,,DL@.<F5T=7)N960Z(# L(# -"C$X.C Y.C T($)E9VEN($%C
M=&EO;CH@.57!D871E4WES=&5M4&%T: T*,3@.Z,#DZ,#0@.4&%T:"!S=6-C97-S
M9G5L;'D@.=7!D871E9"X-"C$X.C Y.C T("5724XS,D1-25!!5$@.E7$))3CLE
M4WES=&5M4F]O="5<<WES=&5M,S([)5-Y<W1E;5)O;W0E.R53>7-T96U2;V]T
M)5Q3>7-T96TS,EQ78F5M.T0Z7%!R;V=R86T@.1FEL97-<35-344PW7$))3DX[
M0SI<4')O9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,(%-E<G9E<EPX,%Q4;V]L
M<UQ"24Y.#0HQ.#HP.3HP-"!%;F0@.06-T:6]N.B!5<&1A=&53>7-T96U0871H
M#0HQ.#HP.3HP-"!'<F%N="!2:6=H="!F;W(@.0TA%3%-/1E1<061M:6YI<W1R
M871O<B!R971U<FYE9" Z(#$L(# -"C$X.C Y.C T($=R86YT(%)I9VAT(&9O
M<B!#2$5,4T]&5%Q!9&UI;FES=')A=&]R(')E='5R;F5D(#H@.,2P@., T*,3@.Z
M,#DZ,#4@.1W)A;G0@.4FEG:'0@.9F]R($-(14Q33T947$%D;6EN:7-T<F%T;W(@.
M<F5T=7)N960@..B Q+" P#0HQ.#HP.3HP-2!'<F%N="!2:6=H="!F;W(@.0TA%
M3%-/1E1<061M:6YI<W1R871O<B!R971U<FYE9" Z(#$L(# -"C$X.C Y.C U
M($=R86YT(%)I9VAT(&9O<B!#2$5,4T]&5%Q!9&UI;FES=')A=&]R(')E='5R
M;F5D(#H@.,2P@., T*,3@.Z,#DZ,#8@.0SI<4')O9W)A;2!&:6QE<UQ-:6-R;W-O
M9G0@.4U%,(%-E<G9E<EPX,%Q4;V]L<UQ":6YN7&-N9F=S=G(N97AE(" M1B B
M0SI<5TE.3E1<<W%L<W1P+FQO9R(@.+4D@.0U-03#)+("U6(#$@.+4T@.," M42 B
M4U%,7TQA=&EN,5]'96YE<F%L7T-0,5]#25]!4R(@.+4@.@.,3DW,3(T("U5('-A
M("U0( T*(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C (R,C
M(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C( R,C(PT*#0H-
M"E-T87)T:6YG(%-E<G9I8V4@.+BXN#0H-"E-13%],871I;C%?1V5N97)A;%]#
M4#%?0TE?05,-"@.T*+6T@.+5$@.+50T,#(R("U4,S8U.0T*#0I#;VYN96-T:6YG
M('1O(%-E<G9E<B N+BX-"@.T*9')I=F5R/7MS<6P@.<V5R=F5R?3MS97)V97(]
M0U-03%Q#4U!,,DL[54E$/7-A.U!71#T[9&%T86)A<V4];6%S=&5R#0H-"EM-
M:6-R;W-O9G1=6T]$0D,@.4U%,(%-E<G9E<B!$<FEV97)=6U1#4"])4"!3;V-K
M971S74=E;F5R86P@.;F5T=V]R:R!E<G)O<BX@.0VAE8VL@.>6]U<B!N971W;W)K
M(&1O8W5M96YT871I;VXN#0H-"EM-:6-R;W-O9G1=6T]$0D,@.4U%,(%-E<G9E
M<B!$<FEV97)=6U1#4"])4"!3;V-K971S74-O;FYE8W1I;VY296%D("AR96-V
M*"DI+@.T*#0ID<FEV97(]>W-Q;"!S97)V97)].W-E<G9E<CU#4U!,7$-34$PR
M2SM5240]<V$[4%=$/3MD871A8F%S93UM87-T97(-"@.T*6TUI8W)O<V]F=%U;
M3T1"0R!344P@.4V5R=F5R($1R:79E<EU;5$-0+TE0(%-O8VME='-=1V5N97)A
M;"!N971W;W)K(&5R<F]R+B!#:&5C:R!Y;W5R(&YE='=O<FL@.9&]C=6UE;G1A
M=&EO;BX-"@.T*6TUI8W)O<V]F=%U;3T1"0R!344P@.4V5R=F5R($1R:79E<EU;
M5$-0+TE0(%-O8VME='-=0V]N;F5C=&EO;E)E860@.*')E8W8H*2DN#0H-"F1R
M:79E<CU[<W%L('-E<G9E<GT[<V5R=F5R/4-34$Q<0U-03#)+.U5)1#US83M0
M5T0].V1A=&%B87-E/6UA<W1E<@.T*#0I;36EC<F]S;V9T75M/1$)#(%-13"!3
M97)V97(@.1')I=F5R75M40U O25 @.4V]C:V5T<UU'96YE<F%L(&YE='=O<FL@.
M97)R;W(N($-H96-K('EO=7(@.;F5T=V]R:R!D;V-U;65N=&%T:6]N+@.T*#0I;
M36EC<F]S;V9T75M/1$)#(%-13"!397)V97(@.1')I=F5R75M40U O25 @.4V]C
M:V5T<UU#;VYN96-T:6]N4F5A9" H<F5C=B@.I*2X-"@.T*4U%,(%-E<G9E<B!C
M;VYF:6=U<F%T:6]N(&9A:6QE9"X-"@.T*(R,C(R,C(R,C(R,C(R,C(R,C(R,C
M(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C(R,C( R,C(R,C(R,C
M(R,C(R,C(R,C(R,C(PT*#0HQ.#HP.3HS,R!0<F]C97-S($5X:70@.0V]D93H@.
M*"TQ*2 -"C$X.C$X.C(Y(%-E='5P(&9A:6QE9"!T;R!C;VYF:6=U<F4@.=&AE
M('-E<G9E<BX@.("!2969E<B!T;R!T:&4@.<V5R=F5R(&5R<F]R(&QO9W,@.86YD
M($,Z7%=)3DY47'-Q;'-T<"YL;V<@.9F]R(&UO<F4@.:6YF;W)M871I;VXN#0HQ
M.#HQ.#HR.2!!8W1I;VX@.0VQE86Y5<$EN<W1A;&PZ#0HQ.#HQ. #HR.2!#.EQ$
M3T-5345^,5Q!1$U)3DE^,5Q,3T-!3%-^,5Q496UP7%-Q;%-E='5P7$)I;EQS
M8VTN97AE(" M4VEL96YT(#$@.+4%C=&EO;B T("U397)V:6-E(%-13$%G96YT
M)$-34$PR2PT*,3@.Z,3@.Z,CD@.4')O8V5S<R!%>&ET($-O9&4Z("@.Q,#8P*2!4
M:&4@.<W!E8VEF:65D('-E<G9I8V4@.9&]E<R!N;W0@.97AI<W0@.87,@.86X@.:6YS
M=&%L;&5D('-E<G9I8V4N#0H-"C$X.C$X.C(Y($,Z7$1/0U5-17XQ7$%$34E.
M27XQ7$Q/0T%,4WXQ7%1E;7!<4W%L4V5T=7!<0FEN7'-C;2YE>&4@.("U3:6QE
M;G0@.,2 M06-T:6]N(#0@.+5-E<G9I8V4@.35-344PD0U-03#)+#0HQ.#HQ.#HR
M.2!0<F]C97-S($5X:70@.0V]D93H@.*# I( T*,3@.Z,3@.Z,CD@.4W1A='-'96YE
M<F%T92!R971U<FYE9#H@.,@.T*,3@.Z,3@.Z,CD@.4W1A='-'96YE<F%T92 H,'@.R
M,C<L,'@.Q+#!X9C P+#!X,S P+#$P,S,L,S S+#!X,"PP>#$L,"PP+# -"C$X
M.C$X.C(Y(%-T871S1V5N97)A=&4@.+3$L061M:6YI<W1R871O<BD-"C$X.C$X
:.C(Y($EN<W1A;&QA=&EO;B!&86EL960N#0H`
`
end
You have a TCP/IP alias established created on your computer. Remove it and
setup should complete successfully. Setup starts SQL Server in a mode to
accept only shared memory connections. The alias is preventing setup from
connecting.
Run cliconfg from Start - Run. Go to the ALias tab and delete the alias for
this server, You do not need it. Or should not need it. If you do then
there is another problem that needs to be addressed.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Rand!
You the man! I was about to have a heart attack when i had uninstalled
our SQL Developer server and could not install Standard edition. Your
suggestion worked like a charm! Your advice is excellent even 6 months
later.
Blackened
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message537287.html
Showing posts with label friends. Show all posts
Showing posts with label friends. Show all posts
Friday, March 30, 2012
Problem in Insert
Dear Friends,
I am having one table which is giving problem while inserting the records
which is as follows:oops! u missed to explain ut problem
best Regards,
Chandra
http://www.SQLResource.com/
http://chanduas.blogspot.com/
---
*** Sent via Developersdex http://www.examnotes.net ***
I am having one table which is giving problem while inserting the records
which is as follows:oops! u missed to explain ut problem
best Regards,
Chandra
http://www.SQLResource.com/
http://chanduas.blogspot.com/
---
*** Sent via Developersdex http://www.examnotes.net ***
problem in filling a dataset using dataAdapter
hi friends,
i look forward an answer that solves my problem.
iam trying too populate a DropDown list . here is the codings. Previously it was working. suddenly,
it s generating error.
strConnectionString = "Provider = SQLOLEDB;Integrated Security=False; User ID=sa;Password=;Data Source=GIREESH-AC720F7;Initial Catalog=NorthWind"
in page_load event
dim sql as string
sql = "select AthleteNameKey from athletes"
result_adap = DbAccess.ExecuteAdaP(sql)
result_adap.Fill(result_ds, "athletes")
cboAthleteName.DataSource = "athletes"
cboAthleteName.DataTextField = "AthleteNameKey"
cboAthleteName.DataValueField = "AthleteNameKey"
cboAthleteName.DataBind()
PublicFunction ExecuteAdaP(ByVal sqlsAsString)As OleDbDataAdapter
'Dim ds As New OleDbDataAdapter
Dim daAsNew OleDbDataAdapter(sqls, strConnectionString)'da.Fill(ds)Return daEndFunction
What's the detailed error message? When the error occurs, can you do the same query using Query Analyzer?Wednesday, March 28, 2012
Problem in Drillthrough report
Hi Friends,
I am very new to MSSQL Reporting service 2005. I wanted to create a drithrough report. I have created a master report using a cube created using MSSQL Analysis service 2005. The master report contains a column called 'Territory', which details some other columns also. My child report contains the same 'Territory' column, but with displays some other detailed information. If I click on the territory column data on master report, it should take me to child report where it should show only Territory which matches with the master territory.
I have created both master & child reports. In my master report, Jump to Report, I have given the name of my child report. In my child report, if I have created a hidden parameter by providing available value through query. But while clicking the territory column master report I'm getting error parameter xxx is missing a value. If I uncheck as hidden parameter it pops up for the value & it works.
How to go about it, can someone help?
Thanks & Regards,
Naveen J V
Hi,
Its a long time ago as I had built my last report - but at the Jump to Report there is also a part where you map the Target Report Paramter to something of your current Report. There you have to specify the value for Target Report Parameter - your current Territory.
If you not specify the paramters it get set to the default parameter of null - which seems to be not allowed for your parameter.
It looks like this is more related to report server - I recommend you to post your question there if my hint does not help.
Mabe someone from MS moves it to the report server forum.
Best Regards
Hannes
Monday, March 26, 2012
Problem in Creating Trigger Sql Server 2000
Friends,
I have problem to creating a trigger.
In a trigger, i have check, if both inserted and deleted table has
row, then Check containt in both tables are same or not like this
Select Count(*) from inserted i , deleted d where i.cola = d.cola
and i.colb = d.colb
I have done it in some dynamically way, which can work for my all
tables, As code follows.
########
My Problem is, when following trigger execute, its return inserted
and deleted table does not exits.
#######
Update tm_empmastR1
Set empstatus = 'A'
Alter Trigger tr_tm_empmastR1 on tm_empmastR1
For Insert, Update, Delete
As
Declare @.ColName as VarChar(255),
@.Cmd as VarChar(8000)
Declare TCur Cursor For
Select SC.name
From sysobjects SO
Inner join syscolumns SC On SC.id = SO.id
And SO.name = 'tm_empmastR1'
order by colid
Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
Open TCur
Fetch Next From TCur Into @.ColName
While (@.@.Fetch_Status = 0)
Begin
Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
Fetch Next From TCur Into @.ColName
End
Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
Print (@.Cmd)
Exec (@.Cmd)
Close TCur
Deallocate TCur
#####
Although return Sql is runing perfectly.
#####
Thanks in advance for any reply.
Rahul Verma
FutureSoftDynamically executed SQL has its own context and doesn't have access to thes
e tables. I encourage
you to skip the dynamic SQL if at all possible. If not, you can have the out
er code populate a temp
table and then the inner (dynamic) code can access that temp table.
I would use the system tables/catalog views to generate the trigger code, fo
r instance.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rahul" <verma.career@.gmail.com> wrote in message
news:1172035114.793535.273980@.v33g2000cwv.googlegroups.com...
> Friends,
> I have problem to creating a trigger.
> In a trigger, i have check, if both inserted and deleted table has
> row, then Check containt in both tables are same or not like this
> Select Count(*) from inserted i , deleted d where i.cola = d.cola
> and i.colb = d.colb
> I have done it in some dynamically way, which can work for my all
> tables, As code follows.
> ########
> My Problem is, when following trigger execute, its return inserted
> and deleted table does not exits.
> #######
>
> Update tm_empmastR1
> Set empstatus = 'A'
> Alter Trigger tr_tm_empmastR1 on tm_empmastR1
> For Insert, Update, Delete
> As
> Declare @.ColName as VarChar(255),
> @.Cmd as VarChar(8000)
> Declare TCur Cursor For
> Select SC.name
> From sysobjects SO
> Inner join syscolumns SC On SC.id = SO.id
> And SO.name = 'tm_empmastR1'
> order by colid
> Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
> Open TCur
> Fetch Next From TCur Into @.ColName
> While (@.@.Fetch_Status = 0)
> Begin
> Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
> Fetch Next From TCur Into @.ColName
> End
> Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
> Print (@.Cmd)
> Exec (@.Cmd)
> Close TCur
> Deallocate TCur
>
> #####
> Although return Sql is runing perfectly.
> #####
>
> Thanks in advance for any reply.
> Rahul Verma
> FutureSoft
>|||Hi Rahul
"Rahul" wrote:
> Friends,
> I have problem to creating a trigger.
> In a trigger, i have check, if both inserted and deleted table has
> row, then Check containt in both tables are same or not like this
> Select Count(*) from inserted i , deleted d where i.cola = d.cola
> and i.colb = d.colb
> I have done it in some dynamically way, which can work for my all
> tables, As code follows.
> ########
> My Problem is, when following trigger execute, its return inserted
> and deleted table does not exits.
> #######
>
> Update tm_empmastR1
> Set empstatus = 'A'
> Alter Trigger tr_tm_empmastR1 on tm_empmastR1
> For Insert, Update, Delete
> As
> Declare @.ColName as VarChar(255),
> @.Cmd as VarChar(8000)
> Declare TCur Cursor For
> Select SC.name
> From sysobjects SO
> Inner join syscolumns SC On SC.id = SO.id
> And SO.name = 'tm_empmastR1'
> order by colid
> Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
> Open TCur
> Fetch Next From TCur Into @.ColName
> While (@.@.Fetch_Status = 0)
> Begin
> Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
> Fetch Next From TCur Into @.ColName
> End
> Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
> Print (@.Cmd)
> Exec (@.Cmd)
> Close TCur
> Deallocate TCur
>
> #####
> Although return Sql is runing perfectly.
> #####
>
> Thanks in advance for any reply.
> Rahul Verma
> FutureSoft
>
The dynamic SQL is in a different scope to the trigger, therefore the it
doesn't know about the inserted and deleted tables.
You should check @.@.ROWCOUNT as the first statement in the trigger to make
sure that there has been some changes.
All the cursor is doing is allowing you to avoid having to change the
trigger when your tables structure changes, on a mature system it will be
redundant and could potentially impact performance and could even cause a
bottleneck.
John|||On Feb 21, 1:17 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Rahul
>
>
> "Rahul" wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
> The dynamic SQL is in a different scope to the trigger, therefore the it
> doesn't know about the inserted and deleted tables.
> You should check @.@.ROWCOUNT as the first statement in the trigger to make
> sure that there has been some changes.
> All the cursor is doing is allowing you to avoid having to change the
> trigger when your tables structure changes, on a mature system it will be
> redundant and could potentially impact performance and could even cause a
> bottleneck.
> John- Hide quoted text -
> - Show quoted text -
Hi All
Thanks for reply.
Tibor Karaszi
i am not getting your idea,
trigger is called when we call update/insert/delete command
automatically and just after these statements.
So, we have not enough time to create and use a temp table.
If is it possible or any other idea, please mail me, Because we
require to create this type of modification with 100'th triggers, As i
am creating log.
Jhon,
This is right, if table structure change, cursor may be fail, that's
why i am using sysobject and syscolumns tables to getting all columns.
And when i use print statement, the return value of print statement
is absolutely correct and its working.
The @.@.rowcount only return no of rows in last query, its ok but
before this statement, i have to match all these fields in both table.
####
Actually my logic is
if both inserted and deleted tables contain row (ie row is updated)
and changes are actually made (ie changes must be done in any field in
a table) then insert this row in a log file with a particular flag.
else if only inserted table contain row then it insert with different
flag
same as with deleted.
####
if you have any idea to done it, please reply me
i have more than 1000 tables.
Thanks
Rahul|||Hi Rahul
"Rahul" wrote:
> On Feb 21, 1:17 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
>
> Hi All
> Thanks for reply.
> Tibor Karaszi
> i am not getting your idea,
> trigger is called when we call update/insert/delete command
> automatically and just after these statements.
> So, we have not enough time to create and use a temp table.
> If is it possible or any other idea, please mail me, Because we
> require to create this type of modification with 100'th triggers, As i
> am creating log.
>
> Jhon,
> This is right, if table structure change, cursor may be fail, that's
> why i am using sysobject and syscolumns tables to getting all columns.
> And when i use print statement, the return value of print statement
> is absolutely correct and its working.
> The @.@.rowcount only return no of rows in last query, its ok but
> before this statement, i have to match all these fields in both table.
> ####
> Actually my logic is
> if both inserted and deleted tables contain row (ie row is updated)
> and changes are actually made (ie changes must be done in any field in
> a table) then insert this row in a log file with a particular flag.
> else if only inserted table contain row then it insert with different
> flag
> same as with deleted.
> ####
> if you have any idea to done it, please reply me
> i have more than 1000 tables.
> Thanks
> Rahul
I think you have misunderstood both replies. I believe that Tibor is
suggesting that you generate your create trigger statements using the cursor
s
and you will end up with "hardcoded" columns for each table.
The checking of @.@.ROWCOUNT at the very begining of the trigger will mean
that you don't execute the code when not rows are changed, this will cut out
the unnecessary actions of the trigger.
Alter Trigger tr_tm_empmastR1 on tm_empmastR1 For Insert, Update, Delete
As
IF @.@.ROWCOUNT = 0 RETURN
...
John
I have problem to creating a trigger.
In a trigger, i have check, if both inserted and deleted table has
row, then Check containt in both tables are same or not like this
Select Count(*) from inserted i , deleted d where i.cola = d.cola
and i.colb = d.colb
I have done it in some dynamically way, which can work for my all
tables, As code follows.
########
My Problem is, when following trigger execute, its return inserted
and deleted table does not exits.
#######
Update tm_empmastR1
Set empstatus = 'A'
Alter Trigger tr_tm_empmastR1 on tm_empmastR1
For Insert, Update, Delete
As
Declare @.ColName as VarChar(255),
@.Cmd as VarChar(8000)
Declare TCur Cursor For
Select SC.name
From sysobjects SO
Inner join syscolumns SC On SC.id = SO.id
And SO.name = 'tm_empmastR1'
order by colid
Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
Open TCur
Fetch Next From TCur Into @.ColName
While (@.@.Fetch_Status = 0)
Begin
Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
Fetch Next From TCur Into @.ColName
End
Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
Print (@.Cmd)
Exec (@.Cmd)
Close TCur
Deallocate TCur
#####
Although return Sql is runing perfectly.
#####
Thanks in advance for any reply.
Rahul Verma
FutureSoftDynamically executed SQL has its own context and doesn't have access to thes
e tables. I encourage
you to skip the dynamic SQL if at all possible. If not, you can have the out
er code populate a temp
table and then the inner (dynamic) code can access that temp table.
I would use the system tables/catalog views to generate the trigger code, fo
r instance.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rahul" <verma.career@.gmail.com> wrote in message
news:1172035114.793535.273980@.v33g2000cwv.googlegroups.com...
> Friends,
> I have problem to creating a trigger.
> In a trigger, i have check, if both inserted and deleted table has
> row, then Check containt in both tables are same or not like this
> Select Count(*) from inserted i , deleted d where i.cola = d.cola
> and i.colb = d.colb
> I have done it in some dynamically way, which can work for my all
> tables, As code follows.
> ########
> My Problem is, when following trigger execute, its return inserted
> and deleted table does not exits.
> #######
>
> Update tm_empmastR1
> Set empstatus = 'A'
> Alter Trigger tr_tm_empmastR1 on tm_empmastR1
> For Insert, Update, Delete
> As
> Declare @.ColName as VarChar(255),
> @.Cmd as VarChar(8000)
> Declare TCur Cursor For
> Select SC.name
> From sysobjects SO
> Inner join syscolumns SC On SC.id = SO.id
> And SO.name = 'tm_empmastR1'
> order by colid
> Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
> Open TCur
> Fetch Next From TCur Into @.ColName
> While (@.@.Fetch_Status = 0)
> Begin
> Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
> Fetch Next From TCur Into @.ColName
> End
> Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
> Print (@.Cmd)
> Exec (@.Cmd)
> Close TCur
> Deallocate TCur
>
> #####
> Although return Sql is runing perfectly.
> #####
>
> Thanks in advance for any reply.
> Rahul Verma
> FutureSoft
>|||Hi Rahul
"Rahul" wrote:
> Friends,
> I have problem to creating a trigger.
> In a trigger, i have check, if both inserted and deleted table has
> row, then Check containt in both tables are same or not like this
> Select Count(*) from inserted i , deleted d where i.cola = d.cola
> and i.colb = d.colb
> I have done it in some dynamically way, which can work for my all
> tables, As code follows.
> ########
> My Problem is, when following trigger execute, its return inserted
> and deleted table does not exits.
> #######
>
> Update tm_empmastR1
> Set empstatus = 'A'
> Alter Trigger tr_tm_empmastR1 on tm_empmastR1
> For Insert, Update, Delete
> As
> Declare @.ColName as VarChar(255),
> @.Cmd as VarChar(8000)
> Declare TCur Cursor For
> Select SC.name
> From sysobjects SO
> Inner join syscolumns SC On SC.id = SO.id
> And SO.name = 'tm_empmastR1'
> order by colid
> Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
> Open TCur
> Fetch Next From TCur Into @.ColName
> While (@.@.Fetch_Status = 0)
> Begin
> Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
> Fetch Next From TCur Into @.ColName
> End
> Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
> Print (@.Cmd)
> Exec (@.Cmd)
> Close TCur
> Deallocate TCur
>
> #####
> Although return Sql is runing perfectly.
> #####
>
> Thanks in advance for any reply.
> Rahul Verma
> FutureSoft
>
The dynamic SQL is in a different scope to the trigger, therefore the it
doesn't know about the inserted and deleted tables.
You should check @.@.ROWCOUNT as the first statement in the trigger to make
sure that there has been some changes.
All the cursor is doing is allowing you to avoid having to change the
trigger when your tables structure changes, on a mature system it will be
redundant and could potentially impact performance and could even cause a
bottleneck.
John|||On Feb 21, 1:17 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Rahul
>
>
> "Rahul" wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
> The dynamic SQL is in a different scope to the trigger, therefore the it
> doesn't know about the inserted and deleted tables.
> You should check @.@.ROWCOUNT as the first statement in the trigger to make
> sure that there has been some changes.
> All the cursor is doing is allowing you to avoid having to change the
> trigger when your tables structure changes, on a mature system it will be
> redundant and could potentially impact performance and could even cause a
> bottleneck.
> John- Hide quoted text -
> - Show quoted text -
Hi All
Thanks for reply.
Tibor Karaszi
i am not getting your idea,
trigger is called when we call update/insert/delete command
automatically and just after these statements.
So, we have not enough time to create and use a temp table.
If is it possible or any other idea, please mail me, Because we
require to create this type of modification with 100'th triggers, As i
am creating log.
Jhon,
This is right, if table structure change, cursor may be fail, that's
why i am using sysobject and syscolumns tables to getting all columns.
And when i use print statement, the return value of print statement
is absolutely correct and its working.
The @.@.rowcount only return no of rows in last query, its ok but
before this statement, i have to match all these fields in both table.
####
Actually my logic is
if both inserted and deleted tables contain row (ie row is updated)
and changes are actually made (ie changes must be done in any field in
a table) then insert this row in a log file with a particular flag.
else if only inserted table contain row then it insert with different
flag
same as with deleted.
####
if you have any idea to done it, please reply me
i have more than 1000 tables.
Thanks
Rahul|||Hi Rahul
"Rahul" wrote:
> On Feb 21, 1:17 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
>
> Hi All
> Thanks for reply.
> Tibor Karaszi
> i am not getting your idea,
> trigger is called when we call update/insert/delete command
> automatically and just after these statements.
> So, we have not enough time to create and use a temp table.
> If is it possible or any other idea, please mail me, Because we
> require to create this type of modification with 100'th triggers, As i
> am creating log.
>
> Jhon,
> This is right, if table structure change, cursor may be fail, that's
> why i am using sysobject and syscolumns tables to getting all columns.
> And when i use print statement, the return value of print statement
> is absolutely correct and its working.
> The @.@.rowcount only return no of rows in last query, its ok but
> before this statement, i have to match all these fields in both table.
> ####
> Actually my logic is
> if both inserted and deleted tables contain row (ie row is updated)
> and changes are actually made (ie changes must be done in any field in
> a table) then insert this row in a log file with a particular flag.
> else if only inserted table contain row then it insert with different
> flag
> same as with deleted.
> ####
> if you have any idea to done it, please reply me
> i have more than 1000 tables.
> Thanks
> Rahul
I think you have misunderstood both replies. I believe that Tibor is
suggesting that you generate your create trigger statements using the cursor
s
and you will end up with "hardcoded" columns for each table.
The checking of @.@.ROWCOUNT at the very begining of the trigger will mean
that you don't execute the code when not rows are changed, this will cut out
the unnecessary actions of the trigger.
Alter Trigger tr_tm_empmastR1 on tm_empmastR1 For Insert, Update, Delete
As
IF @.@.ROWCOUNT = 0 RETURN
...
John
Problem in Creating Trigger Sql Server 2000
Friends,
I have problem to creating a trigger.
In a trigger, i have check, if both inserted and deleted table has
row, then Check containt in both tables are same or not like this
Select Count(*) from inserted i , deleted d where i.cola = d.cola
and i.colb = d.colb
I have done it in some dynamically way, which can work for my all
tables, As code follows.
########
My Problem is, when following trigger execute, its return inserted
and deleted table does not exits.
#######
Update tm_empmastR1
Set empstatus = 'A'
Alter Trigger tr_tm_empmastR1 on tm_empmastR1
For Insert, Update, Delete
As
Declare @.ColName as VarChar(255),
@.Cmdas VarChar(8000)
Declare TCur Cursor For
Select SC.name
From sysobjects SO
Inner join syscolumns SC On SC.id = SO.id
AndSO.name = 'tm_empmastR1'
order by colid
Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
Open TCur
Fetch Next From TCur Into @.ColName
While (@.@.Fetch_Status = 0)
Begin
Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
Fetch Next From TCur Into @.ColName
End
Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
Print (@.Cmd)
Exec (@.Cmd)
Close TCur
Deallocate TCur
#####
Although return Sql is runing perfectly.
#####
Thanks in advance for any reply.
Rahul Verma
FutureSoft
Hi Rahul
"Rahul" wrote:
> Friends,
> I have problem to creating a trigger.
> In a trigger, i have check, if both inserted and deleted table has
> row, then Check containt in both tables are same or not like this
> Select Count(*) from inserted i , deleted d where i.cola = d.cola
> and i.colb = d.colb
> I have done it in some dynamically way, which can work for my all
> tables, As code follows.
> ########
> My Problem is, when following trigger execute, its return inserted
> and deleted table does not exits.
> #######
>
> Update tm_empmastR1
> Set empstatus = 'A'
> Alter Trigger tr_tm_empmastR1 on tm_empmastR1
> For Insert, Update, Delete
> As
> Declare @.ColName as VarChar(255),
> @.Cmdas VarChar(8000)
> Declare TCur Cursor For
> Select SC.name
> From sysobjects SO
> Inner join syscolumns SC On SC.id = SO.id
> AndSO.name = 'tm_empmastR1'
> order by colid
> Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
> Open TCur
> Fetch Next From TCur Into @.ColName
> While (@.@.Fetch_Status = 0)
> Begin
> Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
> Fetch Next From TCur Into @.ColName
> End
> Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
> Print (@.Cmd)
> Exec (@.Cmd)
> Close TCur
> Deallocate TCur
>
> #####
> Although return Sql is runing perfectly.
> #####
>
> Thanks in advance for any reply.
> Rahul Verma
> FutureSoft
>
The dynamic SQL is in a different scope to the trigger, therefore the it
doesn't know about the inserted and deleted tables.
You should check @.@.ROWCOUNT as the first statement in the trigger to make
sure that there has been some changes.
All the cursor is doing is allowing you to avoid having to change the
trigger when your tables structure changes, on a mature system it will be
redundant and could potentially impact performance and could even cause a
bottleneck.
John
|||On Feb 21, 1:17 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Rahul
>
>
> "Rahul" wrote:
>
>
>
>
>
>
>
> The dynamic SQL is in a different scope to the trigger, therefore the it
> doesn't know about the inserted and deleted tables.
> You should check @.@.ROWCOUNT as the first statement in the trigger to make
> sure that there has been some changes.
> All the cursor is doing is allowing you to avoid having to change the
> trigger when your tables structure changes, on a mature system it will be
> redundant and could potentially impact performance and could even cause a
> bottleneck.
> John- Hide quoted text -
> - Show quoted text -
Hi All
Thanks for reply.
Tibor Karaszi
i am not getting your idea,
trigger is called when we call update/insert/delete command
automatically and just after these statements.
So, we have not enough time to create and use a temp table.
If is it possible or any other idea, please mail me, Because we
require to create this type of modification with 100'th triggers, As i
am creating log.
Jhon,
This is right, if table structure change, cursor may be fail, that's
why i am using sysobject and syscolumns tables to getting all columns.
And when i use print statement, the return value of print statement
is absolutely correct and its working.
The @.@.rowcount only return no of rows in last query, its ok but
before this statement, i have to match all these fields in both table.
####
Actually my logic is
if both inserted and deleted tables contain row (ie row is updated)
and changes are actually made (ie changes must be done in any field in
a table) then insert this row in a log file with a particular flag.
else if only inserted table contain row then it insert with different
flag
same as with deleted.
####
if you have any idea to done it, please reply me
i have more than 1000 tables.
Thanks
Rahul
|||Hi Rahul
"Rahul" wrote:
> On Feb 21, 1:17 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
>
> Hi All
> Thanks for reply.
> Tibor Karaszi
> i am not getting your idea,
> trigger is called when we call update/insert/delete command
> automatically and just after these statements.
> So, we have not enough time to create and use a temp table.
> If is it possible or any other idea, please mail me, Because we
> require to create this type of modification with 100'th triggers, As i
> am creating log.
>
> Jhon,
> This is right, if table structure change, cursor may be fail, that's
> why i am using sysobject and syscolumns tables to getting all columns.
> And when i use print statement, the return value of print statement
> is absolutely correct and its working.
> The @.@.rowcount only return no of rows in last query, its ok but
> before this statement, i have to match all these fields in both table.
> ####
> Actually my logic is
> if both inserted and deleted tables contain row (ie row is updated)
> and changes are actually made (ie changes must be done in any field in
> a table) then insert this row in a log file with a particular flag.
> else if only inserted table contain row then it insert with different
> flag
> same as with deleted.
> ####
> if you have any idea to done it, please reply me
> i have more than 1000 tables.
> Thanks
> Rahul
I think you have misunderstood both replies. I believe that Tibor is
suggesting that you generate your create trigger statements using the cursors
and you will end up with "hardcoded" columns for each table.
The checking of @.@.ROWCOUNT at the very begining of the trigger will mean
that you don't execute the code when not rows are changed, this will cut out
the unnecessary actions of the trigger.
Alter Trigger tr_tm_empmastR1 on tm_empmastR1 For Insert, Update, Delete
As
IF @.@.ROWCOUNT = 0 RETURN
...
John
I have problem to creating a trigger.
In a trigger, i have check, if both inserted and deleted table has
row, then Check containt in both tables are same or not like this
Select Count(*) from inserted i , deleted d where i.cola = d.cola
and i.colb = d.colb
I have done it in some dynamically way, which can work for my all
tables, As code follows.
########
My Problem is, when following trigger execute, its return inserted
and deleted table does not exits.
#######
Update tm_empmastR1
Set empstatus = 'A'
Alter Trigger tr_tm_empmastR1 on tm_empmastR1
For Insert, Update, Delete
As
Declare @.ColName as VarChar(255),
@.Cmdas VarChar(8000)
Declare TCur Cursor For
Select SC.name
From sysobjects SO
Inner join syscolumns SC On SC.id = SO.id
AndSO.name = 'tm_empmastR1'
order by colid
Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
Open TCur
Fetch Next From TCur Into @.ColName
While (@.@.Fetch_Status = 0)
Begin
Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
Fetch Next From TCur Into @.ColName
End
Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
Print (@.Cmd)
Exec (@.Cmd)
Close TCur
Deallocate TCur
#####
Although return Sql is runing perfectly.
#####
Thanks in advance for any reply.
Rahul Verma
FutureSoft
Hi Rahul
"Rahul" wrote:
> Friends,
> I have problem to creating a trigger.
> In a trigger, i have check, if both inserted and deleted table has
> row, then Check containt in both tables are same or not like this
> Select Count(*) from inserted i , deleted d where i.cola = d.cola
> and i.colb = d.colb
> I have done it in some dynamically way, which can work for my all
> tables, As code follows.
> ########
> My Problem is, when following trigger execute, its return inserted
> and deleted table does not exits.
> #######
>
> Update tm_empmastR1
> Set empstatus = 'A'
> Alter Trigger tr_tm_empmastR1 on tm_empmastR1
> For Insert, Update, Delete
> As
> Declare @.ColName as VarChar(255),
> @.Cmdas VarChar(8000)
> Declare TCur Cursor For
> Select SC.name
> From sysobjects SO
> Inner join syscolumns SC On SC.id = SO.id
> AndSO.name = 'tm_empmastR1'
> order by colid
> Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
> Open TCur
> Fetch Next From TCur Into @.ColName
> While (@.@.Fetch_Status = 0)
> Begin
> Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
> Fetch Next From TCur Into @.ColName
> End
> Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
> Print (@.Cmd)
> Exec (@.Cmd)
> Close TCur
> Deallocate TCur
>
> #####
> Although return Sql is runing perfectly.
> #####
>
> Thanks in advance for any reply.
> Rahul Verma
> FutureSoft
>
The dynamic SQL is in a different scope to the trigger, therefore the it
doesn't know about the inserted and deleted tables.
You should check @.@.ROWCOUNT as the first statement in the trigger to make
sure that there has been some changes.
All the cursor is doing is allowing you to avoid having to change the
trigger when your tables structure changes, on a mature system it will be
redundant and could potentially impact performance and could even cause a
bottleneck.
John
|||On Feb 21, 1:17 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Rahul
>
>
> "Rahul" wrote:
>
>
>
>
>
>
>
> The dynamic SQL is in a different scope to the trigger, therefore the it
> doesn't know about the inserted and deleted tables.
> You should check @.@.ROWCOUNT as the first statement in the trigger to make
> sure that there has been some changes.
> All the cursor is doing is allowing you to avoid having to change the
> trigger when your tables structure changes, on a mature system it will be
> redundant and could potentially impact performance and could even cause a
> bottleneck.
> John- Hide quoted text -
> - Show quoted text -
Hi All
Thanks for reply.
Tibor Karaszi
i am not getting your idea,
trigger is called when we call update/insert/delete command
automatically and just after these statements.
So, we have not enough time to create and use a temp table.
If is it possible or any other idea, please mail me, Because we
require to create this type of modification with 100'th triggers, As i
am creating log.
Jhon,
This is right, if table structure change, cursor may be fail, that's
why i am using sysobject and syscolumns tables to getting all columns.
And when i use print statement, the return value of print statement
is absolutely correct and its working.
The @.@.rowcount only return no of rows in last query, its ok but
before this statement, i have to match all these fields in both table.
####
Actually my logic is
if both inserted and deleted tables contain row (ie row is updated)
and changes are actually made (ie changes must be done in any field in
a table) then insert this row in a log file with a particular flag.
else if only inserted table contain row then it insert with different
flag
same as with deleted.
####
if you have any idea to done it, please reply me
i have more than 1000 tables.
Thanks
Rahul
|||Hi Rahul
"Rahul" wrote:
> On Feb 21, 1:17 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
>
> Hi All
> Thanks for reply.
> Tibor Karaszi
> i am not getting your idea,
> trigger is called when we call update/insert/delete command
> automatically and just after these statements.
> So, we have not enough time to create and use a temp table.
> If is it possible or any other idea, please mail me, Because we
> require to create this type of modification with 100'th triggers, As i
> am creating log.
>
> Jhon,
> This is right, if table structure change, cursor may be fail, that's
> why i am using sysobject and syscolumns tables to getting all columns.
> And when i use print statement, the return value of print statement
> is absolutely correct and its working.
> The @.@.rowcount only return no of rows in last query, its ok but
> before this statement, i have to match all these fields in both table.
> ####
> Actually my logic is
> if both inserted and deleted tables contain row (ie row is updated)
> and changes are actually made (ie changes must be done in any field in
> a table) then insert this row in a log file with a particular flag.
> else if only inserted table contain row then it insert with different
> flag
> same as with deleted.
> ####
> if you have any idea to done it, please reply me
> i have more than 1000 tables.
> Thanks
> Rahul
I think you have misunderstood both replies. I believe that Tibor is
suggesting that you generate your create trigger statements using the cursors
and you will end up with "hardcoded" columns for each table.
The checking of @.@.ROWCOUNT at the very begining of the trigger will mean
that you don't execute the code when not rows are changed, this will cut out
the unnecessary actions of the trigger.
Alter Trigger tr_tm_empmastR1 on tm_empmastR1 For Insert, Update, Delete
As
IF @.@.ROWCOUNT = 0 RETURN
...
John
Problem in Creating Trigger Sql Server 2000
Friends,
I have problem to creating a trigger.
In a trigger, i have check, if both inserted and deleted table has
row, then Check containt in both tables are same or not like this
Select Count(*) from inserted i , deleted d where i.cola = d.cola
and i.colb = d.colb
I have done it in some dynamically way, which can work for my all
tables, As code follows.
########
My Problem is, when following trigger execute, its return inserted
and deleted table does not exits.
#######
Update tm_empmastR1
Set empstatus = 'A'
Alter Trigger tr_tm_empmastR1 on tm_empmastR1
For Insert, Update, Delete
As
Declare @.ColName as VarChar(255),
@.Cmd as VarChar(8000)
Declare TCur Cursor For
Select SC.name
From sysobjects SO
Inner join syscolumns SC On SC.id = SO.id
And SO.name = 'tm_empmastR1'
order by colid
Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
Open TCur
Fetch Next From TCur Into @.ColName
While (@.@.Fetch_Status = 0)
Begin
Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
Fetch Next From TCur Into @.ColName
End
Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
Print (@.Cmd)
Exec (@.Cmd)
Close TCur
Deallocate TCur
#####
Although return Sql is runing perfectly.
#####
Thanks in advance for any reply.
Rahul Verma
FutureSoftDynamically executed SQL has its own context and doesn't have access to these tables. I encourage
you to skip the dynamic SQL if at all possible. If not, you can have the outer code populate a temp
table and then the inner (dynamic) code can access that temp table.
I would use the system tables/catalog views to generate the trigger code, for instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rahul" <verma.career@.gmail.com> wrote in message
news:1172035114.793535.273980@.v33g2000cwv.googlegroups.com...
> Friends,
> I have problem to creating a trigger.
> In a trigger, i have check, if both inserted and deleted table has
> row, then Check containt in both tables are same or not like this
> Select Count(*) from inserted i , deleted d where i.cola = d.cola
> and i.colb = d.colb
> I have done it in some dynamically way, which can work for my all
> tables, As code follows.
> ########
> My Problem is, when following trigger execute, its return inserted
> and deleted table does not exits.
> #######
>
> Update tm_empmastR1
> Set empstatus = 'A'
> Alter Trigger tr_tm_empmastR1 on tm_empmastR1
> For Insert, Update, Delete
> As
> Declare @.ColName as VarChar(255),
> @.Cmd as VarChar(8000)
> Declare TCur Cursor For
> Select SC.name
> From sysobjects SO
> Inner join syscolumns SC On SC.id = SO.id
> And SO.name = 'tm_empmastR1'
> order by colid
> Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
> Open TCur
> Fetch Next From TCur Into @.ColName
> While (@.@.Fetch_Status = 0)
> Begin
> Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
> Fetch Next From TCur Into @.ColName
> End
> Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
> Print (@.Cmd)
> Exec (@.Cmd)
> Close TCur
> Deallocate TCur
>
> #####
> Although return Sql is runing perfectly.
> #####
>
> Thanks in advance for any reply.
> Rahul Verma
> FutureSoft
>|||Hi Rahul
"Rahul" wrote:
> Friends,
> I have problem to creating a trigger.
> In a trigger, i have check, if both inserted and deleted table has
> row, then Check containt in both tables are same or not like this
> Select Count(*) from inserted i , deleted d where i.cola = d.cola
> and i.colb = d.colb
> I have done it in some dynamically way, which can work for my all
> tables, As code follows.
> ########
> My Problem is, when following trigger execute, its return inserted
> and deleted table does not exits.
> #######
>
> Update tm_empmastR1
> Set empstatus = 'A'
> Alter Trigger tr_tm_empmastR1 on tm_empmastR1
> For Insert, Update, Delete
> As
> Declare @.ColName as VarChar(255),
> @.Cmd as VarChar(8000)
> Declare TCur Cursor For
> Select SC.name
> From sysobjects SO
> Inner join syscolumns SC On SC.id = SO.id
> And SO.name = 'tm_empmastR1'
> order by colid
> Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
> Open TCur
> Fetch Next From TCur Into @.ColName
> While (@.@.Fetch_Status = 0)
> Begin
> Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
> Fetch Next From TCur Into @.ColName
> End
> Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
> Print (@.Cmd)
> Exec (@.Cmd)
> Close TCur
> Deallocate TCur
>
> #####
> Although return Sql is runing perfectly.
> #####
>
> Thanks in advance for any reply.
> Rahul Verma
> FutureSoft
>
The dynamic SQL is in a different scope to the trigger, therefore the it
doesn't know about the inserted and deleted tables.
You should check @.@.ROWCOUNT as the first statement in the trigger to make
sure that there has been some changes.
All the cursor is doing is allowing you to avoid having to change the
trigger when your tables structure changes, on a mature system it will be
redundant and could potentially impact performance and could even cause a
bottleneck.
John|||On Feb 21, 1:17 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Rahul
>
>
> "Rahul" wrote:
> > Friends,
> > I have problem to creating a trigger.
> > In a trigger, i have check, if both inserted and deleted table has
> > row, then Check containt in both tables are same or not like this
> > Select Count(*) from inserted i , deleted d where i.cola = d.cola
> > and i.colb = d.colb
> > I have done it in some dynamically way, which can work for my all
> > tables, As code follows.
> > ########
> > My Problem is, when following trigger execute, its return inserted
> > and deleted table does not exits.
> > #######
> > Update tm_empmastR1
> > Set empstatus = 'A'
> > Alter Trigger tr_tm_empmastR1 on tm_empmastR1
> > For Insert, Update, Delete
> > As
> > Declare @.ColName as VarChar(255),
> > @.Cmd as VarChar(8000)
> > Declare TCur Cursor For
> > Select SC.name
> > From sysobjects SO
> > Inner join syscolumns SC On SC.id = SO.id
> > And SO.name = 'tm_empmastR1'
> > order by colid
> > Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
> > Open TCur
> > Fetch Next From TCur Into @.ColName
> > While (@.@.Fetch_Status = 0)
> > Begin
> > Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
> > Fetch Next From TCur Into @.ColName
> > End
> > Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
> > Print (@.Cmd)
> > Exec (@.Cmd)
> > Close TCur
> > Deallocate TCur
> > #####
> > Although return Sql is runing perfectly.
> > #####
> > Thanks in advance for any reply.
> > Rahul Verma
> > FutureSoft
> The dynamic SQL is in a different scope to the trigger, therefore the it
> doesn't know about the inserted and deleted tables.
> You should check @.@.ROWCOUNT as the first statement in the trigger to make
> sure that there has been some changes.
> All the cursor is doing is allowing you to avoid having to change the
> trigger when your tables structure changes, on a mature system it will be
> redundant and could potentially impact performance and could even cause a
> bottleneck.
> John- Hide quoted text -
> - Show quoted text -
Hi All
Thanks for reply.
Tibor Karaszi
i am not getting your idea,
trigger is called when we call update/insert/delete command
automatically and just after these statements.
So, we have not enough time to create and use a temp table.
If is it possible or any other idea, please mail me, Because we
require to create this type of modification with 100'th triggers, As i
am creating log.
Jhon,
This is right, if table structure change, cursor may be fail, that's
why i am using sysobject and syscolumns tables to getting all columns.
And when i use print statement, the return value of print statement
is absolutely correct and its working.
The @.@.rowcount only return no of rows in last query, its ok but
before this statement, i have to match all these fields in both table.
####
Actually my logic is
if both inserted and deleted tables contain row (ie row is updated)
and changes are actually made (ie changes must be done in any field in
a table) then insert this row in a log file with a particular flag.
else if only inserted table contain row then it insert with different
flag
same as with deleted.
####
if you have any idea to done it, please reply me
i have more than 1000 tables.
Thanks
Rahul|||Hi Rahul
"Rahul" wrote:
> On Feb 21, 1:17 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> > Hi Rahul
> >
> >
> >
> >
> >
> > "Rahul" wrote:
> > > Friends,
> > > I have problem to creating a trigger.
> > > In a trigger, i have check, if both inserted and deleted table has
> > > row, then Check containt in both tables are same or not like this
> >
> > > Select Count(*) from inserted i , deleted d where i.cola = d.cola
> > > and i.colb = d.colb
> >
> > > I have done it in some dynamically way, which can work for my all
> > > tables, As code follows.
> >
> > > ########
> > > My Problem is, when following trigger execute, its return inserted
> > > and deleted table does not exits.
> > > #######
> >
> > > Update tm_empmastR1
> > > Set empstatus = 'A'
> >
> > > Alter Trigger tr_tm_empmastR1 on tm_empmastR1
> > > For Insert, Update, Delete
> > > As
> >
> > > Declare @.ColName as VarChar(255),
> > > @.Cmd as VarChar(8000)
> >
> > > Declare TCur Cursor For
> > > Select SC.name
> > > From sysobjects SO
> > > Inner join syscolumns SC On SC.id = SO.id
> > > And SO.name = 'tm_empmastR1'
> > > order by colid
> >
> > > Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
> > > Open TCur
> > > Fetch Next From TCur Into @.ColName
> > > While (@.@.Fetch_Status = 0)
> > > Begin
> > > Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
> > > Fetch Next From TCur Into @.ColName
> > > End
> >
> > > Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
> > > Print (@.Cmd)
> > > Exec (@.Cmd)
> >
> > > Close TCur
> > > Deallocate TCur
> >
> > > #####
> > > Although return Sql is runing perfectly.
> > > #####
> >
> > > Thanks in advance for any reply.
> >
> > > Rahul Verma
> > > FutureSoft
> >
> > The dynamic SQL is in a different scope to the trigger, therefore the it
> > doesn't know about the inserted and deleted tables.
> >
> > You should check @.@.ROWCOUNT as the first statement in the trigger to make
> > sure that there has been some changes.
> >
> > All the cursor is doing is allowing you to avoid having to change the
> > trigger when your tables structure changes, on a mature system it will be
> > redundant and could potentially impact performance and could even cause a
> > bottleneck.
> >
> > John- Hide quoted text -
> >
> > - Show quoted text -
>
> Hi All
> Thanks for reply.
> Tibor Karaszi
> i am not getting your idea,
> trigger is called when we call update/insert/delete command
> automatically and just after these statements.
> So, we have not enough time to create and use a temp table.
> If is it possible or any other idea, please mail me, Because we
> require to create this type of modification with 100'th triggers, As i
> am creating log.
>
> Jhon,
> This is right, if table structure change, cursor may be fail, that's
> why i am using sysobject and syscolumns tables to getting all columns.
> And when i use print statement, the return value of print statement
> is absolutely correct and its working.
> The @.@.rowcount only return no of rows in last query, its ok but
> before this statement, i have to match all these fields in both table.
> ####
> Actually my logic is
> if both inserted and deleted tables contain row (ie row is updated)
> and changes are actually made (ie changes must be done in any field in
> a table) then insert this row in a log file with a particular flag.
> else if only inserted table contain row then it insert with different
> flag
> same as with deleted.
> ####
> if you have any idea to done it, please reply me
> i have more than 1000 tables.
> Thanks
> Rahul
I think you have misunderstood both replies. I believe that Tibor is
suggesting that you generate your create trigger statements using the cursors
and you will end up with "hardcoded" columns for each table.
The checking of @.@.ROWCOUNT at the very begining of the trigger will mean
that you don't execute the code when not rows are changed, this will cut out
the unnecessary actions of the trigger.
Alter Trigger tr_tm_empmastR1 on tm_empmastR1 For Insert, Update, Delete
As
IF @.@.ROWCOUNT = 0 RETURN
...
John
I have problem to creating a trigger.
In a trigger, i have check, if both inserted and deleted table has
row, then Check containt in both tables are same or not like this
Select Count(*) from inserted i , deleted d where i.cola = d.cola
and i.colb = d.colb
I have done it in some dynamically way, which can work for my all
tables, As code follows.
########
My Problem is, when following trigger execute, its return inserted
and deleted table does not exits.
#######
Update tm_empmastR1
Set empstatus = 'A'
Alter Trigger tr_tm_empmastR1 on tm_empmastR1
For Insert, Update, Delete
As
Declare @.ColName as VarChar(255),
@.Cmd as VarChar(8000)
Declare TCur Cursor For
Select SC.name
From sysobjects SO
Inner join syscolumns SC On SC.id = SO.id
And SO.name = 'tm_empmastR1'
order by colid
Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
Open TCur
Fetch Next From TCur Into @.ColName
While (@.@.Fetch_Status = 0)
Begin
Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
Fetch Next From TCur Into @.ColName
End
Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
Print (@.Cmd)
Exec (@.Cmd)
Close TCur
Deallocate TCur
#####
Although return Sql is runing perfectly.
#####
Thanks in advance for any reply.
Rahul Verma
FutureSoftDynamically executed SQL has its own context and doesn't have access to these tables. I encourage
you to skip the dynamic SQL if at all possible. If not, you can have the outer code populate a temp
table and then the inner (dynamic) code can access that temp table.
I would use the system tables/catalog views to generate the trigger code, for instance.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Rahul" <verma.career@.gmail.com> wrote in message
news:1172035114.793535.273980@.v33g2000cwv.googlegroups.com...
> Friends,
> I have problem to creating a trigger.
> In a trigger, i have check, if both inserted and deleted table has
> row, then Check containt in both tables are same or not like this
> Select Count(*) from inserted i , deleted d where i.cola = d.cola
> and i.colb = d.colb
> I have done it in some dynamically way, which can work for my all
> tables, As code follows.
> ########
> My Problem is, when following trigger execute, its return inserted
> and deleted table does not exits.
> #######
>
> Update tm_empmastR1
> Set empstatus = 'A'
> Alter Trigger tr_tm_empmastR1 on tm_empmastR1
> For Insert, Update, Delete
> As
> Declare @.ColName as VarChar(255),
> @.Cmd as VarChar(8000)
> Declare TCur Cursor For
> Select SC.name
> From sysobjects SO
> Inner join syscolumns SC On SC.id = SO.id
> And SO.name = 'tm_empmastR1'
> order by colid
> Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
> Open TCur
> Fetch Next From TCur Into @.ColName
> While (@.@.Fetch_Status = 0)
> Begin
> Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
> Fetch Next From TCur Into @.ColName
> End
> Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
> Print (@.Cmd)
> Exec (@.Cmd)
> Close TCur
> Deallocate TCur
>
> #####
> Although return Sql is runing perfectly.
> #####
>
> Thanks in advance for any reply.
> Rahul Verma
> FutureSoft
>|||Hi Rahul
"Rahul" wrote:
> Friends,
> I have problem to creating a trigger.
> In a trigger, i have check, if both inserted and deleted table has
> row, then Check containt in both tables are same or not like this
> Select Count(*) from inserted i , deleted d where i.cola = d.cola
> and i.colb = d.colb
> I have done it in some dynamically way, which can work for my all
> tables, As code follows.
> ########
> My Problem is, when following trigger execute, its return inserted
> and deleted table does not exits.
> #######
>
> Update tm_empmastR1
> Set empstatus = 'A'
> Alter Trigger tr_tm_empmastR1 on tm_empmastR1
> For Insert, Update, Delete
> As
> Declare @.ColName as VarChar(255),
> @.Cmd as VarChar(8000)
> Declare TCur Cursor For
> Select SC.name
> From sysobjects SO
> Inner join syscolumns SC On SC.id = SO.id
> And SO.name = 'tm_empmastR1'
> order by colid
> Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
> Open TCur
> Fetch Next From TCur Into @.ColName
> While (@.@.Fetch_Status = 0)
> Begin
> Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
> Fetch Next From TCur Into @.ColName
> End
> Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
> Print (@.Cmd)
> Exec (@.Cmd)
> Close TCur
> Deallocate TCur
>
> #####
> Although return Sql is runing perfectly.
> #####
>
> Thanks in advance for any reply.
> Rahul Verma
> FutureSoft
>
The dynamic SQL is in a different scope to the trigger, therefore the it
doesn't know about the inserted and deleted tables.
You should check @.@.ROWCOUNT as the first statement in the trigger to make
sure that there has been some changes.
All the cursor is doing is allowing you to avoid having to change the
trigger when your tables structure changes, on a mature system it will be
redundant and could potentially impact performance and could even cause a
bottleneck.
John|||On Feb 21, 1:17 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Rahul
>
>
> "Rahul" wrote:
> > Friends,
> > I have problem to creating a trigger.
> > In a trigger, i have check, if both inserted and deleted table has
> > row, then Check containt in both tables are same or not like this
> > Select Count(*) from inserted i , deleted d where i.cola = d.cola
> > and i.colb = d.colb
> > I have done it in some dynamically way, which can work for my all
> > tables, As code follows.
> > ########
> > My Problem is, when following trigger execute, its return inserted
> > and deleted table does not exits.
> > #######
> > Update tm_empmastR1
> > Set empstatus = 'A'
> > Alter Trigger tr_tm_empmastR1 on tm_empmastR1
> > For Insert, Update, Delete
> > As
> > Declare @.ColName as VarChar(255),
> > @.Cmd as VarChar(8000)
> > Declare TCur Cursor For
> > Select SC.name
> > From sysobjects SO
> > Inner join syscolumns SC On SC.id = SO.id
> > And SO.name = 'tm_empmastR1'
> > order by colid
> > Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
> > Open TCur
> > Fetch Next From TCur Into @.ColName
> > While (@.@.Fetch_Status = 0)
> > Begin
> > Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
> > Fetch Next From TCur Into @.ColName
> > End
> > Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
> > Print (@.Cmd)
> > Exec (@.Cmd)
> > Close TCur
> > Deallocate TCur
> > #####
> > Although return Sql is runing perfectly.
> > #####
> > Thanks in advance for any reply.
> > Rahul Verma
> > FutureSoft
> The dynamic SQL is in a different scope to the trigger, therefore the it
> doesn't know about the inserted and deleted tables.
> You should check @.@.ROWCOUNT as the first statement in the trigger to make
> sure that there has been some changes.
> All the cursor is doing is allowing you to avoid having to change the
> trigger when your tables structure changes, on a mature system it will be
> redundant and could potentially impact performance and could even cause a
> bottleneck.
> John- Hide quoted text -
> - Show quoted text -
Hi All
Thanks for reply.
Tibor Karaszi
i am not getting your idea,
trigger is called when we call update/insert/delete command
automatically and just after these statements.
So, we have not enough time to create and use a temp table.
If is it possible or any other idea, please mail me, Because we
require to create this type of modification with 100'th triggers, As i
am creating log.
Jhon,
This is right, if table structure change, cursor may be fail, that's
why i am using sysobject and syscolumns tables to getting all columns.
And when i use print statement, the return value of print statement
is absolutely correct and its working.
The @.@.rowcount only return no of rows in last query, its ok but
before this statement, i have to match all these fields in both table.
####
Actually my logic is
if both inserted and deleted tables contain row (ie row is updated)
and changes are actually made (ie changes must be done in any field in
a table) then insert this row in a log file with a particular flag.
else if only inserted table contain row then it insert with different
flag
same as with deleted.
####
if you have any idea to done it, please reply me
i have more than 1000 tables.
Thanks
Rahul|||Hi Rahul
"Rahul" wrote:
> On Feb 21, 1:17 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> > Hi Rahul
> >
> >
> >
> >
> >
> > "Rahul" wrote:
> > > Friends,
> > > I have problem to creating a trigger.
> > > In a trigger, i have check, if both inserted and deleted table has
> > > row, then Check containt in both tables are same or not like this
> >
> > > Select Count(*) from inserted i , deleted d where i.cola = d.cola
> > > and i.colb = d.colb
> >
> > > I have done it in some dynamically way, which can work for my all
> > > tables, As code follows.
> >
> > > ########
> > > My Problem is, when following trigger execute, its return inserted
> > > and deleted table does not exits.
> > > #######
> >
> > > Update tm_empmastR1
> > > Set empstatus = 'A'
> >
> > > Alter Trigger tr_tm_empmastR1 on tm_empmastR1
> > > For Insert, Update, Delete
> > > As
> >
> > > Declare @.ColName as VarChar(255),
> > > @.Cmd as VarChar(8000)
> >
> > > Declare TCur Cursor For
> > > Select SC.name
> > > From sysobjects SO
> > > Inner join syscolumns SC On SC.id = SO.id
> > > And SO.name = 'tm_empmastR1'
> > > order by colid
> >
> > > Select @.Cmd = 'Select Count(*) From inserted I, deleted D Where '
> > > Open TCur
> > > Fetch Next From TCur Into @.ColName
> > > While (@.@.Fetch_Status = 0)
> > > Begin
> > > Set @.Cmd = @.Cmd + 'I.' + @.ColName + ' = D.' + @.ColName + ' And '
> > > Fetch Next From TCur Into @.ColName
> > > End
> >
> > > Set @.Cmd = SubString(@.Cmd, 1, len(@.Cmd) - 4)
> > > Print (@.Cmd)
> > > Exec (@.Cmd)
> >
> > > Close TCur
> > > Deallocate TCur
> >
> > > #####
> > > Although return Sql is runing perfectly.
> > > #####
> >
> > > Thanks in advance for any reply.
> >
> > > Rahul Verma
> > > FutureSoft
> >
> > The dynamic SQL is in a different scope to the trigger, therefore the it
> > doesn't know about the inserted and deleted tables.
> >
> > You should check @.@.ROWCOUNT as the first statement in the trigger to make
> > sure that there has been some changes.
> >
> > All the cursor is doing is allowing you to avoid having to change the
> > trigger when your tables structure changes, on a mature system it will be
> > redundant and could potentially impact performance and could even cause a
> > bottleneck.
> >
> > John- Hide quoted text -
> >
> > - Show quoted text -
>
> Hi All
> Thanks for reply.
> Tibor Karaszi
> i am not getting your idea,
> trigger is called when we call update/insert/delete command
> automatically and just after these statements.
> So, we have not enough time to create and use a temp table.
> If is it possible or any other idea, please mail me, Because we
> require to create this type of modification with 100'th triggers, As i
> am creating log.
>
> Jhon,
> This is right, if table structure change, cursor may be fail, that's
> why i am using sysobject and syscolumns tables to getting all columns.
> And when i use print statement, the return value of print statement
> is absolutely correct and its working.
> The @.@.rowcount only return no of rows in last query, its ok but
> before this statement, i have to match all these fields in both table.
> ####
> Actually my logic is
> if both inserted and deleted tables contain row (ie row is updated)
> and changes are actually made (ie changes must be done in any field in
> a table) then insert this row in a log file with a particular flag.
> else if only inserted table contain row then it insert with different
> flag
> same as with deleted.
> ####
> if you have any idea to done it, please reply me
> i have more than 1000 tables.
> Thanks
> Rahul
I think you have misunderstood both replies. I believe that Tibor is
suggesting that you generate your create trigger statements using the cursors
and you will end up with "hardcoded" columns for each table.
The checking of @.@.ROWCOUNT at the very begining of the trigger will mean
that you don't execute the code when not rows are changed, this will cut out
the unnecessary actions of the trigger.
Alter Trigger tr_tm_empmastR1 on tm_empmastR1 For Insert, Update, Delete
As
IF @.@.ROWCOUNT = 0 RETURN
...
John
Problem in creating Crystal reports
Hello friends,
I am creating crystal reports, I have used a crystal report viewer, but when i run it , i am asked the database login, I have set the windows NT Integrated security,so what userID and Password i should supply?
Kindly help me outIt should be no UID or PWD.
It should be windows authentication.
Good Luck.
Problem in creating Crystal reports
Hello friends,
I m stuck up with crystal reports. I have used crystal report viewer , but when I run it , i am asked database login , I have used Windows Integrated security what userid and password should I supply
Kindly help me outWhat are you using? Crystal Reports? The Crystal Report viewer in .Net? I'm assuming you are using SQL Server 2000? Need more info.
Erik Roessing
Friday, March 23, 2012
Problem in a derived column
Dear Friends,
I have an derived column in an ETL, that use the DateDiff function.
The experssion of the derived column is:
DATEDIFF("d",RKData,MaturityDate) / 365
The problem is that the result always come as an integer, and in fact the result of the expression usually has decimal numbers.. :-(
I defined the new colum of derived column as doube-precison float [DT_R8]....
Someone help me?
Thanks!
PedroCGD wrote:
Dear Friends,
I have an derived column in an ETL, that use the DateDiff function.
The experssion of the derived column is:
DATEDIFF("d",RKData,MaturityDate) / 365
The problem is that the result always come as an integer, and in fact the result of the expression usually has decimal numbers.. :-(
I defined the new colum of derived column as doube-precison float [DT_R8]....
Someone help me?
Thanks!
Try:
(DT_NUMERIC,7,4)DATEDIFF("d",RKData,MaturityDate) / (DT_NUMERIC,7,4)365
That should give you 4 decimal places. Adjust the precision and scale accordingly, if you need.|||
THANKS!!
I changed to (DT_NUMERIC,7,2)DATEDIFF("dd",RKData,MaturityDate) / (DT_NUMERIC,7,2)365 and it works!!
Thanks!!!!!!
Subscribe to:
Posts (Atom)