I've found Excel only causes a few minor issues and as long as you know how to work around them, it's not that big of a deal.

It's figuring out the...

Different viewpoints are good. Even moreso when the documentation proves wrong. @=)

I actually have had errors in the past on this. Even posted a request for help on this forum about it at some point, but no one was able to...

If they find your body stuff into a Microsoft Office box, they'll know I was the guilty party...

@THWACK!

😛

Okay, how many different backup jobs (and what types) do you have going on with the failing database?

Jeff Moden (9/20/2010)

---

The second most important part of optimizing is to know how long [font="Arial Black"]each part [/font]took using the old way and how long it takes using the new...

Scope change

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)

---

@sqlbuddy123

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...