Not sure I agree we'll fail in the US. We might not employ the most IT people as I can see China or India giving us competition there, but high...

Is this a generic program or specifically for your databases? If specific, figure out the hierarchy and load it from an xml/ini file.

If generic, license the depends code from Red...

Write the stored proc. You'll do it once and it will work. Even if you need to write 50 procs, it's small compared to the issues you might face with...

Search sp_helprevlogin on Technet and use that to move the logins you need to the new server.

I'm not sure I understand. Is this what happens?

1. Start server in single user mode

2. connect and run proc.

3. Another user attempts to connect and gets the errir

4. You think...

Based on BOL, you DO NOT set working set size when SQL is dynamically managing memory. BOL doesn't seem to detail much on this, but this (http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx) says to set...

If you client alias, be sure you specify a server port setting and not use dynamic ports.

I know you said the port was open, be sure it's open on the...

John has the right idea. I'd guess security or an invalid path. The SQL or Windows error log should show this.

Gordon,

There could be good reasons to limit your access. Not that I'd like it either, but you should work within your limits. If you need a test restore, then note...

Virus scanner is key. That can severely affect performance. Might also want to check and drop all indexes and recreate from scratch.

On the parallelism thing, you can restrict an individual...

Innovartis has dbGhost to help with this and a few articles as well as one I'm expecting to get sent here any day.

Can UDP 1434 get to the server? When you hit a server, this port allows the SQL browser to send back the port required for connection. Check for a server...

Eric,

A few things to consider, and it would be great if you could test a few things. First, if your logs will survive on 1 disk, then use a RAID...

I used to setup a separate admin database on each server. Use scripts to grab the size of each database, and you can find a few on this site.

Then use...

Glad you liked it. We'll be looking for you soon as a contestent after the online challenge !