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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 sending query result through mail without using xp_sendmail

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-12-08 : 08:59:47
priya writes "how to send mail which contains the results of a query to any recepient as an attachment or message by using only send mail task (by using xp_sendmail in execute sql task the above is possible but i want a different approach)"

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2006-12-10 : 16:03:05
If you want to use DTS, you can write an ActiveX task that references the CDO libraries.

Why don't you want to use xp_sendmail??
Go to Top of Page
   

- Advertisement -