Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
webfort
Starting Member
9 Posts |
 Posted - 2006-06-23 : 10:54:42
|
| Hi, I was wondering if anyone could help, is ist possible to export data from sql server and send it automatically via email?Any help would be much appreciated.Thanks |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2006-06-26 : 14:56:52
|
| I think this is possible via xp_sendmail. See the syntax on SQL books online. xp_sendmail {[@recipients =] 'recipients [;...n]'} [,[@message =] 'message'] [,[@query =] 'query'] [,[@attachments =] 'attachments [;...n]'] ......First export to a text file, zip/unzip the file and send a mail. Other approach is via DTS wizard.With RegardsBSR |
 |
|
|
|
|
|
Export data and send automatically via email