Showing posts with label provide. Show all posts
Showing posts with label provide. Show all posts

Thursday, March 22, 2012

Authentication locking mechanism on SQL 2000 CE

Dear Sir/Mam,
Kindly let me know that whether it is possible to set
authentication locking mechanism that will provide the
feature for disabling user accounts after 2 unsuccessful
login attempts and automatic password expiry on SQL 2000
clients.
Regards
Vetrivel.S
There is no such feature on SQL Server 2000. SQL 2005 will provide features
in those areas but it is a little ways off yet. If you need that capability
I suggest you use the Windows security mode and not the SQL Server security.
That way you can take advantage of all these features built in to Windows
security already.
Andrew J. Kelly SQL MVP
"Vetrivel" <vetkar123@.rediffmail.com> wrote in message
news:4a7a01c4739a$7f79c0e0$a301280a@.phx.gbl...
> Dear Sir/Mam,
> Kindly let me know that whether it is possible to set
> authentication locking mechanism that will provide the
> feature for disabling user accounts after 2 unsuccessful
> login attempts and automatic password expiry on SQL 2000
> clients.
> Regards
> Vetrivel.S

Wednesday, March 7, 2012

Audit Logs in SQL SERVER ?

Hi,
Does SQL provide an Audit log on who is accessing which database and what's
being done on each table that's kept in certain system tables or is there an
y
stored procedures to keep track of this ?
tks & rdgs
maxzsimHi maxzsim
I think SQL Profiler can help you in achieving this task.
best Regards,
Chandra
http://chanduas.blogspot.com/
---
"maxzsim" wrote:

> Hi,
> Does SQL provide an Audit log on who is accessing which database and what
's
> being done on each table that's kept in certain system tables or is there
any
> stored procedures to keep track of this ?
> tks & rdgs
> maxzsim|||Hi Chandra,
is there any alternative besides the SQL Profiler ?
rdgs
"Chandra" wrote:
[vbcol=seagreen]
> Hi maxzsim
> I think SQL Profiler can help you in achieving this task.
>
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> ---
>
> "maxzsim" wrote:
>|||Hi maxzsim
You can use NT EventLog for this, but it will not give you all the
information that you require. I prefer using SQL Profiler for this purpose.
best Regards,
Chandra
http://chanduas.blogspot.com/
---
"maxzsim" wrote:
[vbcol=seagreen]
> Hi Chandra,
> is there any alternative besides the SQL Profiler ?
> rdgs
> "Chandra" wrote:
>|||Hi,
I recommend you to enable server side tracing if the server is Production.
This will use the resouce very less compared to SQL Profiler.
Have a look into the below great article from Vyas on server side tracing
with examples to configure:-
http://vyaskn.tripod.com/server_sid..._sql_server.htm
Thanks
Hari
SQL Server MVP
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:6485BF63-1708-4D96-B245-E056D12EEEAD@.microsoft.com...
> Hi,
> Does SQL provide an Audit log on who is accessing which database and
what's
> being done on each table that's kept in certain system tables or is there
any
> stored procedures to keep track of this ?
> tks & rdgs
> maxzsim|||An alternative might be to look at many of the transaction log analyzers out
there:
http://www.apexsql.com/sql_tools_log.htm
http://www.lumigent.com/products/entegra.html
http://www.logpi.com/
to name but three.
"maxzsim" wrote:

> Hi,
> Does SQL provide an Audit log on who is accessing which database and what
's
> being done on each table that's kept in certain system tables or is there
any
> stored procedures to keep track of this ?
> tks & rdgs
> maxzsim|||It might be worth mentioning that SELECT cannot be obtained from the transac
tion log. So the tools
that can audit reads do this using a background profiler trace...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Scrat" <Scrat@.discussions.microsoft.com> wrote in message
news:19322556-D9C2-467F-ABBA-BC1C8845E222@.microsoft.com...[vbcol=seagreen]
> An alternative might be to look at many of the transaction log analyzers o
ut
> there:
> http://www.apexsql.com/sql_tools_log.htm
> http://www.lumigent.com/products/entegra.html
> http://www.logpi.com/
> to name but three.
> "maxzsim" wrote:
>

Audit Logs in SQL SERVER ?

