Changing the FROM in the email on a subscription

I need to change the email address that appears as the FROM email on reports
that are being delivered via RS2000. I have change the REPLY email and that
is working correctly but I can't seem to find where the FROM email is stored.
Thanks...It is configurable in the rsreportserver.config file on the report
server machine; edit that file and look for the <FROM> tag under the
<RSEmailDPConfiguration> section
Matt A
Steve wrote:
> I need to change the email address that appears as the FROM email on reports
> that are being delivered via RS2000. I have change the REPLY email and that
> is working correctly but I can't seem to find where the FROM email is stored.
> Thanks...|||That did it! Thanks Matt!!!
"Matt" wrote:
> It is configurable in the rsreportserver.config file on the report
> server machine; edit that file and look for the <FROM> tag under the
> <RSEmailDPConfiguration> section
> Matt A
>
> Steve wrote:
> > I need to change the email address that appears as the FROM email on reports
> > that are being delivered via RS2000. I have change the REPLY email and that
> > is working correctly but I can't seem to find where the FROM email is stored.
> > Thanks...
>|||what if I want to have a diffrent from address for each send?
same as you bind the To and the CC? can it be done?
"Steve" wrote:
> That did it! Thanks Matt!!!
> "Matt" wrote:
> > It is configurable in the rsreportserver.config file on the report
> > server machine; edit that file and look for the <FROM> tag under the
> > <RSEmailDPConfiguration> section
> >
> > Matt A
> >
> >
> > Steve wrote:
> > > I need to change the email address that appears as the FROM email on reports
> > > that are being delivered via RS2000. I have change the REPLY email and that
> > > is working correctly but I can't seem to find where the FROM email is stored.
> > > Thanks...
> >
> >

changing subscription email address in RS2000

Is there a way I can change the email address associated to sending timed
reports notifications to users?
Currently it is under my email address and I would like it to change to a
different email address.
TIA,
JacksonNevermind figured it out.
You need to edit the RSReportServer.config file. I had to do a find of the
email address I wanted to replace.
Jackson
"Jackson" <jackson_num5@.yahoo.com> wrote in message
news:umjwsLDCHHA.3924@.TK2MSFTNGP02.phx.gbl...
> Is there a way I can change the email address associated to sending timed
> reports notifications to users?
> Currently it is under my email address and I would like it to change to a
> different email address.
> TIA,
> Jackson
>
>

changing loop

hi,

i have a table #emails containing one coloumn called email. this is a list the contains emails.

i need to run a query that creats emails list like the following:

a@.xxx.com;b@.yyy.com, etc'

I am using the following code:

while exists(select 1 from #emails)
begin
select top 1 @.email=email
from #emails

set @.emails = @.emails + @.email + ';'

delete from #emails
where email=@.email

end

the thing is that when I create this list I get a high CPU usage.

Can someone help by suggesting a different way of creating this list and by that acheiving 'normal' CPU usage?

thx,

tomer

possible alternatives

--SQL SERVER 2005
DECLARE @.str varchar(4000)
SET @.str = (SELECT d.name + ','
FROM HumanResources.Department d
ORDER BY d.name
FOR XML PATH(''))
SET @.str = SUBSTRING(@.str,1,LEN(@.str)-1)
SELECT @.str

--SQL SERVER 2000
DECLARE @.name varchar(50)
DECLARE @.str varchar(4000)
SET @.str = ''
DECLARE Build CURSOR
LOCAL
FORWARD_ONLY
FOR
SELECT d.name
FROM HumanResources.Department d
ORDER BY d.name
OPEN Build
FETCH NEXT FROM Build INTO @.name
WHILE @.@.FETCH_STATUS = 0
BEGIN
SET @.str = @.str + @.name + ','
FETCH NEXT FROM Build INTO @.name
END
CLOSE Build
DEALLOCATE Build
SET @.str = SUBSTRING(@.str,1,LEN(@.str)-1)
SELECT @.str

|||

...forgot this...eternity is a long time

DECLARE @.count int

SET @.count = (SELECT COUNT(*) FROM #emails)

while @.count > 0

begin

select top 1 @.email=email

from #emails

set @.emails = @.emails + @.email + ';'

delete from #emails

where email=@.email

SET @.count = @.count - 1

end

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:
>