Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I'm reposting this answer from ServerFault, as I initially started researching this whole problem over there.</p> <hr> <p>I finally found a way to do this in Windows 2000. It was a multi-step process. First, I wrote this script to run at logon:</p> <pre><code>Set WshNetwork = WScript.CreateObject("WScript.Network") If WshNetwork.UserName = "sysadmin" Then Set objFSO = CreateObject("Scripting.FileSystemObject") strLockFile = "C:\logonlock.txt" If objFSO.FileExists(strLockFile) Then If Now - objFSO.GetFile(strLockFile).DateLastModified &lt; 0.0001 Then 'New file, means was double start, don't run objFSO.DeleteFile(strLockFile) objFSO.CreateTextFile(strLockFile) Set objFSO = Nothing WScript.Quit End If End If 'File either doesn't exist, or is old, DO run If objFSO.FileExists(strLockFile) Then objFSO.DeleteFile(strLockFile) End If strComputer = "." Set objWMIService = GetObject("winmgmts:\\" &amp; strComputer &amp; "\root\cimv2:Win32_Process") errResult = objWMIService.Create("C:\loginshell.exe", "C:\", null, intPosID) Set objWMIService = GetObject("winmgmts:\\" &amp; strComputer &amp; "\root\cimv2") Set colProcesses = objWMIService.ExecNotificationQuery ("Select * From __InstanceDeletionEvent " &amp; "Within 1 Where TargetInstance ISA 'Win32_Process'") Do Until False = True Set objProcess = colProcesses.NextEvent If objProcess.TargetInstance.ProcessID = intPosID Then objFSO.CreateTextFile(strLockFile) Set WshShell = WScript.CreateObject("WScript.Shell") WshShell.Run "%COMSPEC% /c ""C:\Program Files\Resource Kit\logoff.exe"" /n /f", 0, False Exit Do End If Loop Else Set WshNetwork = Nothing End If </code></pre> <p>Windows 2000 doesn't come with a logoff executable, but there is a Resource Kit download for 2000 that includes it, and it appears that all our 2000 servers have it. I had to include this logonlock file code because there is an issue with the group policy, where it enacts a <a href="http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/2003_Server/Q_21623127.html" rel="nofollow">loopback</a> action, causing the script to run twice. It is possible to turn that off, but because we're not 100% if any of the servers may need it, we left it on and just came up with a workaround.</p> <p>Next, I needed to write a script to add this to the local group policy logon scripts. A few snippets of code for this:</p> <pre><code>Set oShell = CreateObject("Wscript.Shell") strScriptFile = oShell.ExpandEnvironmentStrings("%SYSTEMROOT%") &amp; "\system32\GroupPolicy\User\Scripts\scripts.ini" </code></pre> <p>That scripts.ini file is where the vbs file is added in order to be called at logon. It will look something like this:</p> <pre><code>[Logon] 0CmdLine=C:\MyScript.vbs 0Parameters= </code></pre> <p>I had to write code to add my script to that file. I'll leave the details as an exercise for the reader. :)</p> <p>Finally, I had to modify the file I found thus:</p> <pre><code>strGptFile = oShell.ExpandEnvironmentStrings("%SYSTEMROOT%") &amp; "\system32\GroupPolicy\gpt.ini" </code></pre> <p>gpt.ini has a few lines that must be modified to make the logon script listed above actually run. Here's what it looks like initially:</p> <pre><code>[General] gPCFunctionalityVersion=0 gPCMachineExtensionNames= Version=0 gPCUserExtensionNames= </code></pre> <p>The version numbers could be nonzero, and there could already be IDs on the names lines. The last two lines are the ones I had to modify for my logon script. First, the version value has to be incremented by 65536 whenever the gpt.ini file is updated. Second, you must add the following two IDs to the <code>gPCUserExtensionNames=</code> line:</p> <p><code>{42B5FAAE-6536-11D2-AE5A-0000F87571E3}</code> <code>{40B66650-4972-11D1-A7CA-0000F87571E3}</code></p> <p>It will end up looking something like this:</p> <pre><code>gPCFunctionalityVersion=0 gPCMachineExtensionNames= Version=65536 gPCUserExtensionNames=[{42B5FAAE-6536-11D2-AE5A-0000F87571E3}{40B66650-4972-11D1-A7CA-0000F87571E3}] </code></pre> <p>Don't forget to include the square brackets, and the Version value has to be incremented <em>every time</em>. Something else I discovered much later on was that sometimes the last line is not in the file at all, and must be added from scratch.</p> <p>So, it took a ton of playing around, but I was able to programmatically install a logon script. I hope someone else can benefit from this monstrosity someday.</p>
    singulars
    1. This table or related slice is empty.
    1. POChanging windows server starting program with vbscript: works in 2003, fails in 2000
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJoe M
    1. USJoe M
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POChanging windows server starting program with vbscript: works in 2003, fails in 2000
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload