Emailing a table

All that Iâ'm trying to do is nightly email a table. Whatâ's the easiest way to do this? It seems that SQLMail would be an overkill but I donâ't know
Thanks for your help
ToIf you could use SMTP, get hold of xp_smtp_sendmail from http://SQLDev.net.
This is an extended stored procedure for sending emails from SQL Server.
You just need a way of creating a text file with the table data. You could
use either BCP or DTS for this. Once the file is created, email it using
xp_smtp_sendmail.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"TomZ" <anonymous@.discussions.microsoft.com> wrote in message
news:47E94190-0DD5-470B-BA20-422F2D1C3D98@.microsoft.com...
All that I'm trying to do is nightly email a table. What's the easiest way
to do this? It seems that SQLMail would be an overkill but I don't know?
Thanks for your help!
Tom|||Thanks! I can get as far as getting the file creating using a job under SQL Server Agent that runs a query to return the table and create a txt file, so the last step will be to get it emailed with sendmail.
Thanks again
To
-- Narayana Vyas Kondreddi wrote: --
If you could use SMTP, get hold of xp_smtp_sendmail from http://SQLDev.net
This is an extended stored procedure for sending emails from SQL Server
You just need a way of creating a text file with the table data. You coul
use either BCP or DTS for this. Once the file is created, email it usin
xp_smtp_sendmail
-
HTH
Vyas, MVP (SQL Server
http://vyaskn.tripod.com
Is .NET important for a database professional
http://vyaskn.tripod.com/poll.ht
"TomZ" <anonymous@.discussions.microsoft.com> wrote in messag
news:47E94190-0DD5-470B-BA20-422F2D1C3D98@.microsoft.com..
All that I'm trying to do is nightly email a table. What's the easiest wa
to do this? It seems that SQLMail would be an overkill but I don't know
Thanks for your help
To