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 |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2010-05-10 : 16:15:35
|
| teamI have an old sql 2000 server which has to be migrated to sql 2005.Currently I have a job that runs xp_sendmailxp_sendmail @recipients = 'xyz@yahoo.com', @subject='MyFile',@query='select * from....',@ansi_Attachment='TRUE',@Width=8000,@attach_results='TRUE',@separator=',',@attachments='myfile.csv'This job requires outlook installed on the server.Not sure how woould I go about doing this without installing outlook on the new server?Any help/ideas welcome.RegardsParesh MotiwalaBoston, USA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
xp_sendmail substitute