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 |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2009-05-22 : 01:18:13
|
| Hi,I'm running a SPROC that will send an email on a certain condition when it runs. As far as I understand only SA has permission to send emails.I'm wondering, is there a best way to set up something like this as far as permissions go ? Any thoughts much appreciated!Thanks again,mike123 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-22 : 02:38:04
|
Which email component do you use?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2009-05-22 : 02:52:43
|
| Hey Peso,I have never done this before but was hoping to send from SQL directly, do I need any special add ins ? Thanks again! :)mike123 |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-22 : 13:01:03
|
There is xp_sendmail (needs mapi client)and there is db_sendmail.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2009-05-24 : 10:28:03
|
| Use the database mail in SQL itself. You don't need to install anything. Just set it up and put the SMTP Server name in here.On SQL Agent you have to enable this |
|
|
|
|
|
|
sending database mail (permission question)