Colin,

Thanks for the reply. We're already in simple recovery mode. We may go with manual stats now.

Spindles - could be an issue, but I'm not dealing with hardware...

I have the book and agree that's its a winner. I keep it on my nightstand for a little "light" reading when I can't quite go down. I...

Server: Msg 7391, Level 16, State 1, Line 2 The operation could not be performed because the OLE DB provider 'MSDASQL' was unable to begin a distributed transaction. ...

sschwarze,

Funny thing is, I'm the one that originally posted the code for sp_sendSMTPMail on Swynk.com some years back. I believe pieces of it were snarfed from others, but I...

Brian,

Just curious whether Win32::OLE's "in" construct would work on the $recordset->ActiveConnection()->Errors() collection, or not since its not really a collection. For example, does this work?

foreach my $currentError (in $recordset->ActiveConnection()->Errors()->Item)...

Check out Bill Wunder's Source Safe utility on this site. It's great!

Oops, formatting killed my style above. Oh well.

I agree with most of the formatting comments, but my own style is slightly different. I like the following:

SELECT a.Column1,

...

Wow! Was this 2000 or 7.0? Does anybody know what "Integrity Checks" on the maint plans really runs?

quote:

---

I took over...

One thing you didn't mention was the ability to use Maintenance Plans in a Multi-server administration (MSX/TSX) environment.

I've tried to carefully create a Maint Plan that can be used on...