Scripting help
From: Robert (netsec4u_at_hotmail.com)
Date: 10/01/04
- Next message: Aaron [SQL Server MVP]: "Re: Date Datatype Oddity - Ref "Like""
- Previous message: David Portas: "Re: Date Datatype Oddity - Ref "Like""
- Next in thread: ykchakri: "Scripting help"
- Reply: ykchakri: "Scripting help"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 1 Oct 2004 14:53:17 -0400
The attached script is intended to verify that a database exists, checks
access, and adds database roles with a twist. This script checks several
databases.
The problem that I am running into is sp_grantdbaccess only runs on the
current database. On line 65 I attempted to remedy this problem; in essence
executing 'USE <dbname>' and discovered that this command does nothing
unless followed by a 'GO' command and as a result all my variables are
destroyed.
Is there a way around this? If so how?
begin 666 GrantdbAccess.txt
M4T54(%%53U1%1%])1$5.5$E&2452($]&1B -"D=/#0I3150@04Y325].54Q,
M4R!/1D8@#0I'3PT*#0I#4D5!5$4@4%)/0T5$55)%("-S<%]#:&M2;VQE#0H)
M0&1B<F]L96YA;64@;G9A<F-H87(H,S(I+ T*"4!L;V=I;G5I9"!N=F%R8VAA
M<B@S,BD@;W5T<'5T#0I!4PT*"6EF(&YO="!E>&ES=',@*'-E;&5C="!$8E)O
M;&4@/2!G+FYA;64L($UE;6)E<DYA;64@/2!U+FYA;64L($UE;6)E<E-)1" ]
M('4N<VED#0H)9G)O;2!S>7-U<V5R<R!U+"!S>7-U<V5R<R!G+"!S>7-M96UB
M97)S(&T-"@EW:&5R92!G+FYA;64@/2! 9&)R;VQE;F%M90T*"6%N9"!G+G5I
M9" ](&TN9W)O=7!U:60-"@EA;F0@9RYI<W-Q;')O;&4@/2 Q#0H)86YD('4N
M=6ED(#T@;2YM96UB97)U:60-"@EA;F0@=2YN86UE/4!L;V=I;G5I9 T*"2D-
M"@D)97AE8R!S<%]A9&1R;VQE;65M8F5R($!D8G)O;&5N86UE+"! ;&]G:6YU
M:60-"@EE;'-E#0H)"7!R:6YT("<@(%5S97(@)R K($!L;V=I;G5I9" K("<@
M86QR96%D>2!G<F%N=&5D("<@*R! 9&)R;VQE;F%M90T*1T\-"@T*4T54(%%5
M3U1%1%])1$5.5$E&2452($]&1B -"D=/#0I3150@04Y325].54Q,4R!/3B -
M"D=/#0H-"E-%5"!154]4141?241%3E1)1DE%4B!/1D8@#0I'3PT*4T54($%.
M4TE?3E5,3%,@3T9&( T*1T\-"@T*0U)%051%(%!23T-%1%5212 C<W!?0VAK
M06-C97-S#0H)0&1B;F%M92!N=F%R8VAA<B@V-"DL#0H)0&QO9VEN=6ED(&YV
M87)C:&%R*#,R*2!O=71P=70-"D%3#0H)<')I;G0@)T-H96-K:6YG(&%C8V5S
M<R!T;R G("L@0&1B;F%M90T*"6EF(&YO="!E>&ES=',@*'-E;&5C=" J(&9R
M;VT@9&)O+G-Y<W5S97)S('=H97)E(&YA;64@/2! ;&]G:6YU:60@86YD('5I
M9" \(#$V,S@R*0T*"0E%6$5#('-P7V=R86YT9&)A8V-E<W,@0&QO9VEN=6ED
M+"! ;&]G:6YU:60-"@EE;'-E#0H)"7!R:6YT("<@(%5S97(@)R K($!L;V=I
M;G5I9" K("<@86QR96%D>2!H87,@86-C97-S)PT*"65X96-U=&4@(W-P7T-H
M:U)O;&4@)V1B7V]W;F5R)RP@0&QO9VEN=6ED(&]U='!U= T*"65X96-U=&4@
M(W-P7T-H:U)O;&4@)V1B7V1A=&%R96%D97(G+"! ;&]G:6YU:60@;W5T<'5T
M#0H)97AE8W5T92 C<W!?0VAK4F]L92 G9&)?9&%T87=R:71E<B<L($!L;V=I
M;G5I9"!O=71P=70-"D=/#0H-"E-%5"!154]4141?241%3E1)1DE%4B!/1D8@
M#0I'3PT*4T54($%.4TE?3E5,3%,@3TX@#0I'3PT*#0I3150@455/5$5$7TE$
M14Y4249)15(@3T9&( T*1T\-"E-%5"!!3E-)7TY53$Q3($]&1B -"D=/#0H-
M"D-214%412!04D]#14154D4@(W-P7T-H:V1B#0H)0&1B;F%M92!N=F%R8VAA
M<B@V-"DL#0H)0&QO9VEN=6ED(&YV87)C:&%R*#,R*2!O=71P=70-"D%3#0H)
M9&5C;&%R92! 4U%,<W1M="!N=F%R8VAA<B@R-38I#0H):68@97AI<W1S("AS
M96QE8W0@*B!F<F]M(&UA<W1E<BYD8F\N<WES9&%T86)A<V5S('=H97)E(&YA
M;64@/2! 9&)N86UE*0T*"4)%1TE.#0H)"7-E;&5C="! 4U%,<W1M=#TG55-%
M("<@*R! 9&)N86UE#0H)"65X96,H0%-13'-T;70I#0H)"65X96-U=&4@(W-P
M7T-H:T%C8V5S<R! 9&)N86UE+"! ;&]G:6YU:60@;W5T<'5T#0H)96YD.PT*
M"65L<V4-"@D)<')I;G0@0&1B;F%M92 K("<@9&]E<R!N;W0@97AI<W0G#0H)
M<')I;G0@)R<-"D=/#0H-"E-%5"!154]4141?241%3E1)1DE%4B!/1D8@#0I'
M3PT*4T54($%.4TE?3E5,3%,@3TX@#0I'3PT*#0H-"F1E8VQA<F4@0&1B;F%M
M92!N=F%R8VAA<B@V-"D-"F1E8VQA<F4@0&QO9VEN=6ED(&YV87)C:&%R*#,R
M*0T*#0IS96QE8W0@0&QO9VEN=6ED(#T@3B=I8V]N)PT*#0IE>&5C=71E("-S
M<%]#:&MD8B! 9&)N86UE/4XG06-C;W5N=&EN9R<L($!L;V=I;G5I9" ]($!L
M;V=I;G5I9 T*97AE8W5T92 C<W!?0VAK9&(@0&1B;F%M93U.)T-I=FEL)RP@
M0&QO9VEN=6ED(#T@0&QO9VEN=6ED#0IE>&5C=71E("-S<%]#:&MD8B! 9&)N
M86UE/4XG0V]M;6]N)RP@0&QO9VEN=6ED(#T@0&QO9VEN=6ED#0IE>&5C=71E
M("-S<%]#:&MD8B! 9&)N86UE/4XG0W)I;6EN86PG+"! ;&]G:6YU:60@/2!
M;&]G:6YU:60-"F5X96-U=&4@(W-P7T-H:V1B($!D8FYA;64]3B='96YE<F%L
M)RP@0&QO9VEN=6ED(#T@0&QO9VEN=6ED#0IE>&5C=71E("-S<%]#:&MD8B!
M9&)N86UE/4XG2F%I;"<L($!L;V=I;G5I9" ]($!L;V=I;G5I9 T*97AE8W5T
M92 C<W!?0VAK9&(@0&1B;F%M93U.)TIU=F5N:6QE)RP@0&QO9VEN=6ED(#T@
M0&QO9VEN=6ED#0IE>&5C=71E("-S<%]#:&MD8B! 9&)N86UE/4XG3&%N9%)E
M8V]R9',G+"! ;&]G:6YU:60@/2! ;&]G:6YU:60-"F5X96-U=&4@(W-P7T-H
M:V1B($!D8FYA;64]3B=,87=%;F9O<F-E;65N="<L($!L;V=I;G5I9" ]($!L
M;V=I;G5I9 T*97AE8W5T92 C<W!?0VAK9&(@0&1B;F%M93U.)TUA9VES=')A
M=&4G+"! ;&]G:6YU:60@/2! ;&]G:6YU:60-"@T*1%)/4"!04D]#14154D4@
M(W-P7T-H:U)O;&4-"D123U @4%)/0T5$55)%("-S<%]#:&M!8V-E<W,-"D12
83U @4%)/0T5$55)%("-S<%]#:&MD8@T*
`
end
- Next message: Aaron [SQL Server MVP]: "Re: Date Datatype Oddity - Ref "Like""
- Previous message: David Portas: "Re: Date Datatype Oddity - Ref "Like""
- Next in thread: ykchakri: "Scripting help"
- Reply: ykchakri: "Scripting help"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
