Does SQLMail require a mail account on the Exchange Server?

I just read that if you use an exchange server...the account that you
start SQL with needs a mail on the exchange box.

Is this true?

I know I didn't need an account when I've set it up before...but I
might have been using a POP3 server.

I have Outlook 2003 installed on the server. Windows 2003 Enterprise.

Thanks.Hi

If you are using SQL Mail you will need a MAPI profile, and if you are
connectng to an exchange server you will need an account on that server. You
could connect to a POP3 server or alternatively you could check out
http://www.sqldev.net/xp/xpsmtp.htm.

For more information check out
http://msdn.microsoft.com/library/d...erverE-mail.asp
http://support.microsoft.com/kb/281293
http://support.microsoft.com/kb/263556/
You may want to use an older version of Outlook, if you are POP3.

John

<mchi55@.yahoo.comwrote in message
news:1157150726.360290.48890@.i42g2000cwa.googlegro ups.com...

Quote:

Originally Posted by

>I just read that if you use an exchange server...the account that you
start SQL with needs a mail on the exchange box.
>
Is this true?
>
I know I didn't need an account when I've set it up before...but I
might have been using a POP3 server.
>
I have Outlook 2003 installed on the server. Windows 2003 Enterprise.
>
Thanks.
>

sql

Does RS work with Lotus Notes?

I realise that RS has the ability to use any SMTP mail server, however, I am
looking for someone that has practical experience of Reporting Services
delivering subscription based reports via Lotus Notes.
Does this work and are there any issues I should be aware of?
Thanks,
Dave.it work fine for me
U¿ytkownik "Dave Roys" <daveroys@.xtra.co.nz> napisa³ w wiadomo¶ci
news:eKzgoVTZEHA.3692@.TK2MSFTNGP09.phx.gbl...
> I realise that RS has the ability to use any SMTP mail server, however, I
am
> looking for someone that has practical experience of Reporting Services
> delivering subscription based reports via Lotus Notes.
> Does this work and are there any issues I should be aware of?
> Thanks,
> Dave.
>
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.716 / Virus Database: 472 - Release Date: 2004-07-05|||We have had an issue with attachments coming out as zero length in some
cases of delivering to Notes. We are working on a fix for this.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"kamel" <kawa@.panda.bg.univ.gda.pl> wrote in message
news:%2350n0SUZEHA.2516@.TK2MSFTNGP10.phx.gbl...
> it work fine for me
> U¿ytkownik "Dave Roys" <daveroys@.xtra.co.nz> napisa³ w wiadomo¶ci
> news:eKzgoVTZEHA.3692@.TK2MSFTNGP09.phx.gbl...
>> I realise that RS has the ability to use any SMTP mail server, however, I
> am
>> looking for someone that has practical experience of Reporting Services
>> delivering subscription based reports via Lotus Notes.
>> Does this work and are there any issues I should be aware of?
>> Thanks,
>> Dave.
>>
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.716 / Virus Database: 472 - Release Date: 2004-07-05
>|||Please nofity me if exists other way to deliver subscriptions.
Thanks.
"Brian Welcker [MSFT]" wrote:
> We have had an issue with attachments coming out as zero length in some
> cases of delivering to Notes. We are working on a fix for this.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "kamel" <kawa@.panda.bg.univ.gda.pl> wrote in message
> news:%2350n0SUZEHA.2516@.TK2MSFTNGP10.phx.gbl...
> > it work fine for me
> >
> > U¿ytkownik "Dave Roys" <daveroys@.xtra.co.nz> napisa³ w wiadomo¶ci
> > news:eKzgoVTZEHA.3692@.TK2MSFTNGP09.phx.gbl...
> >> I realise that RS has the ability to use any SMTP mail server, however, I
> > am
> >> looking for someone that has practical experience of Reporting Services
> >> delivering subscription based reports via Lotus Notes.
> >>
> >> Does this work and are there any issues I should be aware of?
> >>
> >> Thanks,
> >>
> >> Dave.|||We are a lotus notes shop but we also maintain a SMTP server. RS can install
such that you can send a mail to a SMTP server without having to have Lotus
client (or Outlook etc). I use this and it works fine.
Bruce L-C
"Carlos E. Mosquera" <CarlosEMosquera@.discussions.microsoft.com> wrote in
message news:28B768DB-F709-406A-9E35-236025238EDA@.microsoft.com...
> Please nofity me if exists other way to deliver subscriptions.
> Thanks.
> "Brian Welcker [MSFT]" wrote:
> > We have had an issue with attachments coming out as zero length in some
> > cases of delivering to Notes. We are working on a fix for this.
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> > "kamel" <kawa@.panda.bg.univ.gda.pl> wrote in message
> > news:%2350n0SUZEHA.2516@.TK2MSFTNGP10.phx.gbl...
> > > it work fine for me
> > >
> > > U¿ytkownik "Dave Roys" <daveroys@.xtra.co.nz> napisa³ w wiadomo¶ci
> > > news:eKzgoVTZEHA.3692@.TK2MSFTNGP09.phx.gbl...
> > >> I realise that RS has the ability to use any SMTP mail server,
however, I
> > > am
> > >> looking for someone that has practical experience of Reporting
Services
> > >> delivering subscription based reports via Lotus Notes.
> > >>
> > >> Does this work and are there any issues I should be aware of?
> > >>
> > >> Thanks,
> > >>
> > >> Dave.

