Have you tested the email without the attachment? Used DBMail manually in SSMS?

Is the Linked Server in the SSMS GUI? Check the security tab on it and let me know what the set up is.

Please post whether or not Rich's solution helps you out. It looks interesting.

Cath Trimble (9/21/2010)

Here's someone who's proved SQL Standard 32bit can use more than 4GB on a 32bit OS:...

I've never seen that work.

Every time I've set...

Then keep doing the tests one at a time until you find out which part of your method changed so much that it's taking 4 hours to do.

The error message complains about an OLE DB error. I didn't think Excel used OLE DB to connect. But you're getting the queries to run when you're sysadmin?

What's the security...

Do all the objects have to move?

If yes, then do the following in OFF hours:

1) Backup the database

2) Restore to the other drive with a slightly different name (MyDBDup)

3) Take...

For a moment, I thought our abused poster found another sock puppet. Given the font mistake and bad grammar...

http://www.sqlservercentral.com/Forums/Topic971846-357-1.aspx

If there's a SQL event there, I'm so a part...

What service pack are you using? SP1 (pre-hot fix) had issues with maintenance plans. If you're using it, you should upgrade to the latest service pack and see if that...

Paul White NZ (9/20/2010)

That's an awesome idea for next April 1.

He should also change all...

Okay, the best way to figure this out is to try Part A of both methods and time them. I'm betting this is where the problem is. Because you're creating...

Did it work before?

Have the permissions on the Share folder, where the file resides, changed?

He'll set us all to zero and make...