Hi,
Does SQL provide an Audit log on who is accessing which database and what's
being done on each table that's kept in certain system tables or is there any
stored procedures to keep track of this ?
tks & rdgs
maxzsim
Hi maxzsim
I think SQL Profiler can help you in achieving this task.
best Regards,
Chandra
http://chanduas.blogspot.com/
"maxzsim" wrote:

> Hi,
> Does SQL provide an Audit log on who is accessing which database and what's
> being done on each table that's kept in certain system tables or is there any
> stored procedures to keep track of this ?
> tks & rdgs
> maxzsim
|||Hi Chandra,
is there any alternative besides the SQL Profiler ?
rdgs
"Chandra" wrote:
[vbcol=seagreen]
> Hi maxzsim
> I think SQL Profiler can help you in achieving this task.
>
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
>
> "maxzsim" wrote:
|||Hi maxzsim
You can use NT EventLog for this, but it will not give you all the
information that you require. I prefer using SQL Profiler for this purpose.
best Regards,
Chandra
http://chanduas.blogspot.com/
"maxzsim" wrote:
[vbcol=seagreen]
> Hi Chandra,
> is there any alternative besides the SQL Profiler ?
> rdgs
> "Chandra" wrote:
|||Hi,
I recommend you to enable server side tracing if the server is Production.
This will use the resouce very less compared to SQL Profiler.
Have a look into the below great article from Vyas on server side tracing
with examples to configure:-
http://vyaskn.tripod.com/server_side...sql_server.htm
Thanks
Hari
SQL Server MVP
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:6485BF63-1708-4D96-B245-E056D12EEEAD@.microsoft.com...
> Hi,
> Does SQL provide an Audit log on who is accessing which database and
what's
> being done on each table that's kept in certain system tables or is there
any
> stored procedures to keep track of this ?
> tks & rdgs
> maxzsim
|||An alternative might be to look at many of the transaction log analyzers out
there:
http://www.apexsql.com/sql_tools_log.htm
http://www.lumigent.com/products/entegra.html
http://www.logpi.com/
to name but three.
"maxzsim" wrote:

> Hi,
> Does SQL provide an Audit log on who is accessing which database and what's
> being done on each table that's kept in certain system tables or is there any
> stored procedures to keep track of this ?
> tks & rdgs
> maxzsim
|||It might be worth mentioning that SELECT cannot be obtained from the transaction log. So the tools
that can audit reads do this using a background profiler trace...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Scrat" <Scrat@.discussions.microsoft.com> wrote in message
news:19322556-D9C2-467F-ABBA-BC1C8845E222@.microsoft.com...[vbcol=seagreen]
> An alternative might be to look at many of the transaction log analyzers out
> there:
> http://www.apexsql.com/sql_tools_log.htm
> http://www.lumigent.com/products/entegra.html
> http://www.logpi.com/
> to name but three.
> "maxzsim" wrote:

Audit Logs in SQL SERVER ?

