As suggested, talk to your network admin. They can help you determine why the copy takes so long.

The overhead depends on what you trace. Are you getting just login/logoff? Almost no overhead. If you want SQL statements, just get completed and the overhead depends on the load...

The article is incorrect and has been changed.

DAC is in Express with a trace flag.

MSDB works, but it's not reliable for reasons mentioned above (needs to be same server, can be purged, etc)

What are you trying to achieve?

Shaun,

Not to put you off, but this appears to be similar to an exam or homework question. If you show some work, we'd be happy to help.

Here's the basic idea:

you...

I'd suggest using the data export wizard, saving the package, and then adding the email task.

If you are in full mode, and you should be if this data matter, you need to be running regular log backups in addition to full (data) backups.

You should find...

no way to go back and do it. You have to be tracking this ahead of time.

Also, please post in the right version forum. Moved to SQL 2K forum.

xp_smtp?

Why not Outlook?

Without testing, the code looks ok and you're in the write approach. Have you tried doing this in VBScript first to check your object code?

Couldn't I go with bald-Ballmer look? I'm getting there on my own already.

Course I'm in a little better shape, maybe I'm the tan Ozzie/Ballmer morph! 😉

Please don't cross post.

Answered here: http://www.sqlservercentral.com/Forums/Topic495042-357-1.aspx

Are you manually copying? Check your network bandwidth, perhaps dedicate some ports to this task or a separate network on a switch.

Microsoft didn't really lose, it's that Oracle and DB2 grew at a faster rate, but SQL Server didn't. It was still growing, but few at 18.3% instead of 18.4 from...

That is not a compilation error. It's a run-time error when a conversion occurs. There are very few compilation errors, mostly syntax issues.

I put it as 3 because I think implicit conversions cause a lot of issues, waste time, and I see a lot of questions on these. So it's important.

I may...