Is there a max number of families? You could write self joins with that number of times if you know it. Otherwise you might need to create a temp table...

sp_who2 will also give you all connections and you can check that for the program name, or workstation name, or login name.

Profiler can be setup to scan for the...

SQL Server will be slow to release memory. Once it takes it, it tends to hold on. Usually this is mostly for the data cache. You can limit as above...

Sorry, no experience. Sounds like it might be trying to connect to the wrong port. Is the SQL Server perhaps running on a different port? Check the server network utility.

We aren't planning to go to a weekly summary for the simple reason that it isn't economical. We couldn't make enough advertising revenue on a weekly one to support the...

I'm not sure of the name, but I know there is a tool that will tell you which DC you are connecting to. It's possible that the clients or the...

It will listen on both connections and route accordingly. I don't think you want to bridge the connections and route traffic between them.

I used to have 3 networks connected...

Congratulations!

Are both machines in a domain?

Terminal services will run in a browser. It will be slow, but it could work.

Can you not just recover the file from another server?

I think if they both have the same name/password it should work. You might need the same local account on each server.

I'd do a backup for sure and then get a checkdb running. If there are any errors, call PSS.

I didn't write the question, but I was under the impression that the website might use it's login, which would be a single login.

I think it also depends upon the...

If the text in syscomments isn't readable, then it's encrypted.