Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Moore Email Formatted HTML Table with T-SQL RE: Email Formatted HTML Table with T-SQL

  • June 20, 2013 at 12:55 am

    #1625722

    Jeff Moden (6/19/2013)

    I don't believe you'll find anyone more pro-xp_CmdShell or pro_BCP than myself but I can't figure out why you bothered with either for this task since sp_SendDBMail could have easily handled this task. And having to install a 3rd party piece of shareware on a server certainly doesn't make for a "T-SQL Only" project, IMHO.

    Why didn't you just use sp_SendDBMail which can take a 2GB VARCHAR(MAX) body with the custom HTML formatting from your article?

    Thanks for the feedback Jeff!

    Basically, I think you are right. I should have written the article with a more modern twist. The practical reason is that I wear many different hats so I end up using Blat for SysAdmin tasks, AD notifications, sending log files, etc. And I was using Blat with SQL Server 7.0. It is just an old habit that works so I haven't changed it.