I think Mark has it right. Do it to a disk file, not a device.

I haven't really used the advisor in 2005, but it didn't work well in SS2K. Bad suggestions, took too long to run, just stays away.

Go with one set of tables...

First you need to post in the correct forum. The titles are all above, so this would be posted in the SSIS forum (I've moved it).

Next, please describe what you...

I pinged a few language people to see if they knew, but no response.

I can't find a difference either. They should be the same, and could be, but I think...

Not too many people back up directly to tape and I'd recommend you not do this. Send it to disk and then copy to tape if need be. too many...

I believe Enterprise is limited to servers

http://www.microsoft.com/sql/editions/enterprise/sysreqs.mspx

Call Quest or IBM. It could be hardware. Are other backups working fine? Could be network throughput as well.

I like your order and sorry for not getting in on this earlier. Saw Pauls' name in the post list and figured he'd covered things 🙂

Definitely figure out the backup...

How are you writing the join?

AFAIK, the servers must be linked somehow. You cannot create a join on your workstation that connects to two servers and does a join....

Post moved to a more appropriate forum.

Sorry, not sure what the answer is, but hopefully someone will chime in.

Try this: http://support.microsoft.com/kb/307487

Only if the client sends it in. the hostname is usually in sysprocesses (sp_who2) when the person connects, but I'm not aware of a way to audit this from SQL.

What...

I'll add that to the list. I don't track a source there, but maybe the programmers can add in a "domain" item.

You can also check the website and that has...

Very nice, Phil!!!!

We'll see if we can get this added and we're working on the double/triple spacing.

John,

We use Hamachi at End to End training to connect remotely. I admit that I was a little worried about security with that project, but it's worked well and no...