Does Reporting Services work with Novell Groupwise?

Can anyone please confirm how well e-mail delivered subscriptions of
reports work using Novell Groupwise as the mail solution?
There is a post in this forum that suggests Novell Groupwise suffers
from the same corruption of PDF and Excel attached reports as Lotus
Notes.We've run it with V6.5 GroupWise using PDF attachments without any problems
so far.
Julian
"Uncle Earnie" <david.roys@.nz.ey.com> wrote in message
news:5eeae37a.0409202028.750f4df9@.posting.google.com...
> Can anyone please confirm how well e-mail delivered subscriptions of
> reports work using Novell Groupwise as the mail solution?
> There is a post in this forum that suggests Novell Groupwise suffers
> from the same corruption of PDF and Excel attached reports as Lotus
> Notes.sql

Does Query plans change on static tables

I have attached two query plans , which are generated by Production server
at different times (1 day apart). ( i could not send mail with attached
plans I had to remove them)
Same query I have executed every day over two weeks time to see how the
query is performing in prod. server. I got two different plans. I didnt
understand how come the plan is changing so drastic when there are not many
data updates on the tables referred in the query. These tables are very
static and i am running dbcc reindex every night on these tables. Plan 1 has
index scan which is taking long time to execute (11 Sec), Plan 2 has no
index scan and so it is executing fast (<200ms). I didnt get a clue why it
is going for index scan some time and no index scan other times. I hope some
one will have answer for it.
Windows 2000 Server/SQL Server 2000 Standard SP4, 2 cpu, 1GB RAM, RAID 1
Disk
Thanks,
Subbu.
underprocessable|||underprocessable|||Statistics can influence the plan choice. Not all stats are tied to
indexes. So, you likely will want to make sure that all statistics are
up-to-date before making any conclusions. (update statistics <tablename>)
If you are close to a boundary between two plan choices, small changes can
push you from one plan to another on a recompile.
Hope that helps,
Conor
"subbu" <subbaiahd@.hotmail.com> wrote in message
news:%23wq2y6NWGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Plan 1: No index SCAN
> Plan 2: Index SCAN
> I had to send in two separate mail as it crossed max limit size
> Thanks,
> Subbu.
> "subbu" <subbaiahd@.hotmail.com> wrote in message
> news:%238V3L3NWGHA.4212@.TK2MSFTNGP03.phx.gbl...
> many
> has
> it
> some
>
>

Does Query plans change on static tables

