Re: WITH ENCRYPTION en masse
From: Andrew John (aj@NOSPAMmistrose.com)
Date: 09/27/02
- Next message: Ansar Javed: "Password protected Database"
- Previous message: Lan Lewis-Bevan [MS]: "RE: xp_sqlagent_proxy_account and post sp2"
- In reply to: Simon Train: "WITH ENCRYPTION en masse"
- Next in thread: Simon Train: "Re: WITH ENCRYPTION en masse"
- Reply: Simon Train: "Re: WITH ENCRYPTION en masse"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Andrew John" <aj@NOSPAMmistrose.com> Date: Fri, 27 Sep 2002 09:59:04 +1000
Simon,
I've played around with this before, but the attached SP is not really fit for production,
maybe you can turn it into something useful.
Caveats:
1) It relies on a text search for the first AS. So if this optional statement has been used in any
of the parameters it won't work.
2) If a procedure has so many parameters that first AS is not in the 1st 4000 chars it wont work
3) The flow of control could be improved, so that it errors and goes on, rather than breaking out
when it finds an object it can't handle.
Scripting the database, and then using a good text editor, may be your best bet.
More importantly, why bother. The decryption algorithm is disappointingly trivial, so you are not
really protecting anything.
I've tried setting the ctext field in syscomments to 0x0 instead, and the stored procedure I tested it on
keeps working, but only until the next SQL server stop/start, so thats of limited use too.
You may have better luck over at the microsoft.public.sqlserver.security newsgroup, or it's
archive at google.com
Face it, until Microsoft patches/upgrades the encryption, it is a waste of time.
I don't normally bother, as this is a newsgroup after all, but I'll quote from the Microsoft posters:
"This posting is provided "AS IS" with no warranties, and confers no rights."
Regards
AJ
"Simon Train" <simon.train@btinternet.com> wrote in message news:uSsAGZLZCHA.2028@tkmsftngp11...
> Has anyone come up with a reliable way of automatically inserting the WITH
> OPTION to the text of stored procedures, views, user-defined functions or
> triggers. I need to encrypt lots of objects en masse in production databases
> and since some of the options already use WITH... options the insertion of
> WITH OPTION is tricky.
>
> Any ideas?
>
> Thanks, Simon
>
>
begin 666 EncryptProceduresTriggersViews.tsq
M0U)%051%(%!R;V-E9'5R92!%;F-R>7!T4')O8V5D=7)E<U1R:6=G97)S5FEE
M=W,-"B@-"@E 0V]N9FER;6%T:6]N('9A<F-H87(H,S I#0HI#0I!<PT*+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2T-"BTM($9U;F-T:6]N.@T*+2T)"0E087)S92!S>7-C;VUM96YT
M<R!T86)L92 H=VET:"!C87)E*2!I;B!O<F1E<B!T;R!A9&0@=VET:"!E;F-R
M>7!T:6]N(&EN(&%P<')O<')I871E('!L86-E<PT*+2T@(&%N9"!R96-R96%T
M92!A;&P@=&AE('-T;W)E9"!P<F]C961U<F5S(&%N9"!T<FEG9V5R<R!U<VEN
M9R!T:&ES+@T*+2T-"BTM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM#0H-"DE&($!#;VYF:7)M871I;VX@
M/#X@)U)E86QY4F5A;'E3=7)E)PT*0D5'24X-"@E0<FEN=" G5&AI<R!S=&]R
M960@<')O8V5D=7)E(&-A;B!D97-T<F]Y('EO=7(@9&%T86)A<V4N("!/;FQY
M(')U;B!I="!I9B!Y;W4@:&%V92<-"@E0<FEN=" G86QR96%D>2!S8W)I<'1E
M9"!I="!A<R!A(&)A8VMU<"XG#0H)4')I;G0@)TEF('EO=2!A<F4@<F5A;'D@
M<W5R92!T:&5N('1H92!C;VUM86YD(&QI;F4@:7,@.B G)U)E86QY4F5A;'E3
M=7)E)R<@)PT*#0H)4D5455).("@P*0T*14Y$#0H-"BTM($-O;G-T86YT<PT*
M1$5#3$%212! 36%X4F]W<R!A<R!I;G1E9V5R#0I3150@0$UA>%)O=W,@/2 R
M,PDM+2!4;R!R=6X@82!C<F5A=&4@8V]M;6%N9"!L:6YE(&YE960@=&\@861D
M(&)L;V-K<R!O9B!N=F%R8VAA<G,@=&]G971H97(L('1H:7,@:7,@:&]W(&UA
M;GD@=&\@8V%T97(@9F]R#0H-"BTM($5R<F]R('9A<FEA8FQE<PT*1$5#3$%2
M12! 4F5T=7)N0V]D92!A<R!I;G1E9V5R#0I$14-,05)%($!%<G)O<DYU;2!A
M<R!I;G1E9V5R#0I$14-,05)%($!N0W5R<F5N=%)O=R!A<R!I;G1E9V5R#0I$
M14-,05)%($!%<G)O<DUS9R!A<R!V87)C:&%R*#(U-2D-"E-%5"! 4F5T=7)N
M0V]D92 ](# -"E-%5"! 17)R;W).=6T@/2 P#0I3150@0&Y#=7)R96YT4F]W
M(#T@, T*4T54($!%<G)O<DUS9R ]("<G#0H-"BTM($EN=&5R;F%L(%9A<FEA
M8FQE<PT*1$5#3$%212! 8U1Y<&4@87,@8VAA<B@R*0T*1$5#3$%212! 8TQA
M<W14>7!E(&%S(&-H87(H,BD-"D1%0TQ!4D4@0'-N3F%M92!A<R!S>7-N86UE
M#0I$14-,05)%($!N=F-497AT(&%S(&YV87)C:&%R*#0P,# I#0I$14-,05)%
M($!S;E!R979I;W5S3F%M92!A<R!S>7-N86UE#0I$14-,05)%($!N=F-497AT
M,2!A<R!N=F%R8VAA<B@T,# P*0T*1$5#3$%212! ;G9C5&5X=#(@87,@;G9A
M<F-H87(H-# P,"D-"D1%0TQ!4D4@0&YV8U1E>'0S(&%S(&YV87)C:&%R*#0P
M,# I#0I$14-,05)%($!N=F-497AT-"!A<R!N=F%R8VAA<B@T,# P*0T*1$5#
M3$%212! ;G9C5&5X=#4@87,@;G9A<F-H87(H-# P,"D-"D1%0TQ!4D4@0&YV
M8U1E>'0V(&%S(&YV87)C:&%R*#0P,# I#0I$14-,05)%($!N=F-497AT-R!A
M<R!N=F%R8VAA<B@T,# P*0T*1$5#3$%212! ;G9C5&5X=#@@87,@;G9A<F-H
M87(H-# P,"D-"D1%0TQ!4D4@0&YV8U1E>'0Y(&%S(&YV87)C:&%R*#0P,# I
M#0I$14-,05)%($!N=F-497AT,3 @87,@;G9A<F-H87(H-# P,"D-"D1%0TQ!
M4D4@0&YV8U1E>'0Q,2!A<R!N=F%R8VAA<B@T,# P*0T*1$5#3$%212! ;G9C
M5&5X=#$R(&%S(&YV87)C:&%R*#0P,# I#0I$14-,05)%($!N=F-497AT,3,@
M87,@;G9A<F-H87(H-# P,"D-"D1%0TQ!4D4@0&YV8U1E>'0Q-"!A<R!N=F%R
M8VAA<B@T,# P*0T*1$5#3$%212! ;G9C5&5X=#$U(&%S(&YV87)C:&%R*#0P
M,# I#0I$14-,05)%($!N=F-497AT,38@87,@;G9A<F-H87(H-# P,"D-"D1%
M0TQ!4D4@0&YV8U1E>'0Q-R!A<R!N=F%R8VAA<B@T,# P*0T*1$5#3$%212!
M;G9C5&5X=#$X(&%S(&YV87)C:&%R*#0P,# I#0I$14-,05)%($!N=F-497AT
M,3D@87,@;G9A<F-H87(H-# P,"D-"D1%0TQ!4D4@0&YV8U1E>'0R,"!A<R!N
M=F%R8VAA<B@T,# P*0T*1$5#3$%212! ;G9C5&5X=#(Q(&%S(&YV87)C:&%R
M*#0P,# I#0I$14-,05)%($!N=F-497AT,C(@87,@;G9A<F-H87(H-# P,"D-
M"D1%0TQ!4D4@0&YV8U1E>'0R,R!A<R!N=F%R8VAA<B@T,# P*0T*1$5#3$%2
M12! ;DEN<V5R=$QO8VX@87,@:6YT96=E<@T*1$5#3$%212! ;E=)5$A,;V-N
M(&%S(&EN=&5G97(-"D1%0TQ!4D4@0&YV8U1E>'0Q82!A<R!N=F%R8VAA<B@T
M,# P*0T*1$5#3$%212! ;G9C5&5X=#%B(&%S(&YV87)C:&%R*#0P,# I#0I$
M14-,05)%($!N=F-$<F]P0V]M;6%N9"!A<R!N=F%R8VAA<B@R,# I#0I$14-,
M05)%($!N=F-4>7!E($%3(&YV87)C:&%R*#,P*0T*#0H-"@T*+2T@0VAE8VL@
M:&%V92!N;W0@97AC965D960@;6%X(&YU;6)E<B!O9B!R;W=S#0I3150@0'-N
M3F%M92 ]($Y53$P-"G-E;&5C="!T;W @,0T*(" @(" @($!S;DYA;64@/2!S
M;RYN86UE#0H@(&9R;VT@<WES;V)J96-T<R!S;R H;F]L;V-K*0T*(&EN;F5R
M(&IO:6X@<WES8V]M;65N=',@<V,@*&YO;&]C:RD@;VX@<V,N:60@/2!S;RYI
M9 T*('=H97)E('-C+F-O;&ED(#X@0$UA>%)O=W,-"B!O<F1E<B!B>2!S8RYC
M;VQI9"!D97-C#0H@#0I)1B!.3U0@*"! <VY.86UE($E3($Y53$P@*0T*0D5'
M24X-"@E3150@0%)E='5R;D-O9&4@/2 Q#0H)4T54($!%<G)O<DUS9R ](" G
M3V)J96-T("<@*R!C87-T*$!S;DYA;64@87,@=F%R8VAA<B@U,"DI("L@)R!I
M<R!T;V\@8FEG('1O('-C<FEP="<-"@EP<FEN="! 17)R;W)-<V<-"@ER971U
M<FX@*$!2971U<FY#;V1E*0T*14Y$#0H-"@T*+2T@1&5C;&%R92!A(&-U<G-O
M<B!T;R!C;VQL96-T(&%L;"!O8FIE8W1S(&]F(&EN=&5R97-T#0I$14-,05)%
M(&-R<U-Y<T-O;6UE;G1S( T*0U524T]2($Q/0T%,($9/4@T*(%-E;&5C="!S
M;RYT>7!E+"!S;RYN86UE+"!S8RYT97AT#0H@("!F<F]M(%-Y<V-O;6UE;G1S
M('-C("AN;VQO8VLI#0H@(&EN;F5R(&IO:6X@4WES3V)J96-T<R!S;R H;F]L
M;V-K*2!O;B!S;RYI9" ]('-C+FED#0H@('=H97)E('-C+F5N8W)Y<'1E9" ]
M(# )+2T@4&]I;G1L97-S('1R>6EN9R!T;R!R96%D(&$@=VAO;&4@;&]T(&]F
M($Y53$QS#0H@(" @86YD('-O+G1Y<&4@:6X@*" G4"<L("=44B<L("=6)R I
M"2TM(%!R;V-E9'5R97,L(%1R:6=G97)S("8@5FEE=W,-"@EA;F0@<V\N;F%M
M92 \/B!.)T5N8W)Y<'10<F]C961U<F5S5')I9V=E<G-6:65W<R<-"B @;W)D
M97(@8GD@<V\N='EP92P@<V\N;F%M92P@<V,N8V]L:60-"D9/4B!214%$($].
M3%D-"@T*4T5,14-4($!%<G)O<DYU;2 ]($! 15)23U(-"FEF("A 17)R;W).
M=6T@/#X@,"D-"F)E9VEN#0H)4T54($!2971U<FY#;V1E(#T@,@T*"5-%5"!
M17)R;W)-<V<@/2 @)T-O=6QD(&YO="!D96-L87)E(&-U<G-O<B!C<G-3>7-#
M;VUM96YT<R<-"@EP<FEN="! 17)R;W)-<V<-"@ER971U<FX@*$!2971U<FY#
M;V1E*0T*96YD#0H-"D]014X@8W)S4WES0V]M;65N=',-"E-%3$5#5"! 17)R
M;W).=6T@/2! 0$524D]2#0II9B H0$5R<F]R3G5M(#P^(# I#0IB96=I;@T*
M"5-%5"! 4F5T=7)N0V]D92 ](#,-"@E3150@0$5R<F]R37-G(#T@("=#;W5L
M9"!N;W0@;W!E;B!C=7)S;W(@8W)S4WES0V]M;65N=',G#0H)<')I;G0@0$5R
M<F]R37-G#0H)<F5T=7)N("A 4F5T=7)N0V]D92D-"F5N9 T*#0HM+2!'970@
M9FER<W0@;V)J96-T(')E8V]R9" H>65H($D@:VYO=R!I9B!T:&5R92!I<R!O
M;FQY(#$@<VUA;&P@;V)J96-T(&EN(&1B87-E(&ET(&1O97-N)W0@9V5T('-C
M<FEP=&5D*0T*1D540T@@3D585"!&4D]-(&-R<U-Y<T-O;6UE;G1S#0I)3E1/
M#0H)0&-4>7!E+ T*"4!S;DYA;64L#0H)0&YV8U1E>'0-"@T*4T5,14-4($!%
M<G)O<DYU;2 ]($! 15)23U(-"FEF("A 17)R;W).=6T@/#X@,"D-"F)E9VEN
M#0H)4T54($!2971U<FY#;V1E(#T@- T*"5-%5"! 17)R;W)-<V<@/2 G0V]U
M;&0@;F]T(&9E=&-H(#%S="!R96-O<F0@9G)O;2!C=7)S;W(@8W)S4WES0V]M
M;65N=',G#0H)<')I;G0@0$5R<F]R37-G#0H)<F5T=7)N("A 4F5T=7)N0V]D
M92D-"F5N9 T*#0HM+2!);FET:6%L:7-E(&9O<B Q<W0@<F5C;W)D#0I3150@
M0&Y#=7)R96YT4F]W(#T@,0T*4T54($!S;E!R979I;W5S3F%M92 ]($!S;DYA
M;64-"E-%5"! ;G9C5&5X=#$@/2! ;G9C5&5X= T*4T54($!C3&%S=%1Y<&4@
M/2! 8U1Y<&4-"E-%5"! ;G9C5&5X=#(@/2 G)PD-"E-%5"! ;G9C5&5X=#,@
M/2 G)PD-"E-%5"! ;G9C5&5X=#0@/2 G)PD-"E-%5"! ;G9C5&5X=#4@/2 G
M)PD-"E-%5"! ;G9C5&5X=#8@/2 G)PD-"E-%5"! ;G9C5&5X=#<@/2 G)PD-
M"E-%5"! ;G9C5&5X=#@@/2 G)PD-"E-%5"! ;G9C5&5X=#D@/2 G)PD-"E-%
M5"! ;G9C5&5X=#$P(#T@)R<)#0I3150@0&YV8U1E>'0Q,2 ]("<G"0T*4T54
M($!N=F-497AT,3(@/2 G)PD-"E-%5"! ;G9C5&5X=#$S(#T@)R<)#0I3150@
M0&YV8U1E>'0Q-" ]("<G"0T*4T54($!N=F-497AT,34@/2 G)PD-"E-%5"!
M;G9C5&5X=#$V(#T@)R<)#0I3150@0&YV8U1E>'0Q-R ]("<G"0T*4T54($!N
M=F-497AT,3@@/2 G)PD-"E-%5"! ;G9C5&5X=#$Y(#T@)R<)#0I3150@0&YV
M8U1E>'0R," ]("<G"0T*4T54($!N=F-497AT,C$@/2 G)PD-"E-%5"! ;G9C
M5&5X=#(R(#T@)R<)#0I3150@0&YV8U1E>'0R,R ]("<G"0T*#0HM+2 @0W5R
M<V]R('1H<F]U9V@@96%C:" T,# P(&-H87)A8W1E<B!C:'5N:R!O9B!O8FIE
M8W1S#0IW:&EL92! 0&9E=&-H7W-T871U<R ](# @("TM($$@=VAI;&4@;&]O
M<"!I;B!T:&ES(&]R9&5R('=O<FMS(&EF('1H97)E(&ES(&]N;'D@,2!F971C
M:"!I;G-I9&4-"F)E9VEN#0H-"@E&151#2"!.15A4($923TT@8W)S4WES0V]M
M;65N=',-"@E)3E1/#0H)"4!C5'EP92P-"@D)0'-N3F%M92P-"@D)0&YV8U1E
M>'0-"@E314Q%0U0@0$5R<F]R3G5M(#T@0$!%4E)/4@T*"6EF("A 17)R;W).
M=6T@/#X@,"D-"@EB96=I;@T*"0E3150@0%)E='5R;D-O9&4@/2 U#0H)"5-%
M5"! 17)R;W)-<V<@/2 G0V]U;&0@;F]T(&9E=&-H(&YE>'0@<F5C;W)D(&9R
M;VT@8W5R<V]R(&-R<U-Y<T-O;6UE;G1S)PT*"0EP<FEN="! 17)R;W)-<V<-
M"@D)<F5T=7)N("A 4F5T=7)N0V]D92D-"@EE;F0-"@T*"4E&("! <VY0<F5V
M:6]U<TYA;64@/2! <VY.86UE#0H)0D5'24X-"@D)+2T@0V]N=&EN=6%T:6]N
M(&]F(&5X:7-T:6YG(&]B:F5C=" H(&EE(&ET(&ES(&UO<F4@=&AA;B T,# P
M(&-H87)S(&QO;F<@*0T*"0E3150@0&Y#=7)R96YT4F]W(#T@0&Y#=7)R96YT
M4F]W("L@,0T*"0E)1B! ;D-U<G)E;G12;W<@/2 R#0H)"0E3150@0&YV8U1E
M>'0R(#T@0&YV8U1E>'0-"@D)248@0&Y#=7)R96YT4F]W(#T@,PT*"0D)4T54
M($!N=F-497AT,R ]($!N=F-497AT#0H)"4E&($!N0W5R<F5N=%)O=R ](#0-
M"@D)"5-%5"! ;G9C5&5X=#0@/2! ;G9C5&5X= T*"0E)1B! ;D-U<G)E;G12
M;W<@/2 U#0H)"0E3150@0&YV8U1E>'0U(#T@0&YV8U1E>'0-"@D)248@0&Y#
M=7)R96YT4F]W(#T@-@T*"0D)4T54($!N=F-497AT-B ]($!N=F-497AT#0H)
M"4E&($!N0W5R<F5N=%)O=R ](#<-"@D)"5-%5"! ;G9C5&5X=#<@/2! ;G9C
M5&5X= T*"0E)1B! ;D-U<G)E;G12;W<@/2 X#0H)"0E3150@0&YV8U1E>'0X
M(#T@0&YV8U1E>'0-"@D)248@0&Y#=7)R96YT4F]W(#T@.0T*"0D)4T54($!N
M=F-497AT.2 ]($!N=F-497AT#0H)"4E&($!N0W5R<F5N=%)O=R ](#$P#0H)
M"0E3150@0&YV8U1E>'0Q," ]($!N=F-497AT#0H)"4E&($!N0W5R<F5N=%)O
M=R ](#$Q#0H)"0E3150@0&YV8U1E>'0Q,2 ]($!N=F-497AT#0H)"4E&($!N
M0W5R<F5N=%)O=R ](#$R#0H)"0E3150@0&YV8U1E>'0Q,B ]($!N=F-497AT
M#0H)"4E&($!N0W5R<F5N=%)O=R ](#$S#0H)"0E3150@0&YV8U1E>'0Q,R ]
M($!N=F-497AT#0H)"4E&($!N0W5R<F5N=%)O=R ](#$T#0H)"0E3150@0&YV
M8U1E>'0Q-" ]($!N=F-497AT#0H)"4E&($!N0W5R<F5N=%)O=R ](#$U#0H)
M"0E3150@0&YV8U1E>'0Q-2 ]($!N=F-497AT#0H)"4E&($!N0W5R<F5N=%)O
M=R ](#$V#0H)"0E3150@0&YV8U1E>'0Q-B ]($!N=F-497AT#0H)"4E&($!N
M0W5R<F5N=%)O=R ](#$W#0H)"0E3150@0&YV8U1E>'0Q-R ]($!N=F-497AT
M#0H)"4E&($!N0W5R<F5N=%)O=R ](#$X#0H)"0E3150@0&YV8U1E>'0Q." ]
M($!N=F-497AT#0H)"4E&($!N0W5R<F5N=%)O=R ](#$Y#0H)"0E3150@0&YV
M8U1E>'0Q.2 ]($!N=F-497AT#0H)"4E&($!N0W5R<F5N=%)O=R ](#(P#0H)
M"0E3150@0&YV8U1E>'0R," ]($!N=F-497AT#0H)"4E&($!N0W5R<F5N=%)O
M=R ](#(Q#0H)"0E3150@0&YV8U1E>'0R,2 ]($!N=F-497AT#0H)"4E&($!N
M0W5R<F5N=%)O=R ](#(R#0H)"0E3150@0&YV8U1E>'0R,B ]($!N=F-497AT
M#0H)"4E&($!N0W5R<F5N=%)O=R ](#(S#0H)"0E3150@0&YV8U1E>'0R,R ]
M($!N=F-497AT#0H)"2TM($EF(&1E86QI;F<@=VET:"!B:6<@;V)J96-T<R!I
M92!I;F-R96%S:6YG($!-87A2;W=S+"!A9&0@<V]M92!M;W)E(&-O9&4@:&5R
M90T*"45.1 T*"45,4T4-"@E"14=)3@T*"0DM+2!,;V]K(&9O<B!T:&4@<W!O
M="!T;R!A9&0@=&AE(")W:71H(&5N8W)Y<'1I;VXB+B @270@<VAO=6QD(&)E
M(&IU<W0@8F5F;W)E#0H)"2TM('1H92!F:7)S=" B05,B('-U<G)O=6YD960@
M8GD@=VAI=&4@<W!A8V4L(&%S<W5M:6YG(&YO(&]T:&5R(")7251((B!O<'1I
M;VX@:7,@86QR96%D>2!U<V5D+ T*"0DM+2!A;F0@=&AA="!T:&4@;W!T:6]N
M86P@:V5Y=V]R9" B05,B(&AA<R!N;W0@8F5E;B!U<V5D(&EN('1H92!P87)A
M;65T97(@;&ES="X-"@D)+2T@268@87-S=6UP=&EO;G,@87)E('=R;VYG('1H
M96X@<')O8V5D=7)E(&UA>2!B92!A8FQE;"!T;R!B86-K(&]U="!O9B!T:&4@
M96YC<GEP="X-"@T*"0E3150@0&Y);G-E<G1,;V-N(#T@4$%424Y$15@H("<E
M6UY!+5IA+7HP+3E=05-;7D$M6F$M>C M.5TE)R L($!N=F-497AT,2 I#0H)
M"4E&($!N26YS97)T3&]C;B ](# -"@D)8F5G:6X-"@D)"5!224Y4($!N=F-4
M97AT,2 K($!N=F-497AT,B K($!N=F-497AT,R K($!N=F-497AT-" K($!N
M=F-497AT-2 K($!N=F-497AT-B K($!N=F-497AT-R K($!N=F-497AT." K
M($!N=F-497AT.2 K($!N=F-497AT,3 @*R! ;G9C5&5X=#$Q("L@0&YV8U1E
M>'0Q,B K($!N=F-497AT,3,@*R! ;G9C5&5X=#$T("L@0&YV8U1E>'0Q-2 K
M($!N=F-497AT,38@*R! ;G9C5&5X=#$W("L@0&YV8U1E>'0Q." K($!N=F-4
M97AT,3D@*R! ;G9C5&5X=#(P("L@0&YV8U1E>'0R,2 K($!N=F-497AT,C(@
M*R! ;G9C5&5X=#(S#0H)"0E3150@0%)E='5R;D-O9&4@/2 V#0H)"0E3150@
M0$5R<F]R37-G(#T@)T-A;B!N;W0@=V]R:R!O=70@=VAE<F4@=&\@:6YS97)T
M('1H92 B5TE42"!%3D-265!424].(B!I;B!O8FIE8W0@)R K($!S;E!R979I
M;W5S3F%M90T*"0D)<')I;G0@0$5R<F]R37-G#0H)"0ER971U<FX@*$!2971U
M<FY#;V1E*0T*"0EE;F0-"@T*"0DM+2!!<R!A(&-H96-K(&UA:V4@<W5R92!T
M:&%T('1H97)E(&ES(&YO(")7251((B!I;B!T:&4@9FER<W0@<&%R="!O9B!T
M:&4@;V)J96-T#0H)"5-%5"! ;E=)5$A,;V-N(#T@4$%424Y$15@H("<E6UY!
M+5IA+7HP+3E=5TE42%M>02U:82UZ,"TY724G("P@4U5"4U1224Y'*"! ;G9C
M5&5X=#$L(#$L($!N26YS97)T3&]C;B I("D-"@D)248@0&Y7251(3&]C;B \
M/B P#0H)"6)E9VEN#0H)"0E04DE.5"! ;G9C5&5X=#$@*R! ;G9C5&5X=#(@
M*R! ;G9C5&5X=#,@*R! ;G9C5&5X=#0@*R! ;G9C5&5X=#4@*R! ;G9C5&5X
M=#8@*R! ;G9C5&5X=#<@*R! ;G9C5&5X=#@@*R! ;G9C5&5X=#D@*R! ;G9C
M5&5X=#$P("L@0&YV8U1E>'0Q,2 K($!N=F-497AT,3(@*R! ;G9C5&5X=#$S
M("L@0&YV8U1E>'0Q-" K($!N=F-497AT,34@*R! ;G9C5&5X=#$V("L@0&YV
M8U1E>'0Q-R K($!N=F-497AT,3@@*R! ;G9C5&5X=#$Y("L@0&YV8U1E>'0R
M," K($!N=F-497AT,C$@*R! ;G9C5&5X=#(R("L@0&YV8U1E>'0R,PT*"0D)
M4T54($!2971U<FY#;V1E(#T@-PT*"0D)4T54($!%<G)O<DUS9R ]("=#86X@
M;F]T('=O<FL@;W5T('=H97)E('1O(&EN<V5R="!T:&4@(E=)5$@@14Y#4EE0
M5$E/3B(@:6X@;V)J96-T("<@*R! <VY0<F5V:6]U<TYA;64@*R G(&%S(&ET
M(&%L<F5A9'D@:&%S(&$@(E=)5$@B(&EN(&AE861E<B<-"@D)"7!R:6YT($!%
M<G)O<DUS9PT*"0D)<F5T=7)N("A 4F5T=7)N0V]D92D-"@D)96YD#0H-"@T*
M"0DM+4E&($!C3&%S=%1Y<&4@/2 G4"<-"@D)4T54($!N=F-4>7!E(#T@3B=0
M4D]#14154D4G#0H)"4E&($!C3&%S=%1Y<&4@/2 G5%(G#0H)"0E3150@0&YV
M8U1Y<&4@/2!.)U1224='15(G#0H)"4E&($!C3&%S=%1Y<&4@/2 G5B<-"@D)
M"5-%5"! ;G9C5'EP92 ]($XG5DE%5R<-"@T*"0E3150@0&YV8T1R;W!#;VUM
M86YD(#T@3B=)1B!%6$E35%,@*%-%3$5#5"!N86UE($923TT@<WES;V)J96-T
M<R!72$5212!N86UE(#T@)R<G("L@0'-N4')E=FEO=7-.86UE("L@3B<G)R G
M#0H)"0D)"0D)*R!.)T%.1"!T>7!E(#T@)R<G("L@0&-,87-T5'EP92 K($XG
M)R<I("!$4D]0("<@*R! ;G9C5'EP92 K($XG(%MD8F]=+ELG("L@0'-N4')E
M=FEO=7-.86UE("L@3B==)PT*"0E3150@0&YV8U1E>'0Q82 ]("!354)35%))
M3D<H($!N=F-497AT,2P@,2P@0&Y);G-E<G1,;V-N("D-"@D)4T54($!N=F-4
M97AT,6(@/2!.)R!7251(($5.0U)94%1)3TX@)R K(%-50E-44DE.1R@@0&YV
M8U1E>'0Q+"! ;DEN<V5R=$QO8VX@*R Q+" T,# P("D-"@T*"0DM+2!$<F]P
M('1H92!E>&ES=&EN9R!O8FIE8W0-"@D)15A%0U5412 H($!N=F-$<F]P0V]M
M;6%N9" I#0H)"5-%3$5#5"! 17)R;W).=6T@/2! 0$524D]2#0H)"6EF("A
M17)R;W).=6T@/#X@,"D-"@D)8F5G:6X-"@D)"5!224Y4($!N=F-$<F]P0V]M
M;6%N9 T*"0D)4T54($!2971U<FY#;V1E(#T@. T*"0D)4T54($!%<G)O<DUS
M9R ]("=!='1E;7!T('1O(&1R;W @;V)J96-T("<@*R! <VY0<F5V:6]U<TYA
M;64@*R G(&9A:6QE9"!W:71H(&5R<F]R("<@*R!S='(H0$5R<F]R3G5M*0T*
M"0D)<')I;G0@0$5R<F]R37-G#0H)"0ER971U<FX@*$!2971U<FY#;V1E*0T*
M"0EE;F0-"@T*#0H)"2TM($-R96%T92!N97<@96YC<GEP=&5D(&]B:F5C= T*
M"0E%6$5#551%("@@($!N=F-497AT,6$@*R! ;G9C5&5X=#%B("L@0&YV8U1E
M>'0R("L@0&YV8U1E>'0S("L@0&YV8U1E>'0T("L@0&YV8U1E>'0U("L@0&YV
M8U1E>'0V("L@0&YV8U1E>'0W("L@0&YV8U1E>'0X("L@0&YV8U1E>'0Y("L@
M0&YV8U1E>'0Q," K($!N=F-497AT,3$@*R! ;G9C5&5X=#$R("L@0&YV8U1E
M>'0Q,R K($!N=F-497AT,30@*R! ;G9C5&5X=#$U("L@0&YV8U1E>'0Q-B K
M($!N=F-497AT,3<@*R! ;G9C5&5X=#$X("L@0&YV8U1E>'0Q.2 K($!N=F-4
M97AT,C @*R! ;G9C5&5X=#(Q("L@0&YV8U1E>'0R,B K($!N=F-497AT,C,@
M*0T*"0E314Q%0U0@0$5R<F]R3G5M(#T@0$!%4E)/4@T*"0EI9B H0$5R<F]R
M3G5M(#P^(# I#0H)"6)E9VEN#0H)"0DM+2!)9B!&86EL960@=&AE;B!R92UC
M<F5A=&4@*&AO<&5F=6QL>2D@=&AE(&5X:7-T:6YG(&YO;BUE;F-R>7!T960@
M;V)J96-T#0H)"0E3150@0%)E='5R;D-O9&4@/2 Y#0H)"0E3150@0$5R<F]R
M37-G(#T@)T%T=&5M<'0@=&\@8W)E871E(&5N8W)Y<'1E9"!O8FIE8W0@)R K
M($!S;E!R979I;W5S3F%M92 K("<@9F%I;&5D('=I=&@@97)R;W(@)R K('-T
M<BA 17)R;W).=6TI("L@)RX@("T@071T96UP=&EN9R!T;R!R97-U<G)E8W0@
M;VQD(&]B:F5C="<-"@D)"7!R:6YT($!%<G)O<DUS9PT*"0D)4%))3E0@0&YV
M8U1E>'0Q("L@0&YV8U1E>'0R("L@0&YV8U1E>'0S("L@0&YV8U1E>'0T("L@
M0&YV8U1E>'0U("L@0&YV8U1E>'0V("L@0&YV8U1E>'0W("L@0&YV8U1E>'0X
M("L@0&YV8U1E>'0Y("L@0&YV8U1E>'0Q," K($!N=F-497AT,3$@*R! ;G9C
M5&5X=#$R("L@0&YV8U1E>'0Q,R K($!N=F-497AT,30@*R! ;G9C5&5X=#$U
M("L@0&YV8U1E>'0Q-B K($!N=F-497AT,3<@*R! ;G9C5&5X=#$X("L@0&YV
M8U1E>'0Q.2 K($!N=F-497AT,C @*R! ;G9C5&5X=#(Q("L@0&YV8U1E>'0R
M,B K($!N=F-497AT,C,-"@D)"45814-55$4@*" @0&YV8U1E>'0Q("L@0&YV
M8U1E>'0R("L@0&YV8U1E>'0S("L@0&YV8U1E>'0T("L@0&YV8U1E>'0U("L@
M0&YV8U1E>'0V("L@0&YV8U1E>'0W("L@0&YV8U1E>'0X("L@0&YV8U1E>'0Y
M("L@0&YV8U1E>'0Q," K($!N=F-497AT,3$@*R! ;G9C5&5X=#$R("L@0&YV
M8U1E>'0Q,R K($!N=F-497AT,30@*R! ;G9C5&5X=#$U("L@0&YV8U1E>'0Q
M-B K($!N=F-497AT,3<@*R! ;G9C5&5X=#$X("L@0&YV8U1E>'0Q.2 K($!N
M=F-497AT,C @*R! ;G9C5&5X=#(Q("L@0&YV8U1E>'0R,B K($!N=F-497AT
M,C,@*0T*"0D)4T5,14-4($!%<G)O<DYU;2 ]($! 15)23U(-"@D)"6EF("A
M17)R;W).=6T@/#X@,"D-"@D)"6)E9VEN#0H)"0D)4T54($!2971U<FY#;V1E
M(#T@,3 -"@D)"0E3150@0$5R<F]R37-G(#T@)T-O=6QD(&YO="!R96-R96%T
M92!U;BUE;F-R>7!T960@;V)J96-T("<@*R! <VY0<F5V:6]U<TYA;64@*R G
M("T@9F%I;&5D('=I=&@@97)R;W(@)R K('-T<BA 17)R;W).=6TI("L@)RX@
M(%EO=2!W:6QL(&YE960@=&\@<F5S=&]R92!I="!F<F]M(&$@8F%C:W5P+B<-
M"@D)"0EP<FEN="! 17)R;W)-<V<-"@D)"0ER971U<FX@*$!2971U<FY#;V1E
M*0T*"0D)96YD#0H)"0ER971U<FX@*$!2971U<FY#;V1E*0T*"0EE;F0-"@T*
M"0DM+2!'970@<V5T(&9O<B!N97AT(&]B:F5C= T*"0E3150@0&Y#=7)R96YT
M4F]W(#T@,0T*"0E3150@0'-N4')E=FEO=7-.86UE(#T@0'-N3F%M90T*"0E3
M150@0&YV8U1E>'0Q(#T@0&YV8U1E>'0-"@D)4T54($!C3&%S=%1Y<&4@/2!
M8U1Y<&4-"@D)4T54($!N=F-497AT,B ]("<G"0T*"0E3150@0&YV8U1E>'0S
M(#T@)R<)#0H)"5-%5"! ;G9C5&5X=#0@/2 G)PD-"@D)4T54($!N=F-497AT
M-2 ]("<G"0T*"0E3150@0&YV8U1E>'0V(#T@)R<)#0H)"5-%5"! ;G9C5&5X
M=#<@/2 G)PD-"@D)4T54($!N=F-497AT." ]("<G"0T*"0E3150@0&YV8U1E
M>'0Y(#T@)R<)#0H)"5-%5"! ;G9C5&5X=#$P(#T@)R<)#0H)"5-%5"! ;G9C
M5&5X=#$Q(#T@)R<)#0H)"5-%5"! ;G9C5&5X=#$R(#T@)R<)#0H)"5-%5"!
M;G9C5&5X=#$S(#T@)R<)#0H)"5-%5"! ;G9C5&5X=#$T(#T@)R<)#0H)"5-%
M5"! ;G9C5&5X=#$U(#T@)R<)#0H)"5-%5"! ;G9C5&5X=#$V(#T@)R<)#0H)
M"5-%5"! ;G9C5&5X=#$W(#T@)R<)#0H)"5-%5"! ;G9C5&5X=#$X(#T@)R<)
M#0H)"5-%5"! ;G9C5&5X=#$Y(#T@)R<)#0H)"5-%5"! ;G9C5&5X=#(P(#T@
M)R<)#0H)"5-%5"! ;G9C5&5X=#(Q(#T@)R<)#0H)"5-%5"! ;G9C5&5X=#(R
M(#T@)R<)#0H)"5-%5"! ;G9C5&5X=#(S(#T@)R<)#0H)14Y$#0H-"D5.1" M
M+7=H:6QE#0H-"@T*0TQ/4T4@8W)S4WES0V]M;65N=',-"E-%3$5#5"! 17)R
M;W).=6T@/2! 0$524D]2#0II9B H0$5R<F]R3G5M(#P^(# I#0IB96=I;@T*
M"5-%5"! 4F5T=7)N0V]D92 ](#$Q#0H)4T54($!%<G)O<DUS9R ]("=#;W5L
M9"!N;W0@8VQO<V4@8W5R<V]R(&-R<U-Y<T-O;6UE;G1S)PT*"7!R:6YT($!%
M<G)O<DUS9PT*"7)E='5R;B H0%)E='5R;D-O9&4I#0IE;F0-"@T*1$5!3$Q/
M0T%412!C<G-3>7-#;VUM96YT<PT*4T5,14-4($!%<G)O<DYU;2 ]($! 15)2
M3U(-"FEF("A 17)R;W).=6T@/#X@,"D-"F)E9VEN#0H)4T54($!2971U<FY#
M;V1E(#T@,3(-"@E3150@0$5R<F]R37-G(#T@)T-O=6QD(&YO="!$94%L;&]C
M871E(&-U<G-O<B!C<G-3>7-#;VUM96YT<R<-"@EP<FEN="! 17)R;W)-<V<-
K"@ER971U<FX@*$!2971U<FY#;V1E*0T*96YD#0H-"@T*4D5455).("@P*0``
`
end
- Next message: Ansar Javed: "Password protected Database"
- Previous message: Lan Lewis-Bevan [MS]: "RE: xp_sqlagent_proxy_account and post sp2"
- In reply to: Simon Train: "WITH ENCRYPTION en masse"
- Next in thread: Simon Train: "Re: WITH ENCRYPTION en masse"
- Reply: Simon Train: "Re: WITH ENCRYPTION en masse"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
