Although I agree with Cozy, I have a larger question, why? What is it that you are trying to accomplish? If you are doing SQL backups you already...

I believe tools like DiskKeeper are a better solution to this. Also keep in mind that file fragmentation is only half the potential issue, you can easily have database...

I can several things potentially in play here..

1. The load of data can affect the locking of those tables, a lot depends on the options you have selected in the...

First though was:

sp_helptext

What it sounds like is you want to change the behavior of the GUI. I'm sorry, that is an even poorer plan than just changing system objects....

I can't remember why we did that with SQLCLR, there was something we couldn't do, or do easily with Database Mail. I'm still not sure if it was the...

tstapenhorst (2/18/2010)

---

Good question Elliott. We wanted to have one management server manage all the SQL backups from one central server. That management server only has SQL Sever Client...

Code to send mail for SSIS:

Dim _oSMTPClient As New SmtpClient("smtpmailhost.yourcompany.com")

...

While there may be a way to do it, there is no good reason to do so, as has been stated several times. As well as the fact that...

Can I ask a different question.. Why aren't you using maintenance plans?

CEWII

I often catch the output that gets dropped into a log file.. But you are absoutely right, picking out data from that is a huge hassle since it is meant...

AVB (2/18/2010)

---

Package logging eh? Cool....

Like I said I'm currently dumping the record set from xp_CmdShell into a table so I can output and store the results but hopefully...

I don't have a resolution for your immediate problem but I have a suggestion for the future. You might execute the process more often to generate smaller dumps which...

I wasn't debating it, I was only expounding on your...

Ok, when you are ready. Let us know.

CEWII

I'm going with Greg on this, look at package logging.. The only downside is you have to read the tables directly since SSMS in SQL 2005/2008 don't have a...