I have attached two query plans , which are generated by Production server
at different times (1 day apart). ( i could not send mail with attached
plans I had to remove them)
Same query I have executed every day over two weeks time to see how the
query is performing in prod. server. I got two different plans. I didnt
understand how come the plan is changing so drastic when there are not many
data updates on the tables referred in the query. These tables are very
static and i am running dbcc reindex every night on these tables. Plan 1 has
index scan which is taking long time to execute (11 Sec), Plan 2 has no
index scan and so it is executing fast (<200ms). I didnt get a clue why it
is going for index scan some time and no index scan other times. I hope some
one will have answer for it.
Windows 2000 Server/SQL Server 2000 Standard SP4, 2 cpu, 1GB RAM, RAID 1
Disk
Thanks,
Subbu.underprocessable|||underprocessable|||Statistics can influence the plan choice. Not all stats are tied to
indexes. So, you likely will want to make sure that all statistics are
up-to-date before making any conclusions. (update statistics <tablename> )
If you are close to a boundary between two plan choices, small changes can
push you from one plan to another on a recompile.
Hope that helps,
Conor
"subbu" <subbaiahd@.hotmail.com> wrote in message
news:%23wq2y6NWGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Plan 1: No index SCAN
> Plan 2: Index SCAN
> I had to send in two separate mail as it crossed max limit size
> Thanks,
> Subbu.
> "subbu" <subbaiahd@.hotmail.com> wrote in message
> news:%238V3L3NWGHA.4212@.TK2MSFTNGP03.phx.gbl...
> many
> has
> it
> some
>
>

Does Query plans change on static tables

I have attached two query plans , which are generated by Production server
at different times (1 day apart). ( i could not send mail with attached
plans I had to remove them)
Same query I have executed every day over two weeks time to see how the
query is performing in prod. server. I got two different plans. I didnt
understand how come the plan is changing so drastic when there are not many
data updates on the tables referred in the query. These tables are very
static and i am running dbcc reindex every night on these tables. Plan 1 has
index scan which is taking long time to execute (11 Sec), Plan 2 has no
index scan and so it is executing fast (<200ms). I didnt get a clue why it
is going for index scan some time and no index scan other times. I hope some
one will have answer for it.
Windows 2000 Server/SQL Server 2000 Standard SP4, 2 cpu, 1GB RAM, RAID 1
Disk
Thanks,
Subbu.Statistics can influence the plan choice. Not all stats are tied to
indexes. So, you likely will want to make sure that all statistics are
up-to-date before making any conclusions. (update statistics <tablename>)
If you are close to a boundary between two plan choices, small changes can
push you from one plan to another on a recompile.
Hope that helps,
Conor
"subbu" <subbaiahd@.hotmail.com> wrote in message
news:%23wq2y6NWGHA.1192@.TK2MSFTNGP03.phx.gbl...
> Plan 1: No index SCAN
> Plan 2: Index SCAN
> I had to send in two separate mail as it crossed max limit size
> Thanks,
> Subbu.
> "subbu" <subbaiahd@.hotmail.com> wrote in message
> news:%238V3L3NWGHA.4212@.TK2MSFTNGP03.phx.gbl...
>> I have attached two query plans , which are generated by Production
>> server
>> at different times (1 day apart). ( i could not send mail with attached
>> plans I had to remove them)
>> Same query I have executed every day over two weeks time to see how the
>> query is performing in prod. server. I got two different plans. I didnt
>> understand how come the plan is changing so drastic when there are not
> many
>> data updates on the tables referred in the query. These tables are very
>> static and i am running dbcc reindex every night on these tables. Plan 1
> has
>> index scan which is taking long time to execute (11 Sec), Plan 2 has no
>> index scan and so it is executing fast (<200ms). I didnt get a clue why
> it
>> is going for index scan some time and no index scan other times. I hope
> some
>> one will have answer for it.
>>
>> Windows 2000 Server/SQL Server 2000 Standard SP4, 2 cpu, 1GB RAM, RAID 1
>> Disk
>>
>> Thanks,
>> Subbu.
>>
>>
>>
>
>

Does exchangeServer accept in SendMail task?

Does exchangeServer accept in SendMail task?

only SMTP?

who knows?

For internal mail server , it's only via exchange server.

Exchange supports SMTP.