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 kn
ow?
Thanks for your help!
TomIf 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, s
o the last step will be to get it emailed with sendmail.
Thanks again!
Tom
-- 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 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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment