Just had to give in and get glasses at 42, but like other posters I think I'd have needed them at 42 whatever job I did. One comment I read...

You can set the job to send an alert when it fails. In Enterprise Manager expand Management then Operators. Right-click in the right hand window and select New Operator, then...

You need to create a Data Transformation Services Package. In Enterprise Manager open up the database you are exporting from and click on the toolbar icon with a wand and...

That's *so* much faster (and it was your suggestion in that thread I used). Thanks you very much

Same as P. Jones, with not even a hint of a "bah, humbug". I think in our neighbourhood you'd stand out a bit, Steve, and not in a good way....

I'd be wary about sending the message from within the trigger - if your mail goes down, the entire insert will fail. I keep a table with fields for recipient,...

They must be regretting this. At least I hope they are. http://www.redherring.com/Article.aspx?a=14575&hed=Texas+Sues+Sony+Over+Spyware&sector=Industries&subsector=SecurityAndDefense

And now Sony are recalling all the affected CDs http://news.zdnet.com/2100-1009_22-5954154.html

Good.

Add to that the fact that the DRM software may not be legal itself. http://dewinter.com/modules.php?name=News&file=article&sid=215

Are Sony telling us to do as they say, not do as they do?

That's my signature in the above post, not sheer hubris!

Hitler

Stalin

Lenin

Mao

Churchill

Bob Dylan

Gandhi

Nelson Mandela

John Logie Baird

Alexander Fleming

I'm a bit wary of embedding xp_sendmail in a trigger. If you have problems with your mail system which raise an error in the trigger, it will cause your inserts/updates...

If you can justify the time you could amend each of the sprocs to append a line to a logging table - sproc name, getdate(), user.

I've found you need to delete and recreate the worksheet each time you do the export. Create an Execute SQL task bound to the connection to your Excel spreadsheet and...

Does your Excel file have more than one worksheet? If this is the case you can create a linked table to each worksheet and run append queries from each of...