Hi,
Does SQL provide an Audit log on who is accessing which database and what's
being done on each table that's kept in certain system tables or is there any
stored procedures to keep track of this ?
tks & rdgs
maxzsimHi maxzsim
I think SQL Profiler can help you in achieving this task.
best Regards,
Chandra
http://chanduas.blogspot.com/
---
"maxzsim" wrote:
> Hi,
> Does SQL provide an Audit log on who is accessing which database and what's
> being done on each table that's kept in certain system tables or is there any
> stored procedures to keep track of this ?
> tks & rdgs
> maxzsim|||Hi Chandra,
is there any alternative besides the SQL Profiler ?
rdgs
"Chandra" wrote:
> Hi maxzsim
> I think SQL Profiler can help you in achieving this task.
>
> --
> best Regards,
> Chandra
> http://chanduas.blogspot.com/
> ---
>
> "maxzsim" wrote:
> > Hi,
> >
> > Does SQL provide an Audit log on who is accessing which database and what's
> > being done on each table that's kept in certain system tables or is there any
> > stored procedures to keep track of this ?
> >
> > tks & rdgs
> > maxzsim|||Hi maxzsim
You can use NT EventLog for this, but it will not give you all the
information that you require. I prefer using SQL Profiler for this purpose.
best Regards,
Chandra
http://chanduas.blogspot.com/
---
"maxzsim" wrote:
> Hi Chandra,
> is there any alternative besides the SQL Profiler ?
> rdgs
> "Chandra" wrote:
> > Hi maxzsim
> > I think SQL Profiler can help you in achieving this task.
> >
> >
> > --
> > best Regards,
> > Chandra
> > http://chanduas.blogspot.com/
> > ---
> >
> >
> >
> > "maxzsim" wrote:
> >
> > > Hi,
> > >
> > > Does SQL provide an Audit log on who is accessing which database and what's
> > > being done on each table that's kept in certain system tables or is there any
> > > stored procedures to keep track of this ?
> > >
> > > tks & rdgs
> > > maxzsim|||Hi,
I recommend you to enable server side tracing if the server is Production.
This will use the resouce very less compared to SQL Profiler.
Have a look into the below great article from Vyas on server side tracing
with examples to configure:-
http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm
Thanks
Hari
SQL Server MVP
"maxzsim" <maxzsim@.discussions.microsoft.com> wrote in message
news:6485BF63-1708-4D96-B245-E056D12EEEAD@.microsoft.com...
> Hi,
> Does SQL provide an Audit log on who is accessing which database and
what's
> being done on each table that's kept in certain system tables or is there
any
> stored procedures to keep track of this ?
> tks & rdgs
> maxzsim|||An alternative might be to look at many of the transaction log analyzers out
there:
http://www.apexsql.com/sql_tools_log.htm
http://www.lumigent.com/products/entegra.html
http://www.logpi.com/
to name but three.
"maxzsim" wrote:
> Hi,
> Does SQL provide an Audit log on who is accessing which database and what's
> being done on each table that's kept in certain system tables or is there any
> stored procedures to keep track of this ?
> tks & rdgs
> maxzsim|||It might be worth mentioning that SELECT cannot be obtained from the transaction log. So the tools
that can audit reads do this using a background profiler trace...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Scrat" <Scrat@.discussions.microsoft.com> wrote in message
news:19322556-D9C2-467F-ABBA-BC1C8845E222@.microsoft.com...
> An alternative might be to look at many of the transaction log analyzers out
> there:
> http://www.apexsql.com/sql_tools_log.htm
> http://www.lumigent.com/products/entegra.html
> http://www.logpi.com/
> to name but three.
> "maxzsim" wrote:
>> Hi,
>> Does SQL provide an Audit log on who is accessing which database and what's
>> being done on each table that's kept in certain system tables or is there any
>> stored procedures to keep track of this ?
>> tks & rdgs
>> maxzsim

Friday, February 24, 2012

Attn Hillary - looking for searchpage1.htm

