|
Windows
Vynikajuci prevodnik suborov v roznych codepage s commandline ovladanim prevod10.zip vid www.volny.cz/vorisekd/programy.htm
sheduling cmd davok kazdy den v xp,2000
at 07:00 /every:M,T,W,Th,F,S,Su cmd /c c:\zal\ftph.cmd
problem s windows update 0x80072EFD - nastav proxy server -> cmd.exe -> proxycfg -p proxy:port
Pakovanie do suboru - db-dnesny datum:
d:
cd d:\PPPROD.0\DB2\NODE0000\CATN0000\
d:\rar a -r -df -m5 -agYYYY-MM-DD d:\zalohadb\db
Exchange server repair databazy
1) Ran: ESEUTIL /P /ISPRIV
2) Ran: ESEUTIL /P /ISPUB
3) Removed all LOG and .CHK files
4) Ran: ISINTEG -PRI -FIX -VERBOSE -TEST ALLTESTS
4b) Ran: ESEUTIL /MH PRIV.EDB check consistancy if failed did step 4 again
5) Ran: ISINTEG -PUB -FIX -VERBOSE -TEST ALLTESTS
5b) Ran: ESEUTIL /MH PUB.EDB check consistancy if failed did step 5 again
6) Restarted all Exchange services
Steps I had to do:
1) Ran: ESEUTIL /P /ISPRIV
2) Ran: ESEUTIL /P /ISPUB
3) Removed all LOG and .CHK files
4) Ran: ISINTEG -PRI -FIX -VERBOSE -TEST ALLTESTS
5) Ran: ISINTEG -PUB -FIX -VERBOSE -TEST ALLTESTS
6) Restarted the Directory Service with is required to run ISINTEG -patch
7) Ran: ISINTEG -patch
8) Restarted the rest of the Exchange services
Tlac z dosovskych aplikacii vo winxp - cmd.exe -> net use lpt1 \\server\tlaciaren /persistent:yes
Ako v exceli previest format sekundy od 1970 na excel formu-> /86400+25569+1/24
Zapnutie podpory nastavovania prist. prav v XP workgroup
english:mmc - > Group Policy -> Security Settings container(Local Computer Policy\Computer Configuration\Windows Settings\Security Settings\Local Policies\Security Options-> Network access: Sharing and security model for local accounts, and then click Properties.
Select Classic - local users authenticate as themselves, and then click OK.
ceske:
mmc->Zasady skupiny->Mistni pocitac | Mistni pocitac - zasady -> KOnfigurace pocitace -> Nastaveni systemu windows -> Nastaveni zabezpeceni->Mistni zasady->Moznosti zabezpeceni -> Pristup k siti:Model zdileni a zabezopeceni mistnich uctu: zmenit na Klasicky-mistni uzivatele jsou overovani jak oni sami
Autoexec.bat, config.sys -> vo w2000,XP - windows/system32/autoexec.nt,config.nt
Nastavenie localnych profilov (zabranenie roaming profilov)
gpedit.msc - Local Computer Policy\Computer Configuration\Administrative Templates\System\User Profiles\
Disable: Only Allow Local User Profiles
Disable: Prevent Roaming Profile Change from Propagating to the Server
Spustatelne CD
autorun.inf:
[autorun]
OPEN=a.bat
ICON=BCB.ICO
a.bat
start.exe pokus.htm
Sub Makro1()
'
'porovna dve tabulky s priezviskami a menami na zhodu mien
'kazde meno a piezvisko s tabulky list2 hlada v tabulke list1 ak najde tak vpise do 6. stlpca list2 riadok z list1
'
For j = 1 To 1633 'pocet riadkov listu2
meno = Worksheets("List2").Cells(j, 1).Value
priez = Worksheets("List2").Cells(j, 2).Value
For I = 1 To 2140 'pocet riadkov listu1
If InStr(1, Worksheets("List1").Cells(I, 1).Value, meno, 1) <> 0 And InStr(1, Worksheets("List1").Cells(I, 2).Value, priez, 1) <> 0 Then
Worksheets("List2").Cells(j, 6).Value = I 'ak nasiel men,priez v liste1 vloz jeho poziciu
Exit For
End If
Next I
Next j
End Sub
CD.zip
|
|