Please check the SQL error logs and the Windows event logs for messages as to why the agent stopped.

I hate reading mail in SQL Server, but that's for processing queries. You don't want anyone to submit queries through mail as it opens you up for security issues.

If you're...

You don't want to move SQL Server stuff off to a NAS. Maybe the third party processing, but not the SQL files.

You want more captive disk or SAN disk, and...

Found an explanation here:

http://blogs.msdn.com/michkap/archive/2007/10/10/5391882.aspx

You have to dig through a few posts, but basically the SQL team chose this collation to make things run a little quicker from when the setting...

Loner,

You are welcome to post about your job here. That's what this forum and the Employee/Employer forums are for.

Just understand that not everyone will agree with you and might...

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.