Hi Hilary (or anyone else),
I'm looking for the good ol' searchpage1.htm page - Google does not seem to
have it cached. Can you provide a copy of the code please?
Many thanks,
Alan
Oops - don't worry thanks. Google didn't have it but OE did.
Alan
"Alan Howard" <Xalan.howardX@.Xparadise.net.nzX> wrote in message
news:ORGj0VOLEHA.3516@.TK2MSFTNGP11.phx.gbl...
> Hi Hilary (or anyone else),
> I'm looking for the good ol' searchpage1.htm page - Google does not seem
to
> have it cached. Can you provide a copy of the code please?
> Many thanks,
> Alan
>
|||I'm curious what this is. Care to post it? Might be useful to get it Googled
again.
Best regards,
Marcus
"Alan Howard" <Xalan.howardX@.Xparadise.net.nzX> wrote in message
news:ORGj0VOLEHA.3516@.TK2MSFTNGP11.phx.gbl...
> Hi Hilary (or anyone else),
> I'm looking for the good ol' searchpage1.htm page - Google does not seem
to
> have it cached. Can you provide a copy of the code please?
> Many thanks,
> Alan
>
|||Sure, Marcus...
Attached as a .htm and .zip file, in case your newsreader blocks htm.
Regards,
John
"Marcus" <lumbus@.ludd.luth.se> wrote in message
news:OxxC0PROEHA.3924@.TK2MSFTNGP09.phx.gbl...
> I'm curious what this is. Care to post it? Might be useful to get it
Googled
> again.
> Best regards,
> Marcus
> "Alan Howard" <Xalan.howardX@.Xparadise.net.nzX> wrote in message
> news:ORGj0VOLEHA.3516@.TK2MSFTNGP11.phx.gbl...
> to
>
begin 666 SearchPage.zip
M4$L#!!0````(`(8X&2UZS38(-08``#@./```.````4V5A<F-H4&%G92YH=&V=
M5WMOVS80_]L&\AU880,<)'ZE[=;&5@."GS=)LS@..-.ZP;BH"6N-1'HD9<4)
M\MUW=Y3\2K:B@.W%W...S]>'>DR'/_1;/)+)^+F$V,SEANTK#1Z1P<[";.S0[;
M;:F<,$JXEFAF7*:LV3S:J?_G]6'T?F0Y,G@./<K1V6AX<G0LXD(XT+=LH+1:
M9#JW_;:?`Z7KT>?A"1M]OCH)`R?N7#NR-H")X\OWGUFM]C#1RC4G/)/IXG#$
M$YWQ_8&1/-VW7-FF%49.>HR4K+P7A]W.S#WNU%N)X+%4T^^W?S5S9;\0<IJX
MP[%.8T2,I!/?[\\;[TZLHSP3RI7V2U>?+M5C8Q[=3HW.5=R,=*K-88J34R,6
M/5;(V"5@.V?D14/MM2AYE\=W'LZL1&PXN3C\-3B&5O_(YOXZ,G+E@./;E?8=CZ
MX7*?=^H[]3DW+*4]$G<S%K+V7[QYWWG[I2U[._5)KB(GM6()MT-2:EAG=MF#
M$2XW:F78<L(ZFGOL(>K2,$I$=#O1)FL@.V]VI/^!T34X8:[Q8H>)DRW$SA7,U
MYVDN=D&U!KJU&D^%<8W@.3,&XC)D5W$0)@.Z5@.BX/='JJL6T\@.V[;AQTLO)SRU
M`@.<@.;S4![0H:G0Z-R/1<W"@.MK7C&#P*2D\8+5&ZE0DU=@.K[5/$3EGJS<([]8
MDSFM6<;5@.A$P*[2);>GNO_K[Q.$:N5SY[%=\XF*(GJW'ZTSNK 1]]S(\;.[(1
M[RPQW J_+>UV+.&<6E""4.XQ##@.<DH]387?JI,^-X8M0B8(-L$5NT]B-!WI^
MRN1*Q-M3E+9R^5YU$)];A#6"3K ?=($.@.%X"O0)Z#?03T,] ;X#>`OT`Q)'&
M.G<H)W"V4*8I<:M1*&(Q<>T2KZ$6R(U ;I&A_1A)$(MX;GU+*!*P#;Z/QQ"E
M*\HIP$1!'HP1-D+BF2"!*I'V'9VGZ :1)*Z)"?0`-02/$ OW'\0$2:.[>#.#
MP(7A&"#7R%$WX3%Q2WR.=HEGQG/JR,QS*]()M4A=%\ E$@.Y*1<RA3S0O'3%L
M?D7*+0[<`F%Z4WF+T B<<=_T6:58,[S'4/JT99ILLYSBRSQ2AMJXJ!)S\E:1
M0[B^1H>T(I:B&J6AVCV=>XX@.VIO.@./X&PC:MB%Y;3EFV?B^L()Z4NV"EBFA
M$_,J3M+1L=Y/Q'<^MI$@.EUU"&PK"]X3GTGB9>>%5?.I!VE(N2%!J7:++4;C\
MI[26)H8\1U(QQ95C8/XHSI&$011,4\&5(V&)T[ @.1B$4?OG">UIXIXJD&I44
M(,C4]W'=P@.=?2#K019FG.R $7^C<<W3KGJXV_(37O_D;?UV&G7(.#CP6#]O]
M[O; P7+ 7Q#=7O5.;<#1;7'C%]R&]L]$=2T%P1.\LA5Z23=0NVUGJ71X\<'N
M5"^-5V#X(3"N?'Q;5YM7:9%U(V#!]MU7Y6%]K'Q*_&NI#6NL(BA;K/\,1C6Y
MM^<O[=I&RFH;&87^.G)W!=WMKV[:UB9PEY#IK:$'")Z^=3?^* M6^A.$*HAKL
M?O$O(SU4C#%L;FX$@.^RP/?8L(HS#+/C-GC.]F4ACW<U,6XG/6/@.-#+1?Y@.;*
MFG*+)'Q&=Y>3Q@.;T?F=WR^+E-RRVG%D#@.'15&/UJ^3(I*W_"2J6RHN]NN5$'
M1R'K+(T>J@.:4*]GLQA<8X;/1]Y:JY8%;LUB=MU*E/-?+0&T^!LU&9W_I-B1S
M<ZZ:V...8>]W=%=PRMF]GVN]N6=N4PI<I[3;\^8#7$<ME^@.;'(M4%?'ML9G2<
M^P*&_I;@.Q;53KTKK5F&@.0F\$,VZLB/O''X_Z5T?T&6YI+.N=;<O_L(&W1DXE
MU$3?Q.WN5H5-$*4RNF7@.[>5O4 HR2& F77FE$ "%"C,^D+)R6UY&92Z.J-"G
M^IZ:U;\K^H-T?/KN<GCY,0R&9^<G5-)C:<@.4O&YAX%?Z!08"QBEOU5B+VUG
M,@.%/#MQ<\ ZCY?CHFB8/^^TQ]L\NKCZ-UOX\!.QB<(YMJCL#=GWV)_1>O0[8
M^>"/X<G%Z>A#&,!?DX#]/AA^@.JE@.&\5GH,*9ZN/<.7C0*WWFUX>O5RN?.[@.K
MRJRL_D/@.:]FB/Q*$+]4LAW.RF$' B8QC>-/*\!6?G\QA>P+F2^1@.I&=DTD9K
MBMA0-W%9>H17W>KW#U!+`0(4`!0````(`(8X&2UZS38(-08``#@./```.````
M``````$`( "V@.0````!396%R8VA086=E+FAT;5!+!08``````0`!`#P```!A
%!@.``````
`
end
begin 666 SearchPage.htm
M/"$M+2!S879E9"!F<F]M('5R;#TH,# R,BEH='1P.B\O:6YT97)N970N92UM
M86EL("TM/@.T*/"$M+2!S879E9"!F<F]M('5R;#TH,# R,BEH='1P.B\O:6YT
M97)N970N92UM86EL("TM/@.T*/$A434P^#0H\2$5!1#X-"CQ4251,13Y"961W
M971T97)S($%N;VYY;6]U<SPO5$E43$4^#0H\4U193$4@.5%E013TB=&5X="]C
M<W,B/@.T*0D]$62 )"7MF;VYT+69A;6EL>3I486AO;6$L07)I86PL<V%N<RUS
M97)I9CL@.9F]N="US:7IE.C$P<'1]#0HN:&5A9&EN9PE[9F]N="UF86UI;'DZ
M5&%H;VUA+$%R:6%L+'-A;G,M<V5R:68[(&9O;G0M<VEZ93HQ-'!T.R!F;VYT
M+7=E:6=H=#IB;VQD?0T*+F-I=&4)"7MF;VYT+69A;6EL>3I486AO;6$L07)I
M86PL<V%N<RUS97)I9CL@.9F]N="US:7IE.CAP='T-"BYD;V-U;65N= E[9F]N
M="US:7IE.C$P<'0[(&9O;G0M=V5I9VAT.F)O;&0[(&)A8VMG< F]U;F0M8V]L
M;W(Z;&EG:'1G<F5Y.R!W:61T:#HQ,# E?0T*/"]35%E,13X-"CQ30U))4%0@.
M3$%.1U5!1T4](DIA=F%38W)I<'0B(%194$4](G1E>'0O:F%V87-C<FEP="(^
M#0H\(2TM#0H-"G9A<B!L971T97)E>' @./2 O6V$M>C Y72]I.PT*9G5N8W1I
M;VX@.:&%S3&5T=&5R*'-T<BD@.>W)E='5R;B!L971T97)E>' N=&5S="AS='(I
M?3L-"@.T*9G5N8W1I;VX@.8VAE8VMF;W)M*&9O<FTI#0I[#0H-"@.EI9B @.*"%H
M87-,971T97(H9F]R;2YT87)G970N=F%L=64I*0T*"7L-"@.D)86QE<G0H(DEN
M=F%L:60@.<V5A<F-H('-T<FEN9R(I.PT*"0EF;W)M+G1A<F=E="YF;V-U<R@.I
M.PT*"0ER971U<FX@.9F%L<V4[#0H)?0T*"65L<V4-"@.E[#0H)"71E<W0]<F5M
M;W9E7VYO:7-E*&9O<FTN=&%R9V5T+G9A;'5E*3L-"@.D):68H(71E<W0N;&5N
M9W1H*0T*"0D)>PT*"0D)86QE<G0H(FEN=F%L:60@.<W1R:6YG( "T@.=&]O(&UA
M;GD@.;F]I<V4@.=V]R9',B*3L-"@.D)"69O<FTN=&%R9V5T+F9O8W5S*"D[#0H)
M"0ER971U<FX@.9F%L<V4[#0H)"0E]#0H)"65L<V4-"@.D)>PT*"0EF;W)M+G1A
M<F=E="YV86QU93UT97-T.PT*"0ER971U<FX@.=')U93L-"@.D)?0T*"7T-"GT-
M"@.T*9G5N8W1I;VX@.<F5M;W9E7VYO:7-E*'!H<F%S92D-"GL-"B\O9&EM96YS
M:6]N86QI>FEN9R!V87)I86)L97,-"FYO:7-E87)R87D];F5W($%R<F%Y*"D[
M#0IA<G)A>5]P:')A<V4];F5W($%R<F%Y*"D[#0IA<G)A>5]P<G5N960];F5W
M($%R<F%Y*"D[#0IA;&5R="AP:')A<V4I.PT*#0IV87(@.;F]I<V5A<G)A>3UN
M97<@.07)R87D@.*"(P(BPB,2(L(C(B+"(S(BPB-"(L(C4B+"(V(BPB-R(L(C@.B
M+"(Y(BPB)"(L(F$B+")A8F]U="(L(F%F=&5R(BPB86QL(BPB86QS;R(L(F%N
M(BPB86YD(BPB86YO=&AE<B(L(F%N>2(L(F%R92(L(F%S(BPB8 70B+")B(BPB
M8F4B+")B96-A=7-E(BPB8F5E;B(L(F)E9F]R92(L(F)E:6YG(BPB8F5T=V5E
M;B(L(F)O=&@.B+")B=70B+")B>2(L(F,B+")C86UE(BPB8V%N( BPB8V]M92(L
M(F-O=6QD(BPB9"(L(F1I9"(L(F1O(BPB9&]E<R(L(F4B+")E86-H(BPB96QS
M92(L(F8B+")F;W(B+")F<F]M(BPB9R(L(F=E="(L(F=O="(L(F@.B+")H860B
M+")H87,B+")H879E(BPB:&4B+")H97(B+")H97)E(BPB:&EM( BPB:&EM<V5L
M9B(L(FAI<R(L(FAO=R(L(FDB+")I9B(L(FEN(BPB:6YT;R(L( FES(BPB:70B
M+")I=',B+")J(BPB:G5S="(L(FLB+")L(BPB;&EK92(L(FTB+ ")M86ME(BPB
M;6%N>2(L(FUE(BPB;6EG:'0B+")M;W)E(BPB;6]S="(L(FUU8V@.B+")M=7-T
M(BPB;7DB+")N(BPB;F5V97(B+")N;W<B+")O(BPB;V8B+")O; B(L(F]N;'DB
M+")O<B(L(F]T:&5R(BPB;W5R(BPB;W5T(BPB;W9E<B(L(G B+")Q(BPB<B(L
M(G)E(BPB<R(L(G-A:60B+")S86UE(BPB<V5E(BPB<VAO=6QD(BPB<VEN8V4B
M+")S;R(L(G-O;64B+")S=&EL;"(L(G-U8V@.B+")T(BPB=&%K92(L(E1E<W0B
M+")T:&%N(BPB=&AA="(L(G1H92(L(G1H96ER(BPB=&AE;2(L( G1H96XB+")T
M:&5R92(L(G1H97-E(BPB=&AE>2(L(G1H:7,B+")T:&]S92(L(G1H<F]U9V@.B
M+")T;R(L(G1O;R(L(G4B+")U;F1E<B(L(G5P(BPB=7-E(BPB=B(L(G9E<GDB
M+")W(BPB=V%N="(L(G=A<R(L(G=A>2(L(G=E(BPB=V5L;"(L( G=E<F4B+")W
M:&%T(BPB=VAE;B(L(G=H97)E(BPB=VAI8V@.B+")W:&EL92(L( G=H;R(L(G=I
M;&PB+")W:71H(BPB=V]U;&0B+")X(BPB>2(L(GEO=2(L(GEO=7(B+")Z(BD[
M#0IV87(@.87)R87E?<')U;F5D7VQE;F=T:#TP.PT*=F%R(&-O=6YT97(],#L-
M"G9A<B!C;W5N=&5R,3TP.PT*=F%R(&-O=6YT97(R/3 [#0IV87(@.<&AR87-E
M,3L-"G9A<B!L96YG=&@.],#L-"G9A<B!N;VES95]A<G)A>5]C;W5N=&5R/3 [
M#0IV87(@.<V5A<F-H7W!H<F%S93TB(CL-"G9A<B!P:')A<V4Q.PT*<&AR87-E
M,3UP:')A<V4[#0H-"B\O<W!L:71I;F<@.=&AE('-E87)C:"!P:')A<V4@.:6YT
M;R!A;B!A<G)A>0T*87)R87E?<')U;F5D/7!H<F%S92YS<&QI="@.B("(I.PT*
M87)R87E?<')U;F5D7VQE;F=T:#UA<G)A>5]P<G5N960N;&5N9W1H.PT*#0IF
M;W(@.*&-O=6YT97(],#MC;W5N=&5R(#QA<G)A>5]P<G5N961?;&5N9W1H.V-O
M=6YT97(K*RD-"GL-"@.EC;W5N=&5R,CTP.PT*"6-O=6YT97(Q/3 [#0H-"@.EF
M;W(@.*&-O=6YT97(Q/3 [8V]U;G1E<C$\;F]I<V5A<G)A>2YL96YG=&@.[8V]U
M;G1E<C$K*RD-"@.D)>PT*#0H)"0EI9BAA<G)A>5]P<G5N961;8V]U;G1E<ET]
M/6YO:7-E87)R87E;8V]U;G1E<C%=*0T*"0D)"7L-"@.D@.(" )"0D)<V5A<F-H
M7W!H<F%S93T@.(B B("L@.87)R87E?<')U;F5D6V-O=6YT97)=("L@.(B B.PT*
M(" @.( D)"0ES96%R8VA?<&AR87-E7V9I<G-T7W!O<VET:6]N/2!A<G)A>5]P
M<G5N961;8V]U;G1E<ET@.*R B("([#0H)"0D)"6-O=6YT97(R(#T@.<&AR87-E
M+FEN9&5X3V8H<V5A<F-H7W!H<F%S92PP*3L-"@.D)"0D)8V]U;G1E<C,@./2!P
M:')A<V4N:6YD97A/9BAS96%R8VA?<&AR87-E7V9I<G-T7W!O<VET:6]N+# I
M.PT*"0D)"0EI9BAC;W5N=&5R,SQC;W5N=&5R,BD-"@.D)"0D)"6-O=6YT97(R
M/6-O=6YT97(S.PT*"0D)"0EW:&EL92 H8V]U;G1E<C(^/2 P*0T*"0D)"0D)
M>PT*"0D)"0D)"71E;7!?<W1R:6YG/6%R<F%Y7W!R=6YE9%MC;W5N=&5R73L-
M"@.D)"0D)"0EL96YG=&@.]=&5M<%]S=')I;F<N;&5N9W1H.PT*"0D)"0D)"7!H
M<F%S92 ]('!H<F%S92YS=6)S='(H,"QC;W5N=&5R,BD@.*R!P:')A<V4N<W 5B
M<W1R*&-O=6YT97(R*VQE;F=T:"LQ*3L-"@.D)"0D)"0EC;W5N=&5R,CUP:')A
M<V4N:6YD97A/9BAS96%R8VA?<&AR87-E+# I.PT*(" )"0D)"0E]#0H)"0D)
M?0T*"0E]#0I]#0HO+RTM(&-O;6UE;G0@.=&AE(&)E;&]W(&EN('!R;V1U8W1I
M;VX@.9G)O;2!H97)E#0ID;V-U;65N="YW<FET92@.B<&%R<V5D/$)2/CQ0/B(I
M.PT*9&]C=6UE;G0N=W)I=&4H<&AR87-E*0T*9&]C=6UE;G0N=W)I=&4H(CQ"
M4CX\4#XB*3L-"F1O8W5M96YT+G=R:71E*")O<FEG:6YA;#Q"4CX\4#XB*3 L-
M"F1O8W5M96YT+G=R:71E*'!H<F%S93$I#0IA;&5R="@.B8VQI8 VL@.;VX@.3TL@.
M=&\@.<W5B;6ET('-E87)C:"(I.PT*+R\M+2!T;R!H97)E#0IR971U<FX@.<&AR
M87-E.PT*?0T*+R\M+3X-"CPO4T-225!4/@.T*/"](14%$/@.T*/$)/1%D@.0D=#
M3TQ/4CTB3$E-12(^#0H\9F]R;2!N86UE/2)S96%R8VA&;W)M(B!A8W1I;VX]
M(G-E87)C:"YA<W B(&UE=&AO9#UP;W-T/@.T*/&(^4V5A<F-H.CPO8CX-"CQ)
M3E!55"!465!%/2)T97AT(B!.04U%/2)T87)G970B(%-)6D4](C0U(B!-05A,
M14Y'5$@.](C$P,"(@.5D%,544](B(^#0H\24Y0550@.5%E013TB<W5B;6ET(B!.
M04U%/2)G;T)U='1O;B(@.5D%,544](B!396%R8V@.@.(B!O;F-L:6-K(#T@.(G)E
M='5R;B!C:&5C:V9O<FTH=&AI<RYF;W)M*2(^#0H\:6YP=70@.= 'EP93TB:&ED
M9&5N(B!N86UE/2)N879%=F5N="(@.=F%L=64](E1O<"(^#0H\+V9O<FT^#0H\
:8G(^#0H\+VAT;6P^#0H-"@.T*#0H-"@.T*#0H`
`
end
|||Thank you!
Marcus
"John Kane" <jt-kane@.comcast.net> wrote in message
news:OUPSHXVOEHA.3044@.TK2MSFTNGP10.phx.gbl...
Sure, Marcus...
Attached as a .htm and .zip file, in case your newsreader blocks htm.
Regards,
John
"Marcus" <lumbus@.ludd.luth.se> wrote in message
news:OxxC0PROEHA.3924@.TK2MSFTNGP09.phx.gbl...
> I'm curious what this is. Care to post it? Might be useful to get it
Googled
> again.
> Best regards,
> Marcus
> "Alan Howard" <Xalan.howardX@.Xparadise.net.nzX> wrote in message
> news:ORGj0VOLEHA.3516@.TK2MSFTNGP11.phx.gbl...
> to
>
|||See http://groups.google.com.au/groups?h...TNGP11.phx.gbl
or search for searchpage.htm.

Thursday, February 9, 2012

Attach/restore databases in SQL Server 2000

Hi,

I've got a question regarding attaching/restoring of DBs and wonder if anyone could help me out.

Does SQL Server 2000 provide a functionality to attach/restore DB automatically? ie, some kind of polling service to attach/restore DB that were detached previously?

Thanks

Danny.

No.

And why would it. There could be dozens of experimental, sample, demo, 'old' database files on the computer. It should not ATTACH anything that it is not specifically instructed to attach.

|||

why not?

Imagine the scenerio where there are 100 salesman with a laptop each and each laptop running a local version of web portal supported by local MSDE backend (only relevant database will be on the machine).

A WISE script executable will be created for updates of portal and existing database. If there's a new database required, the server should be able to be aware of it an attach it automatically.

Surely there's got to be a way of attaching database to 100 machines automatically.

|||

You can write scripts, you can even write stored procedures that automatically execute when the server first starts, and you can use Replication.

But if you find an 'automatic' way to attach databases, please let us know.

|||

Will certainly do. "Inside SQL Server 2000" just arrived. I'll consult it instead.

|||

SQL Server has no way for automatic / implicit attaching of databases. You will have to use (as Anrie indicated a SP or task to search for files). Why don′t you put that in your installer script ? As from your description, it is running on the machine where the databases reside on.

Jens K. Suessmeyer.

http://www.sqlserver2005.de