Email Subscription Problem

Regards,
When a non administrative person sets up an email subscription to a
particular report, the "to" field defaults to their login name rather than
their email address.
So for jsmith@.microsoft.com, the "to" field defaults to "jsmith" and is read
only so it can't be changed.
Once the subscription is made, the email goes to jsmith, which doesn't
resolve to anything causing a bounce-back.
Is there a setting to tell Reporting Services to use the AD email address
for users if available? Or is there a way to default the domain for missing
domains?
There has to be a setting in one of the config files.
Any help would be greatly appreciated!
Benjamin PierceIf all you need is to add host name to the email, there is a DefaultHostName
element in the RSReportServer config file. This will add the host name to
any email address that does not have one.
If you want all users to be able to edit the TO line set the
SendEmailToUserAlias element to false and then every user will have a blank
TO line that they can set.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Benjamin Pierce" <bpierce@.opentext.com> wrote in message
news:OmZZyvLTFHA.3264@.TK2MSFTNGP15.phx.gbl...
> Regards,
> When a non administrative person sets up an email subscription to a
> particular report, the "to" field defaults to their login name rather than
> their email address.
> So for jsmith@.microsoft.com, the "to" field defaults to "jsmith" and is
> read
> only so it can't be changed.
> Once the subscription is made, the email goes to jsmith, which doesn't
> resolve to anything causing a bounce-back.
> Is there a setting to tell Reporting Services to use the AD email address
> for users if available? Or is there a way to default the domain for
> missing
> domains?
> There has to be a setting in one of the config files.
> Any help would be greatly appreciated!
> Benjamin Pierce
>|||Thanks Daniel,
Adding a DefaultHostName worked like a charm. VERY MUCH APPRECIATED!
Benjamin Pierce
"Daniel Reib (MSFT)" <danreib@.online.microsoft.com> wrote in message
news:O9fs3QQTFHA.3188@.TK2MSFTNGP09.phx.gbl...
> If all you need is to add host name to the email, there is a
DefaultHostName
> element in the RSReportServer config file. This will add the host name to
> any email address that does not have one.
> If you want all users to be able to edit the TO line set the
> SendEmailToUserAlias element to false and then every user will have a
blank
> TO line that they can set.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Benjamin Pierce" <bpierce@.opentext.com> wrote in message
> news:OmZZyvLTFHA.3264@.TK2MSFTNGP15.phx.gbl...
> > Regards,
> >
> > When a non administrative person sets up an email subscription to a
> > particular report, the "to" field defaults to their login name rather
than
> > their email address.
> >
> > So for jsmith@.microsoft.com, the "to" field defaults to "jsmith" and is
> > read
> > only so it can't be changed.
> >
> > Once the subscription is made, the email goes to jsmith, which doesn't
> > resolve to anything causing a bounce-back.
> >
> > Is there a setting to tell Reporting Services to use the AD email
address
> > for users if available? Or is there a way to default the domain for
> > missing
> > domains?
> >
> > There has to be a setting in one of the config files.
> >
> > Any help would be greatly appreciated!
> >
> > Benjamin Pierce
> >
> >
>

Email on insert in a table

Hi,

I wish to use email functionality of sql to send me an email when an insert
is performed on a particular table. I know that a proc and may be a trigger
is required.

Can someone please provide me some hints.

Thanks,

GujuIt's not a good idea to send email from a trigger. Email is an
inherently asynchronous medium so there is really no need to hold open
a transaction while sending an email. Also, if the INSERT is performed
inside a transaction which later gets rolled back then the email will
have been sent for an INSERT that never actually happened.

Schedule a process that regularly checks for new rows and sends out
emails accordingly. For example you can use SQL Agent to call such a
process every minute if required.

More about emailing from SQL Server here:
http://www.aspfaq.com/show.asp?id=2403

--
David Portas
SQL Server MVP
--|||David,

What would the code look like in the proc?

Thanks,

"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1109034627.228291.203650@.c13g2000cwb.googlegr oups.com...
> It's not a good idea to send email from a trigger. Email is an
> inherently asynchronous medium so there is really no need to hold open
> a transaction while sending an email. Also, if the INSERT is performed
> inside a transaction which later gets rolled back then the email will
> have been sent for an INSERT that never actually happened.
> Schedule a process that regularly checks for new rows and sends out
> emails accordingly. For example you can use SQL Agent to call such a
> process every minute if required.
> More about emailing from SQL Server here:
> http://www.aspfaq.com/show.asp?id=2403
> --
> David Portas
> SQL Server MVP
> --|||To call xp_sendmail? See Books Online for examples and syntax - there
are too many different options to cover here. I recommend
xp_smtp_sendmail instead - I've found it much easier to set up and more
reliable than xp_sendmail. Both are covered by the links in the article
I posted before.

--
David Portas
SQL Server MVP
--

EM Deny Registration

How can one deny registration of a particular SQL Server
through Enterprise Manager and still be able to open a
query analyzer and access the target database of that
particular server (read only)? My problem is some users
had a green light from above to have an Enterprise
Manager installed on their server but yet have very
little experience navigating it. I am afraid if they
registered this particular server and accidentally open a
table (all rows). I can not deny them access completely
since they need to have read access from the database.Hi,
You cant restrict EM alone. If the user have access then they will be able
to register in EM.
Thanks
Hari
SQL Server MVP
"LD" <anonymous@.discussions.microsoft.com> wrote in message
news:082201c5406f$a7440ed0$a401280a@.phx.gbl...
> How can one deny registration of a particular SQL Server
> through Enterprise Manager and still be able to open a
> query analyzer and access the target database of that
> particular server (read only)? My problem is some users
> had a green light from above to have an Enterprise
> Manager installed on their server but yet have very
> little experience navigating it. I am afraid if they
> registered this particular server and accidentally open a
> table (all rows). I can not deny them access completely
> since they need to have read access from the database.
>|||LD
You can restict permissions to do any operations per database. Let me say if
the user has not permissions to operate with a database XXX ,so he will not
be able to get in vs EM.
"LD" <anonymous@.discussions.microsoft.com> wrote in message
news:082201c5406f$a7440ed0$a401280a@.phx.gbl...
> How can one deny registration of a particular SQL Server
> through Enterprise Manager and still be able to open a
> query analyzer and access the target database of that
> particular server (read only)? My problem is some users
> had a green light from above to have an Enterprise
> Manager installed on their server but yet have very
> little experience navigating it. I am afraid if they
> registered this particular server and accidentally open a
> table (all rows). I can not deny them access completely
> since they need to have read access from the database.
>