I use blat.exe, which is a small public domain program, that will send an email for you. All it needs is access to a SMTP Server. See http://www.blat.net. But...

I have a calendar table, with one record for each day since way back and 15 years into the future.

Would it be fast if I joined my datetime field with...

Performance might be an issue, but this solution is great when security is an issue.  It is very easy to grant execution rights to a sproc, and then block the...

A simple approach:

backup database northwind to disk = 'c:\yourfile.bak'

but this ends up at c:\ at the server c:, not your own local disk, and, yes, you need db_backupoperator or db_owner rights.

Another option is http://www.sqldts.com/default.aspx?242

Works great, and it can be done by an InstallScript, if you need to deploy to many servers.

Darell,

Thank you. I had forgotten about the Export wizard.

Regards

Henrik

Yesterday, I went to a Microsoft seminar where Mogens Nørgaard were speaking about obtaining the best performance for a DB system. Key points were:

1) Always investigate on a job/session level....

Steve,

Thank you for covering this important part of a products lifespan. I would like to recommend that the demo data that the system is running, is as close as possible...