Re: Query performance

Wei,

ok, I think I will leave that problem to one side for now. Hopefully you
can help me with another problem.

I have existing code in a .NET 2 web service that uses System.Transactions
like this:

using( TransactionScope scope = new TransactionScope() )
{
...
...
scope.Complete();
}

This has been working fine against SQL 2000 on Win2003. When running
against SQL 2000 the DTC is involved and this hasn't been a problem after
correctly configuring the firewall and DTC security.

Now the database has been moved to SQL 2005 on Win2003 R2, and the
transactions should now be using the LTM.
Non-transactional code works fine. Transactional code causes the attached
exception.
However, if I startup Sql Management Studio on the client and connect to the
server, the transactions work fine from then on even after SSMS is closed.
So it looks like some sort of authentication problem. Do you have any idea
what the problem is or how to diagnose it? There aren't any errors in the
event log on the client or the server.

Regards
Phil Lee

"Wei Lu" <weilu@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:He9VBGgYGHA.880@xxxxxxxxxxxxxxxxxxxxxxxx
Hi Phil,

Thanks for the update.

The duration of a query operation is related to several things like the
CPU
usage, network connection, etc.
Also, if there is other queries executed on the same table, you may
recieve
a different duration time.

As you mentioned, your SQL 2005 is on a different machine, so I think the
duration of a query will include the network connection time. The same
query will take the same time.

Performance issues can be difficult to troubleshoot and resolve in a
newsgroup setting due to the number of variables and the amount of time
required to narrow down possible causes and observe the effects. We will
assist as best as we can, but you may wish to consider contacting CSS for
a
more timely resolution for these type issues.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com
for regional support phone numbers.


Thank you for your patience and understanding.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no
rights.



