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 Administration (2000)
 SQL Server Sending Mails from Stored Procedures

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-05-20 : 08:22:28
A Srinivasa Rao writes "how can we send a simple mail from Stored Procedure. Can you give an example Please....?"

SamC
White Water Yakist

3467 Posts

Posted - 2003-05-20 : 08:26:00
For me the answer depends on the quantity. There are two techniques described in papers at SQLTEAM . Visit the home page, enter email in the search box and scan the results.

Hits 2 and 3 describe the two techniques.

Sam

Go to Top of Page

Shastryv
Posting Yak Master

145 Posts

Posted - 2003-05-20 : 10:30:28
EXEC xp_sendmail @recipients = 'Email@email.com',
@query = 'Query you want to specify',
@subject = 'Subject you want',
@attach_results = 'TRUE', @width = 250

Go to Top of Page
   

- Advertisement -