That sounds like a good approach. 

There *should* be a way to use WMI to set the service passwords with a script, but the restart of the services would still have...

A better way than encrypting the passwords, and sending them back and forth across the wire, would be to hash the password in your VB program, then write a stored...

In my opinion, any production SQL server, unless it's used for tiny DBs, should have at least 2 GB of RAM.  SQL works best when you give it as much...

There is an option in SQL2K to have application role-based security.  I don't recall the details of setting that up, but I'm sure that you would grant select access to...

You should probably say whether this is a contract or full-time position, and what your salary range is.

I hate it when people touch my screen.  That is the second worst thing that can be done.

The absolute worst thing is when the janitors helpfully use some harsh, generic...

A covered index isn't necessarily every column in a table, but is an index that covers all the columns used in a particular query.  For instance, if you have a...

It probably doesn't apply in this case, but because of the compatibility mode (65) set in our DB, that query would result in a number with spaces instead of hyphens. ...

The simplest way to protect SQL in a case such as this would be to use your firewall to limit access to a single IP address for those ports (1433, 1434). ...

I've never been successful at getting the debugger to work.  So, I just use the old tried and true print statement method.  Of course, I never make mistakes, so I don't...

That's the behavior of the browser.  You wouldn't want a malicious site or prank to start 100 print jobs automatically, would you?

Still, there may be a solution.  Perhaps someone else...

One comment:  in the LIKE clause, you could use '%[a-z]%' instead of typing the whole alphabet.  Not sure how that would change for non-english alphabets.

Wouldn't it be much easier to just remove the account from the Domain Admin group, and assign it to some other group?  That would affect every server all at once,...

I'd suggest waiting 10-15 minutes. 

The Win2K users could be having trouble authenticating to the network, and are using "cached" logons.  I don't know...

Looks like Redmond, WA:  http://jobs-concur.icims.com/concur_jobs/jobs/candidate/job.jsp?jobid=1308&mode=view