begin 666 20060417-155827-GetMeters(MeterRequest request).xml
M/$5X8V5P=&EO;CX-"B @/$1E<V-R:7!T:6]N/D%N(&5X8V5P=&EO;B!O9B!T
M>7!E("=3>7-T96TN4F5F;&5C=&EO;BY487)G971);G9O8V%T:6]N17AC97!T
M:6]N)R!O8V-U<G)E9"!A;F0@=V%S(&-A=6=H="X\+T1E<V-R:7!T:6]N/@T*
M(" \1&%T951I;64^,C P-BTP-"TQ-R Q-3HU.#HR-UH\+T1A=&54:6UE/@T*
M(" \17AC97!T:6]N5'EP93Y3>7-T96TN4F5F;&5C=&EO;BY487)G971);G9O
M8V%T:6]N17AC97!T:6]N+"!M<V-O<FQI8BP@5F5R<VEO;CTR+C N,"XP+"!#
M=6QT=7)E/6YE=71R86PL(%!U8FQI8TME>51O:V5N/6(W-V$U8S4V,3DS-&4P
M.#D\+T5X8V5P=&EO;E1Y<&4^#0H@(#Q-97-S86=E/D5X8V5P=&EO;B!H87,@
M8F5E;B!T:')O=VX@8GD@=&AE('1A<F=E="!O9B!A;B!I;G9O8V%T:6]N+CPO
M365S<V%G93X-"B @/%-O=7)C93YM<V-O<FQI8CPO4V]U<F-E/@T*(" \2&5L
M<$QI;FL@+SX-"B @/%!R;W!E<G1Y(&YA;64](D1A=&$B/E-Y<W1E;2Y#;VQL
M96-T:6]N<RY,:7-T1&EC=&EO;F%R>4EN=&5R;F%L/"]0<F]P97)T>3X-"B @
M/%!R;W!E<G1Y(&YA;64](E1A<F=E=%-I=&4B/E-Y<W1E;2Y/8FIE8W0@7TEN
M=F]K94UE=&AO9$9A<W0H4WES=&5M+D]B:F5C="P@4WES=&5M+D]B:F5C=%M=
M+"!3>7-T96TN4VEG;F%T=7)E4W1R=6-T($)Y4F5F+"!3>7-T96TN4F5F;&5C
M=&EO;BY-971H;V1!='1R:6)U=&5S+"!3>7-T96TN4G5N=&EM951Y<&5(86YD
M;&4I/"]0<F]P97)T>3X-"B @/%-T86-K5')A8V4^(" @870@4WES=&5M+E)U
M;G1I;65-971H;V1(86YD;&4N7TEN=F]K94UE=&AO9$9A<W0H3V)J96-T('1A
M<F=E="P@3V)J96-T6UT@87)G=6UE;G1S+"!3:6=N871U<F53=')U8W0F86UP
M.R!S:6<L($UE=&AO9$%T=')I8G5T97,@;65T:&]D071T<FEB=71E<RP@4G5N
M=&EM951Y<&5(86YD;&4@='EP94]W;F5R*0T*(" @870@4WES=&5M+E)U;G1I
M;65-971H;V1(86YD;&4N26YV;VME365T:&]D1F%S="A/8FIE8W0@=&%R9V5T
M+"!/8FIE8W1;72!A<F=U;65N=',L(%-I9VYA='5R92!S:6<L($UE=&AO9$%T
M=')I8G5T97,@;65T:&]D071T<FEB=71E<RP@4G5N=&EM951Y<&5(86YD;&4@
M='EP94]W;F5R*0T*(" @870@4WES=&5M+E)E9FQE8W1I;VXN4G5N=&EM94UE
M=&AO9$EN9F\N26YV;VME*$]B:F5C="!O8FHL($)I;F1I;F=&;&%G<R!I;G9O
M:V5!='1R+"!":6YD97(@8FEN9&5R+"!/8FIE8W1;72!P87)A;65T97)S+"!#
M=6QT=7)E26YF;R!C=6QT=7)E+"!";V]L96%N('-K:7!6:7-I8FEL:71Y0VAE
M8VMS*0T*(" @870@4WES=&5M+E)E9FQE8W1I;VXN4G5N=&EM94UE=&AO9$EN
M9F\N26YV;VME*$]B:F5C="!O8FHL($)I;F1I;F=&;&%G<R!I;G9O:V5!='1R
M+"!":6YD97(@8FEN9&5R+"!/8FIE8W1;72!P87)A;65T97)S+"!#=6QT=7)E
M26YF;R!C=6QT=7)E*0T*(" @870@4WES=&5M+E)E9FQE8W1I;VXN365T:&]D
M0F%S92Y);G9O:V4H3V)J96-T(&]B:BP@3V)J96-T6UT@<&%R86UE=&5R<RD-
M"B @(&%T(%9A;G1A9V4N5V5B4V5R=FEC97,N5&5S=$AA<FYE<W,N07!I365T
M:&]D26YF;RY);G9O:V5-971H;V0H*2!I;B!#.EQ0<F]J96-T<UQ!8W1A<FES
M7%9A;G1A9V4R7S!<5F%N=&%G92Y796)<5F%N=&%G92Y796)397)V:6-E<RY4
M97-T2&%R;F5S<UQ!<&E-971H;V1);F9O+F-S.FQI;F4@,3$W#0H@("!A="!6
M86YT86=E+E=E8E-E<G9I8V5S+E1E<W1(87)N97-S+DUA:6Y&;W)M+F)U='1O
M;D5X96-U=&5?0VQI8VLH3V)J96-T('-E;F1E<BP@179E;G1!<F=S(&4I(&EN
M($,Z7%!R;VIE8W1S7$%C=&%R:7-<5F%N=&%G93)?,%Q686YT86=E+E=E8EQ6
M86YT86=E+E=E8E-E<G9I8V5S+E1E<W1(87)N97-S7$UA:6Y&;W)M+F-S.FQI
M;F4@,34Q/"]3=&%C:U1R86-E/@T*(" \861D:71I;VYA;$EN9F\^#0H@(" @
M/&EN9F\@;F%M93TB36%C:&EN94YA;64B('9A;'5E/2),24=(5$Y)3D<B("\^
M#0H@(" @/&EN9F\@;F%M93TB5&EM95-T86UP(B!V86QU93TB,3<O,#0O,C P
M-B Q-#HU.#HR-R(@+SX-"B @(" \:6YF;R!N86UE/2)&=6QL3F%M92(@=F%L
M=64](DUI8W)O<V]F="Y0<F%C=&EC97,N16YT97)P<FES94QI8G)A<GDN17AC
M97!T:6]N2&%N9&QI;F<L(%9E<G-I;VX],BXP+C N,"P@0W5L='5R93UN975T
M<F%L+"!0=6)L:6-+97E4;VME;CUN=6QL(B O/@T*(" @(#QI;F9O(&YA;64]
M(D%P<$1O;6%I;DYA;64B('9A;'5E/2)686YT86=E+E=E8E-E<G9I8V5S+E1E
M<W1(87)N97-S+G9S:&]S="YE>&4B("\^#0H@(" @/&EN9F\@;F%M93TB5&AR
M96%D261E;G1I='DB('9A;'5E/2(B("\^#0H@(" @/&EN9F\@;F%M93TB5VEN
M9&]W<TED96YT:71Y(B!V86QU93TB4$I,0T].4U5,5$%.5%-<<&AI;&EP+FQE
M92(@+SX-"B @/"]A9&1I=&EO;F%L26YF;SX-"B @/$EN;F5R17AC97!T:6]N
M/@T*(" @(#Q%>&-E<'1I;VY4>7!E/E-Y<W1E;2Y796(N4V5R=FEC97,N4')O
M=&]C;VQS+E-O87!%>&-E<'1I;VXL(%-Y<W1E;2Y796(N4V5R=FEC97,L(%9E
M<G-I;VX],BXP+C N,"P@0W5L='5R93UN975T<F%L+"!0=6)L:6-+97E4;VME
M;CUB,#-F-68W9C$Q9#4P83-A/"]%>&-E<'1I;VY4>7!E/@T*(" @(#Q-97-S
M86=E/E-Y<W1E;2Y796(N4V5R=FEC97,N4')O=&]C;VQS+E-O87!%>&-E<'1I
M;VXZ(%-E<G9E<B!W87,@=6YA8FQE('1O('!R;V-E<W,@<F5Q=65S="X@+2TM
M)F=T.R!3>7-T96TN5')A;G-A8W1I;VYS+E1R86YS86-T:6]N36%N86=E<D-O
M;6UU;FEC871I;VY%>&-E<'1I;VXZ($-O;6UU;FEC871I;VX@=VET:"!T:&4@
M=6YD97)L>6EN9R!T<F%N<V%C=&EO;B!M86YA9V5R(&AA<R!F86EL960N("TM
M+29G=#L@4WES=&5M+E)U;G1I;64N26YT97)O<%-E<G9I8V5S+D-/345X8V5P
M=&EO;B H,'@X,# P-# P-2DZ($5R<F]R($A215-53%0@15]&04E,(&AA<R!B
M965N(')E='5R;F5D(&9R;VT@82!C86QL('1O(&$@0T]-(&-O;7!O;F5N="X-
M"B @(&%T(%-Y<W1E;2Y4<F%N<V%C=&EO;G,N3VQE='@N241T8U!R;WAY4VAI
M;49A8W1O<GDN4F5C96EV951R86YS86-T:6]N*%5);G0S,B!P<F]P9V%T:6]N
M5&]K96Y3:7IE+"!">71E6UT@<')O<&=A=&EO;E1O:V5N+"!);G10='(@;6%N
M86=E9$ED96YT:69I97(L($=U:60F86UP.R!T<F%N<V%C=&EO;DED96YT:69I
M97(L($]L971X5')A;G-A8W1I;VY)<V]L871I;VY,979E;"9A;7 [(&ES;VQA
M=&EO;DQE=F5L+"!)5')A;G-A8W1I;VY3:&EM)F%M<#L@=')A;G-A8W1I;VY3
M:&EM*0T*(" @870@4WES=&5M+E1R86YS86-T:6]N<RY4<F%N<V%C=&EO;DEN
M=&5R;W N1V5T3VQE='A4<F%N<V%C=&EO;D9R;VU4<F%N<VUI='1E<E!R;W!I
M9V%T:6]N5&]K96XH0GET95M=('!R;W!A9V%T:6]N5&]K96XI#0H@(" M+2T@
M16YD(&]F(&EN;F5R(&5X8V5P=&EO;B!S=&%C:R!T<F%C92 M+2T-"B @(&%T
M(%-Y<W1E;2Y4<F%N<V%C=&EO;G,N5')A;G-A8W1I;VY);G1E<F]P+D=E=$]L
M971X5')A;G-A8W1I;VY&<F]M5')A;G-M:71T97)0<F]P:6=A=&EO;E1O:V5N
M*$)Y=&5;72!P<F]P86=A=&EO;E1O:V5N*0T*(" @870@4WES=&5M+E1R86YS
M86-T:6]N<RY4<F%N<V%C=&EO;E-T871E4%-014]P97)A=&EO;BY04U!%4')O
M;6]T92A);G1E<FYA;%1R86YS86-T:6]N('1X*0T*(" @870@4WES=&5M+E1R
M86YS86-T:6]N<RY4<F%N<V%C=&EO;E-T871E1&5L96=A=&5D0F%S92Y%;G1E
M<E-T871E*$EN=&5R;F%L5')A;G-A8W1I;VX@='@I#0H@("!A="!3>7-T96TN
M5')A;G-A8W1I;VYS+D5N;&ES=&%B;&53=&%T97,N4')O;6]T92A);G1E<FYA
M;%1R86YS86-T:6]N('1X*0T*(" @870@4WES=&5M+E1R86YS86-T:6]N<RY4
M<F%N<V%C=&EO;BY0<F]M;W1E*"D-"B @(&%T(%-Y<W1E;2Y4<F%N<V%C=&EO
M;G,N5')A;G-A8W1I;VY);G1E<F]P+D-O;G9E<G14;T]L971X5')A;G-A8W1I
M;VXH5')A;G-A8W1I;VX@=')A;G-A8W1I;VXI#0H@("!A="!3>7-T96TN5')A
M;G-A8W1I;VYS+E1R86YS86-T:6]N26YT97)O<"Y'971%>'!O<G1#;V]K:64H
M5')A;G-A8W1I;VX@=')A;G-A8W1I;VXL($)Y=&5;72!W:&5R96%B;W5T<RD-
M"B @(&%T(%-Y<W1E;2Y$871A+E-Q;$-L:65N="Y3<6Q);G1E<FYA;$-O;FYE
M8W1I;VXN1V5T5')A;G-A8W1I;VY#;V]K:64H5')A;G-A8W1I;VX@=')A;G-A
M8W1I;VXL($)Y=&5;72!W:&5R94%B;W5T<RD-"B @(&%T(%-Y<W1E;2Y$871A
M+E-Q;$-L:65N="Y3<6Q);G1E<FYA;$-O;FYE8W1I;VXN16YL:7-T3F]N3G5L
M;"A4<F%N<V%C=&EO;B!T>"D-"B @(&%T(%-Y<W1E;2Y$871A+E-Q;$-L:65N
M="Y3<6Q);G1E<FYA;$-O;FYE8W1I;VXN16YL:7-T*%1R86YS86-T:6]N('1X
M*0T*(" @870@4WES=&5M+D1A=&$N4W%L0VQI96YT+E-Q;$EN=&5R;F%L0V]N
M;F5C=&EO;E1D<RY!8W1I=F%T92A4<F%N<V%C=&EO;B!T<F%N<V%C=&EO;BD-
M"B @(&%T(%-Y<W1E;2Y$871A+E!R;W9I9&5R0F%S92Y$8D-O;FYE8W1I;VY)
M;G1E<FYA;"Y!8W1I=F%T94-O;FYE8W1I;VXH5')A;G-A8W1I;VX@=')A;G-A
M8W1I;VXI#0H@("!A="!3>7-T96TN1&%T82Y0<F]V:61E<D)A<V4N1&)#;VYN
M96-T:6]N4&]O;"Y'971#;VYN96-T:6]N*$1B0V]N;F5C=&EO;B!O=VYI;F=/
M8FIE8W0I#0H@("!A="!3>7-T96TN1&%T82Y0<F]V:61E<D)A<V4N1&)#;VYN
M96-T:6]N1F%C=&]R>2Y'971#;VYN96-T:6]N*$1B0V]N;F5C=&EO;B!O=VYI
M;F=#;VYN96-T:6]N*0T*(" @870@4WES=&5M+D1A=&$N4')O=FED97)"87-E
M+D1B0V]N;F5C=&EO;D-L;W-E9"Y/<&5N0V]N;F5C=&EO;BA$8D-O;FYE8W1I
M;VX@;W5T97)#;VYN96-T:6]N+"!$8D-O;FYE8W1I;VY&86-T;W)Y(&-O;FYE
M8W1I;VY&86-T;W)Y*0T*(" @870@4WES=&5M+D1A=&$N4W%L0VQI96YT+E-Q
M;$-O;FYE8W1I;VXN3W!E;B@I#0H@("!A="!-:6-R;W-O9G0N4')A8W1I8V5S
M+D5N=&5R<')I<V5,:6)R87)Y+D1A=&$N1&%T86)A<V4N3W!E;D-O;FYE8W1I
M;VXH*0T*(" @870@36EC<F]S;V9T+E!R86-T:6-E<RY%;G1E<G!R:7-E3&EB
M<F%R>2Y$871A+D1A=&%B87-E+D5X96-U=&538V%L87(H1&)#;VUM86YD(&-O
M;6UA;F0I#0H@("!A="!686YT86=E+E=E8E-E<G9I8V5S+D1A=&$N1&%T851A
M8FQE475E<GDN17AE8W5T94-O=6YT*%-T<FEN9R!C;VQU;6Y3<&5C+"!";V]L
M96%N(&1I<W1I;F-T*2!I;B!#.EQ0<F]J96-T<UQ!8W1A<FES7%9A;G1A9V4R
M7S!<5F%N=&%G92Y796)<5F%N=&%G92Y796)397)V:6-E<RY$871A7$1A=&%4
M86)L95%U97)Y+F-S.FQI;F4@.#,U#0H@("!A="!686YT86=E+E=E8E-E<G9I
M8V5S+D1A=&$N1&%T851A8FQE475E<GDN17AE8W5T94-O=6YT*%-T<FEN9R!C
M;VQU;6Y3<&5C*2!I;B!#.EQ0<F]J96-T<UQ!8W1A<FES7%9A;G1A9V4R7S!<
M5F%N=&%G92Y796)<5F%N=&%G92Y796)397)V:6-E<RY$871A7$1A=&%486)L
M95%U97)Y+F-S.FQI;F4@.#$U#0H@("!A="!686YT86=E+E=E8E-E<G9I8V5S
M+D1A=&$N475E<FEE<RY-971E<E1A8FQE475E<GDN17AE8W5T92@I(&EN($,Z
M7%!R;VIE8W1S7$%C=&%R:7-<5F%N=&%G93)?,%Q686YT86=E+E=E8EQ686YT
M86=E+E=E8E-E<G9I8V5S+D1A=&%<475E<FEE<UQ-971E<E1A8FQE475E<GDN
M8W,Z;&EN92 Q,3$-"B @(&%T(%9A;G1A9V4N5V5B4V5R=FEC97,N1&%T82Y$
M871A06-C97-S+D=E=$UE=&5R<RA-971E<E)E<75E<W0@<F5Q=65S="D@:6X@
M0SI<4')O:F5C='-<06-T87)I<UQ686YT86=E,E\P7%9A;G1A9V4N5V5B7%9A
M;G1A9V4N5V5B4V5R=FEC97,N1&%T85Q$871A06-C97-S+F-S.FQI;F4@.3$Y
M#0H@("!A="!686YT86=E5U,N1V5T365T97)S*$UE=&5R4F5Q=65S="!R97%U
M97-T*2!I;B!C.EQ0<F]J96-T<UQ!8W1A<FES7%9A;G1A9V4R7S!<5F%N=&%G
M92Y796)<5F%N=&%G92Y796)397)V:6-E<UQ!<'!?0V]D95Q686YT86=E5U,N
M8W,Z;&EN92 R-S@-"B @("TM+2!%;F0@;V8@:6YN97(@97AC97!T:6]N('-T
M86-K('1R86-E("TM+3PO365S<V%G93X-"B @(" \4V]U<F-E/E-Y<W1E;2Y7
M96(N4V5R=FEC97,\+U-O=7)C93X-"B @(" \2&5L<$QI;FL@+SX-"B @(" \
M4')O<&5R='D@;F%M93TB06-T;W(B("\^#0H@(" @/%!R;W!E<G1Y(&YA;64]
M(D-O9&4B/FAT=' Z+R]S8VAE;6%S+GAM;'-O87 N;W)G+W-O87 O96YV96QO
M<&4O.E-E<G9E<CPO4')O<&5R='D^#0H@(" @/%!R;W!E<G1Y(&YA;64](D1E
M=&%I;"(^4WES=&5M+EAM;"Y8;6Q%;&5M96YT/"]0<F]P97)T>3X-"B @(" \
M4')O<&5R='D@;F%M93TB3&%N9R(@+SX-"B @(" \4')O<&5R='D@;F%M93TB
M3F]D92(@+SX-"B @(" \4')O<&5R='D@;F%M93TB4F]L92(@+SX-"B @(" \
M4')O<&5R='D@;F%M93TB4W5B0V]D92(^)FQT.W5N9&5F:6YE9"!V86QU929G
M=#L\+U!R;W!E<G1Y/@T*(" @(#Q0<F]P97)T>2!N86UE/2)$871A(CY3>7-T
M96TN0V]L;&5C=&EO;G,N3&ES=$1I8W1I;VYA<GE);G1E<FYA;#PO4')O<&5R
M='D^#0H@(" @/%!R;W!E<G1Y(&YA;64](E1A<F=E=%-I=&4B/E-Y<W1E;2Y/
M8FIE8W1;72!296%D4F5S<&]N<V4H4WES=&5M+E=E8BY397)V:6-E<RY0<F]T
M;V-O;',N4V]A<$-L:65N=$UE<W-A9V4L(%-Y<W1E;2Y.970N5V5B4F5S<&]N
M<V4L(%-Y<W1E;2Y)3RY3=')E86TL($)O;VQE86XI/"]0<F]P97)T>3X-"B @
M(" \4W1A8VM4<F%C93X@("!A="!3>7-T96TN5V5B+E-E<G9I8V5S+E!R;W1O
M8V]L<RY3;V%P2'1T<$-L:65N=%!R;W1O8V]L+E)E861297-P;VYS92A3;V%P
M0VQI96YT365S<V%G92!M97-S86=E+"!796)297-P;VYS92!R97-P;VYS92P@
M4W1R96%M(')E<W!O;G-E4W1R96%M+"!";V]L96%N(&%S>6YC0V%L;"D-"B @
M(&%T(%-Y<W1E;2Y796(N4V5R=FEC97,N4')O=&]C;VQS+E-O87!(='1P0VQI
M96YT4')O=&]C;VPN26YV;VME*%-T<FEN9R!M971H;V1.86UE+"!/8FIE8W1;
M72!P87)A;65T97)S*0T*(" @870@5F%N=&%G92Y796)397)V:6-E<RY497-T
M2&%R;F5S<RY$871A06-C97-S+E9A;G1A9V574U=S92Y'971-971E<G,H365T
M97)297%U97-T(')E<75E<W0I(&EN($,Z7%!R;VIE8W1S7$%C=&%R:7-<5F%N
M=&%G93)?,%Q686YT86=E+E=E8EQ686YT86=E+E=E8E-E<G9I8V5S+E1E<W1(
M87)N97-S7%=E8B!2969E<F5N8V5S7$1A=&%!8V-E<W-<4F5F97)E;F-E+F-S
M.FQI;F4@-S4W/"]3=&%C:U1R86-E/@T*(" \+TEN;F5R17AC97!T:6]N/@T*
,/"]%>&-E<'1I;VX^
`
end

.

Relevant Pages

  • Re: Queries Occasionally Slowing Down
    ... (select RowId from DataStore where dataStoreName ='name' and name = ... that is run, CPU, Reads, Writes, Duration. ... Links for SQL Server Books Online: ... I have no way to know when the slow query will kick in. ...
    (comp.databases.ms-sqlserver)
  • Re: How to stop TransactionScope from starting distributed transac
    ... if I only link to one SQL 2005 Server. ... SqlConnection object while I update different tables in 2 SQL 2005 databases. ... Will this cause TransactionScope promote MSDTC? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Using transaction scope with access database
    ... I am working on two databases one is in SQL server 2000 and one is in MS ... update the SQL database. ... that I have used TransactionScope class provided by .net 2.0. ... // database operations here ...
    (microsoft.public.dotnet.framework.adonet)
  • Problem with timeout in TransactionScope
    ... I'm porting my application from ServicedComponents to TransactionScope ... As I undestand if TransactionScope is created with TimeSpan.Zero timeout ... true for both SQL 2000 & SQL 2005. ... TransactionManager.ValidateTimeout method while CommittableTransaction ...
    (microsoft.public.dotnet.framework)
  • RE: TransactionScope implicitly or explicitly committed or aborted
    ... that when working with SQL 2000, ... promotes the transaction to a distributed transaction EVERY time. ... >> I am attempting to use the TransactionScope class to manage my transactions. ... >> Complete method of the TransactionScope object, ...
    (microsoft.public.dotnet.general)
Loading