Changing display-name in Database Mail

In our SQL Server 2005, VB.NET application, we want to send email to
outside clients, and have the email look like it came from the user who
sent it, meaning the Display Name and if possible, Email Address were
related to the person logged into our app.
>From my reading, it seems like we'd have to create a Database Mail
profile for each user. Is it instead possible to modify the Display
Name that sp_send_dbmail uses?
Thanks for any help.
I appreciate the response, but that's for older versions of SQL Server
as is way overkill for what I'm trying to achieve.
Tibor Karaszi wrote:
> You might want to check out xp_smtp_sendmail from www.sqldev.net instead.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>

Changing display-name in Database Mail

In our SQL Server 2005, VB.NET application, we want to send email to
outside clients, and have the email look like it came from the user who
sent it, meaning the Display Name and if possible, Email Address were
related to the person logged into our app.
>From my reading, it seems like we'd have to create a Database Mail
profile for each user. Is it instead possible to modify the Display
Name that sp_send_dbmail uses?
Thanks for any help.You might want to check out xp_smtp_sendmail from www.sqldev.net instead.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<petecuce@.gmail.com> wrote in message news:1165017764.318000.233460@.73g2000cwn.googlegroups.com...
> In our SQL Server 2005, VB.NET application, we want to send email to
> outside clients, and have the email look like it came from the user who
> sent it, meaning the Display Name and if possible, Email Address were
> related to the person logged into our app.
>>From my reading, it seems like we'd have to create a Database Mail
> profile for each user. Is it instead possible to modify the Display
> Name that sp_send_dbmail uses?
> Thanks for any help.
>|||I appreciate the response, but that's for older versions of SQL Server
as is way overkill for what I'm trying to achieve.
Tibor Karaszi wrote:
> You might want to check out xp_smtp_sendmail from www.sqldev.net instead.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>|||I see. AFAIK, the only place for Database Mail where you can set a display name is in the profile.
Consider posting a request at http://connect.microsoft.com/site/sitehome.aspx?SiteID=68.
I'm fairly certain that xp_smtp will work on 2005, even though I haven't tried it myself (I've seen
comments on using it on 2005 a few times). But the fact that 2005 isn't mentioned on the web site
might be enough to deter you from using it, of course. I'm not sure what you mean by overkill,
though. IMO, xp_smtp is the easiest way to use SMTP to send email - an extended proc that does the
SMTP sockets communication. No configuration, only download the dll, and run sp_addextendedproc. But
you won't get the queuing, of course.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<petecuce@.gmail.com> wrote in message news:1165242880.037495.215810@.80g2000cwy.googlegroups.com...
>I appreciate the response, but that's for older versions of SQL Server
> as is way overkill for what I'm trying to achieve.
>
> Tibor Karaszi wrote:
>> You might want to check out xp_smtp_sendmail from www.sqldev.net instead.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>

Changing display-name in Database Mail

In our SQL Server 2005, VB.NET application, we want to send email to
outside clients, and have the email look like it came from the user who
sent it, meaning the Display Name and if possible, Email Address were
related to the person logged into our app.
>From my reading, it seems like we'd have to create a Database Mail
profile for each user. Is it instead possible to modify the Display
Name that sp_send_dbmail uses?
Thanks for any help.You might want to check out xp_smtp_sendmail from www.sqldev.net instead.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<petecuce@.gmail.com> wrote in message news:1165017764.318000.233460@.73g2000cwn.googlegroups.
com...
> In our SQL Server 2005, VB.NET application, we want to send email to
> outside clients, and have the email look like it came from the user who
> sent it, meaning the Display Name and if possible, Email Address were
> related to the person logged into our app.
> profile for each user. Is it instead possible to modify the Display
> Name that sp_send_dbmail uses?
> Thanks for any help.
>|||I appreciate the response, but that's for older versions of SQL Server
as is way overkill for what I'm trying to achieve.
Tibor Karaszi wrote:
> You might want to check out xp_smtp_sendmail from www.sqldev.net instead.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>|||I see. AFAIK, the only place for Database Mail where you can set a display n
ame is in the profile.
Consider posting a request at http://connect.microsoft.com/site/s...e
ID=68.
I'm fairly certain that xp_smtp will work on 2005, even though I haven't tri
ed it myself (I've seen
comments on using it on 2005 a few times). But the fact that 2005 isn't ment
ioned on the web site
might be enough to deter you from using it, of course. I'm not sure what you
mean by overkill,
though. IMO, xp_smtp is the easiest way to use SMTP to send email - an exten
ded proc that does the
SMTP sockets communication. No configuration, only download the dll, and run
sp_addextendedproc. But
you won't get the queuing, of course.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<petecuce@.gmail.com> wrote in message news:1165242880.037495.215810@.80g2000cwy.googlegroups.
com...
>I appreciate the response, but that's for older versions of SQL Server
> as is way overkill for what I'm trying to achieve.
>
> Tibor Karaszi wrote:
>

Changing Database Mail Host Database

Hi

I am trying to change the host database (MSDB) of Database Mail to some new database (say NewDB) and

unable to make DatabaseMail90.exe point to this new database (NewDB).

Is it possible to do this?

Thanks

Uddemarri

When I passed the database name and server name as command line parameters to DatabaseMail90.exe , it picked messages from the queue but did not send any mail. The following error is logged in sysmail_event_log.

1) Exception Information =================== Exception Type: System.NullReferenceException Message: Object reference not set to an instance of an object. Data: System.Collections.ListDictionaryInternal TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32) HelpLink: NULL Source: DatabaseMailEngine StackTrace Information =================== at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID) at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.SessionManager.GetAccount(Int32 accountID) at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession) at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession) at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db) at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)

Any ideas?

|||That's definitely not a supported or tested option. I don't think you can start the mail service yourself.|||Thanks Roger.