Second Case - Ahaha, finally I see a neat example of how to use CASE. Always meant to look into it but never did. Thanks for that.

First Case - The...

Hello Frank,

sorry but the link does not seem to be working. Is it still live on the MS site?

Mauro

Just to add a small note with regards to ADO.NET.

I am retrieving two binary fields into a dataset by using a stored procedure - so there is no inline ADO.NET...

Thanks for that SP fhanlon.

Being devil's advocate, the only thing I would say is: "What if a job has failed because for some reason the SMTP server is down. In...

Thanks everyone. I think we will stick with xp_smtp for the moment, given that the e-mails will be triggered from scheduled jobs.

An alternative I thought of for notifying failures...

Sorry folks, one more thing.

Is there any chance that I can use this extended stored procedure for notifying scheduled job failures?

Thanks

Hi,

if you're going to use ADO.NET, check out the following:

HOW TO: Read and Write a File to and from a BLOB Column by Using ADO.NET and Visual Basic .NET -...