Assume this scenario:
I have a simple two column text file, columns are "time" and "action". So the contents are something like
17:21:33 Database accessed
17:21:37 Query53 executed
I would like to send the contents of that text file as the email body (not as an attachment) via SQL Mail. What's the best way?
I can use BULK INSERT to pull the text file contents into a table and I am familiar with setting up the whole SQL Mail thing.
I am going to format the email as HTML so I don't simply want to do a
SELECT * FROM mytemptable
because the output doesn't look right (and in any case it all appears on one line for some reason).
Thanks in advance.