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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-08 : 07:28:14
|
| sakku writes "Hi,I have two queries to be answered::Query 1:I need to send Emails through a procedure with SQLServer 2000. The Emails "From Address" needs to be selected depending upon different conditions. I have microsoft outlook configured for a particular profile. Please tell how do we do this. I have tried creating alias for a particular profile and then send the mails. But the receiver still sees the same "From Address" instead of the alias. If its possible through SMTP (which i suppose SQL Server 2000 does work with) then an example for the same will be useful.Query 2:This is in no way related to the first query. I want to see the "DBTEXTSIZE" and "DBTEXTLIMIT" values before changing them to the required. How can i get these values.Thanking you in anticipation,Regards,sakku" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-08 : 12:21:36
|
| You mentioned Outlook was configured, but is SQL Mail configured? SQL Mail can handle your first question easily. Tara |
 |
|
|
|
|
|
Sending Emails