Sql Edition Selection: setup

Showing posts with label setup. Show all posts

Tuesday, March 27, 2012

Embedded Images ....

Hi...
How can I setup the reports so that they do not require the images to be
Embedded? Meaning, I want to pull a logo from the Images folder but it's not
letting me. I realize that I can hack the XML but when reviewing that it
appears as if the image doesn't exist just the name of the image.
Thanks!Can you provide me an example of the URL approach? I might be a little blind
but I'm not seeing it or an example in my book.
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:D9BB937B-4B6C-43E9-81EC-6BA962F61EE2@.microsoft.com...
> For your problem you can have two solutions provided by images control.
> 1. Web
> 2. project.
> In the first you can give a URL so that when ever the page gets loaded
> with
> results it pulls the image from the URL
> In the second, you can add an item of image in the project itself so that
> can be refered in the layout image control.
> I think 2nd option is best.
> Amarnath
> "Chris Marsh" wrote:
>> Hi...
>> How can I setup the reports so that they do not require the images to be
>> Embedded? Meaning, I want to pull a logo from the Images folder but it's
>> not
>> letting me. I realize that I can hack the XML but when reviewing that it
>> appears as if the image doesn't exist just the name of the image.
>> Thanks!
>>|||Actually, I have found it...thank you again.
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:es3lRNoOHHA.404@.TK2MSFTNGP02.phx.gbl...
> Can you provide me an example of the URL approach? I might be a little
> blind but I'm not seeing it or an example in my book.
>
> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> news:D9BB937B-4B6C-43E9-81EC-6BA962F61EE2@.microsoft.com...
>> For your problem you can have two solutions provided by images control.
>> 1. Web
>> 2. project.
>> In the first you can give a URL so that when ever the page gets loaded
>> with
>> results it pulls the image from the URL
>> In the second, you can add an item of image in the project itself so that
>> can be refered in the layout image control.
>> I think 2nd option is best.
>> Amarnath
>> "Chris Marsh" wrote:
>> Hi...
>> How can I setup the reports so that they do not require the images to be
>> Embedded? Meaning, I want to pull a logo from the Images folder but it's
>> not
>> letting me. I realize that I can hack the XML but when reviewing that it
>> appears as if the image doesn't exist just the name of the image.
>> Thanks!
>>
>

Monday, March 26, 2012

Emailing Errors

I'm sort of new to SSIS so I apologize if this is a trivial question:

I setup a package and want it to email me if there is any errors. Right now I got it working to send me a pre-written message about the failure, but I want to load the full task failure message into variable and email it on the email body.

But so far I have not found a way to save the error messages into variables so I can email them. Anyone can help with that one?

As far as I know there is no one system variable that stores the error message. So, you may not be able to use expressions with variables.

Also, keep in mind that you could get multiple errors per package. So, a single variable won't do the job.

An error report is what you basically need.

Assuming you are setting the "OnError" event handler, the error message, container name, etc. are logged in the sysdtslog90 table. You can query the table using the execution guid, which is available as a system variable to the package.

You can then dump the result set into an excel or a text file and email it as an attachment.

|||

How did you set up even a pre-written mail message for errors?

Right now, I have an error log and a success mail message if everything else completes, but an error mail would be awesome.

|||

sorry. i figured it out. i am new to ssis (3 months) and just noticed the event handler tab. please try to control your laughter.

|||

Under email task editor- build an Expression for "Message source"

you could then do something like:

" There was a critical error in the Your Load. Error Msg follows " + @.[System::ErrorDescription]

to bubble up the error message.

sql

Emailing Errors

I'm sort of new to SSIS so I apologize if this is a trivial question:

But so far I have not found a way to save the error messages into variables so I can email them. Anyone can help with that one?

As far as I know there is no one system variable that stores the error message. So, you may not be able to use expressions with variables.

Also, keep in mind that you could get multiple errors per package. So, a single variable won't do the job.

An error report is what you basically need.

You can then dump the result set into an excel or a text file and email it as an attachment.

|||

How did you set up even a pre-written mail message for errors?

Right now, I have an error log and a success mail message if everything else completes, but an error mail would be awesome.

|||

sorry. i figured it out. i am new to ssis (3 months) and just noticed the event handler tab. please try to control your laughter.

|||

Under email task editor- build an Expression for "Message source"

you could then do something like:

" There was a critical error in the Your Load. Error Msg follows " + @.[System::ErrorDescription]

to bubble up the error message.

Email with attachments.

I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.

Each time the subscription runs I am getting this error below:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?

Please let me know. Thanks

Ken, any luck with this problem?

I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:

Logon Failure:

Reason: An error occurred during logon

User Name:

Domain:

Logon Type: 3

Logon Process: Authz

Authentication Package: Kerberos

Workstation Name: NZRPTAUC01

Status code: 0x8009030E

Substatus code: 0x0

Caller User Name: LOCAL SERVICE

Caller Domain: NT AUTHORITY

Caller Logon ID: (0x0,0x3E5)

Caller Process ID: 1740

Transited Services: -

Source Network Address: -

Source Port: -

|||

I am having same issue.. have you solved the problem?|||

Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.

1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.

2. Double click the service and go to the Log On properties tab to determine the service account.

3. Set permissions on your smtp server to allow the service account to send email.

Email with attachments.

I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.

Each time the subscription runs I am getting this error below:

Please let me know. Thanks

Ken, any luck with this problem?

Logon Failure:

Reason: An error occurred during logon

User Name:

Domain:

Logon Type: 3

Logon Process: Authz

Authentication Package: Kerberos

Workstation Name: NZRPTAUC01

Status code: 0x8009030E

Substatus code: 0x0

Caller User Name: LOCAL SERVICE

Caller Domain: NT AUTHORITY

Caller Logon ID: (0x0,0x3E5)

Caller Process ID: 1740

Transited Services: -

Source Network Address: -

Source Port: -

|||

I am having same issue.. have you solved the problem?|||

Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.

1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.

2. Double click the service and go to the Log On properties tab to determine the service account.

3. Set permissions on your smtp server to allow the service account to send email.

Email with attachments.

I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.

Each time the subscription runs I am getting this error below:

Please let me know. Thanks

Ken, any luck with this problem?

Logon Failure:

Reason: An error occurred during logon

User Name:

Domain:

Logon Type: 3

Logon Process: Authz

Authentication Package: Kerberos

Workstation Name: NZRPTAUC01

Status code: 0x8009030E

Substatus code: 0x0

Caller User Name: LOCAL SERVICE

Caller Domain: NT AUTHORITY

Caller Logon ID: (0x0,0x3E5)

Caller Process ID: 1740

Transited Services: -

Source Network Address: -

Source Port: -

|||

I am having same issue.. have you solved the problem?|||

Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.

1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.

2. Double click the service and go to the Log On properties tab to determine the service account.

3. Set permissions on your smtp server to allow the service account to send email.

Thursday, March 22, 2012

email trigger

Hello

Can you setup a trigger to mail some one when a record is updated in SQL server 2005?

If you can, can anyone help me?

Yes, you can call a extended procedure 'xp_sendmail' in an update trigger. The following article shows an example:

http://msdn.microsoft.com/library/en-us/architec/8_ar_da_1tup.asp?frame=true

sql

email trigger

I'd like to setup a trigger to send an email, but can't use SQLMail because
I don't control the password to the account that is running the MSSQLSERVER
service. Is there any other way to have SQL send an email when an insert is
made to a particular table? Plus IT doesn't like the idea of Outlook
installed on a production server.You could use xp_smtp_mail. It requires that the ability to access a smtp
mail server. Quite 'safe' for a production server -unlike MAPI.
Mail -Sending
SQL 2000 - http://www.sqldev.net/xp/xpsmtp.htm
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Colin" <legendsfan@.spamhotmail.com> wrote in message
news:%23IQu$hjxGHA.3892@.TK2MSFTNGP03.phx.gbl...
> I'd like to setup a trigger to send an email, but can't use SQLMail
> because I don't control the password to the account that is running the
> MSSQLSERVER service. Is there any other way to have SQL send an email
> when an insert is made to a particular table? Plus IT doesn't like the
> idea of Outlook installed on a production server.
>|||Hi Colin
It is not really advisable to send emails from triggers as you will
potentially be increasing the transaction time significantly and therefore
increasing contention (blocking/deadlocking etc..). An alternative would be
to populate another table and then periodically have a process that emails
the information and clears the table down.
John
"Colin" wrote:
> I'd like to setup a trigger to send an email, but can't use SQLMail because
> I don't control the password to the account that is running the MSSQLSERVER
> service. Is there any other way to have SQL send an email when an insert is
> made to a particular table? Plus IT doesn't like the idea of Outlook
> installed on a production server.
>
>

email trigger

I'd like to setup a trigger to send an email, but can't use SQLMail because
I don't control the password to the account that is running the MSSQLSERVER
service. Is there any other way to have SQL send an email when an insert is
made to a particular table? Plus IT doesn't like the idea of Outlook
installed on a production server.You could use xp_smtp_mail. It requires that the ability to access a smtp
mail server. Quite 'safe' for a production server -unlike MAPI.
Mail -Sending
SQL 2000 - http://www.sqldev.net/xp/xpsmtp.htm
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Colin" <legendsfan@.spamhotmail.com> wrote in message
news:%23IQu$hjxGHA.3892@.TK2MSFTNGP03.phx.gbl...
> I'd like to setup a trigger to send an email, but can't use SQLMail
> because I don't control the password to the account that is running the
> MSSQLSERVER service. Is there any other way to have SQL send an email
> when an insert is made to a particular table? Plus IT doesn't like the
> idea of Outlook installed on a production server.
>|||Hi Colin
It is not really advisable to send emails from triggers as you will
potentially be increasing the transaction time significantly and therefore
increasing contention (blocking/deadlocking etc..). An alternative would be
to populate another table and then periodically have a process that emails
the information and clears the table down.
John
"Colin" wrote:

> I'd like to setup a trigger to send an email, but can't use SQLMail becaus
e
> I don't control the password to the account that is running the MSSQLSERVE
R
> service. Is there any other way to have SQL send an email when an insert
is
> made to a particular table? Plus IT doesn't like the idea of Outlook
> installed on a production server.
>
>

Email through SQL

I am trying to setup my sql to send automatic emails to different companies but I am not doing so well. The user puts an email address in the database and then presses a button (command button) that will execute a stored procedure xp_sendmail to a recepient. I need to know how to include read receipts and delivery receipts into the stored procedure, because right now its set up in his outlook as a rule to do this and I want to set it up in sql. The user deals with companies and these companies have several contacts with several email addresses which sql will store in a seperate table.Hiya Des...I'm sure others more knowledgeable will soon come to your rescue, but I don't think there are that kind of specific email options in xp_sendmail. However, Though I use the xp_sendmail quite a bit, I am no expert (as my recent thread posting shows).

HOWEVER, that said, perhaps you could send a "regular" email to your user from SQL Server, then set up some rules in Outlook to massage the necessary options and forward the email on to the appropriate customers? I know that's kinda a round-about way to get there, but it seems to me that it would work if nobody comes up with a definitive answer from SQL Server...

Just a thought

Email subscriptions

Hello all,
I am trying to get some email subscriptions setup and I keep getting the
message "The e-mail address of one or more recipients is not valid". The
email address is valid and I am not sure what the problem is. If I set the
email address to a local account name (i.e Administrator) the subscription
works and e-mail shows up in the drop folder of the smtp server. Does anyone
know how I can get my subscriptions working to real email addresses and not
just local accounts? Any help would be appreciated.
Thanks,
JeffI have solved my own issue. All I needed to do was edit the SMTP server
settings to grant access to the server to relay through its own IP address.
Jeff
"Jeff McIntire" wrote:
> Hello all,
> I am trying to get some email subscriptions setup and I keep getting the
> message "The e-mail address of one or more recipients is not valid". The
> email address is valid and I am not sure what the problem is. If I set the
> email address to a local account name (i.e Administrator) the subscription
> works and e-mail shows up in the drop folder of the smtp server. Does anyone
> know how I can get my subscriptions working to real email addresses and not
> just local accounts? Any help would be appreciated.
> Thanks,
> Jeff|||How exactly did you do that? I have looked around for hours, you're the only
that has my exact same problem.
"Jeff McIntire" wrote:
> I have solved my own issue. All I needed to do was edit the SMTP server
> settings to grant access to the server to relay through its own IP address.
> Jeff
> "Jeff McIntire" wrote:
> > Hello all,
> >
> > I am trying to get some email subscriptions setup and I keep getting the
> > message "The e-mail address of one or more recipients is not valid". The
> > email address is valid and I am not sure what the problem is. If I set the
> > email address to a local account name (i.e Administrator) the subscription
> > works and e-mail shows up in the drop folder of the smtp server. Does anyone
> > know how I can get my subscriptions working to real email addresses and not
> > just local accounts? Any help would be appreciated.
> >
> > Thanks,
> >
> > Jeff|||All I did was go to the SMTP server properties and click on the access tab.
Then I clicked the relay button at the bottom of the page. Next I clicked on
add and inputted the IP address of my server. Then I clicked ok and made
sure the radio button labeled â'Only the list belowâ' was selected. That
solved my problem and I hope it solves yours as well.
Thanks,
Jeff
"DougM" wrote:
> How exactly did you do that? I have looked around for hours, you're the only
> that has my exact same problem.
> "Jeff McIntire" wrote:
> > I have solved my own issue. All I needed to do was edit the SMTP server
> > settings to grant access to the server to relay through its own IP address.
> >
> > Jeff
> >
> > "Jeff McIntire" wrote:
> >
> > > Hello all,
> > >
> > > I am trying to get some email subscriptions setup and I keep getting the
> > > message "The e-mail address of one or more recipients is not valid". The
> > > email address is valid and I am not sure what the problem is. If I set the
> > > email address to a local account name (i.e Administrator) the subscription
> > > works and e-mail shows up in the drop folder of the smtp server. Does anyone
> > > know how I can get my subscriptions working to real email addresses and not
> > > just local accounts? Any help would be appreciated.
> > >
> > > Thanks,
> > >
> > > Jeff|||Thanks, I tried re-installing Reporting Services to see if I could see that
screen but after choosing to modify components (as opposed to uninstall) it
went right through to finish...How did you get to the SMTP properties?. I
appreciate your help very much.
Regards,
DougM
"Jeff McIntire" wrote:
> All I did was go to the SMTP server properties and click on the access tab.
> Then I clicked the relay button at the bottom of the page. Next I clicked on
> add and inputted the IP address of my server. Then I clicked ok and made
> sure the radio button labeled â'Only the list belowâ' was selected. That
> solved my problem and I hope it solves yours as well.
> Thanks,
> Jeff
>
> "DougM" wrote:
> > How exactly did you do that? I have looked around for hours, you're the only
> > that has my exact same problem.
> >
> > "Jeff McIntire" wrote:
> >
> > > I have solved my own issue. All I needed to do was edit the SMTP server
> > > settings to grant access to the server to relay through its own IP address.
> > >
> > > Jeff
> > >
> > > "Jeff McIntire" wrote:
> > >
> > > > Hello all,
> > > >
> > > > I am trying to get some email subscriptions setup and I keep getting the
> > > > message "The e-mail address of one or more recipients is not valid". The
> > > > email address is valid and I am not sure what the problem is. If I set the
> > > > email address to a local account name (i.e Administrator) the subscription
> > > > works and e-mail shows up in the drop folder of the smtp server. Does anyone
> > > > know how I can get my subscriptions working to real email addresses and not
> > > > just local accounts? Any help would be appreciated.
> > > >
> > > > Thanks,
> > > >
> > > > Jeff|||I am sorry. Perhaps I should have clarified. The SMTP properties that I was
referring to were in the SMTP server in IIS itself. If you open up IIS and
navigate to the SMTP server and then right click on it and go to properties
you should find the screens that I was referring to.
Thanks,
Jeff
"DougM" wrote:
> Thanks, I tried re-installing Reporting Services to see if I could see that
> screen but after choosing to modify components (as opposed to uninstall) it
> went right through to finish...How did you get to the SMTP properties?. I
> appreciate your help very much.
> Regards,
> DougM
> "Jeff McIntire" wrote:
> > All I did was go to the SMTP server properties and click on the access tab.
> > Then I clicked the relay button at the bottom of the page. Next I clicked on
> > add and inputted the IP address of my server. Then I clicked ok and made
> > sure the radio button labeled â'Only the list belowâ' was selected. That
> > solved my problem and I hope it solves yours as well.
> >
> > Thanks,
> >
> > Jeff
> >
> >
> > "DougM" wrote:
> >
> > > How exactly did you do that? I have looked around for hours, you're the only
> > > that has my exact same problem.
> > >
> > > "Jeff McIntire" wrote:
> > >
> > > > I have solved my own issue. All I needed to do was edit the SMTP server
> > > > settings to grant access to the server to relay through its own IP address.
> > > >
> > > > Jeff
> > > >
> > > > "Jeff McIntire" wrote:
> > > >
> > > > > Hello all,
> > > > >
> > > > > I am trying to get some email subscriptions setup and I keep getting the
> > > > > message "The e-mail address of one or more recipients is not valid". The
> > > > > email address is valid and I am not sure what the problem is. If I set the
> > > > > email address to a local account name (i.e Administrator) the subscription
> > > > > works and e-mail shows up in the drop folder of the smtp server. Does anyone
> > > > > know how I can get my subscriptions working to real email addresses and not
> > > > > just local accounts? Any help would be appreciated.
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Jeff

Wednesday, March 21, 2012

Email Subscription

Hi,

Please help, I am trying to setup email subscriptions using reporting services. When the subscription runs i get a status of Logon Failed.

What does this error mean?

Problem with the SMTP settings?
Problem with some background user settings?

Any info in the right direction welcome.

What is the exact error message you received under the status column.

You can also look in the log file, it will be called ReportServer_(date).log under your server installation directory \logfiles.

Did you enter the right smtp address in rsReportServer.config (will be entered with installation but can be modified afterwards.)

StarBuck

Email setup with Reporting Services

I am having no luck getting RS to send email. I see no error messages in any
of the logs.
I have correct SMTP settings. These same setting work for my Project Server
emails.
What should I be looking at to help debug this issue?
Thankshmm...
Double check the <RSEmailDPConfiguration> element in your
RSReportServer.config file. In the ReportServerService_**** log file in
the\LogFiles folder, check to make sure the email successfully sent. Check
the event log on the SMTP server you are using for any errors.
If all of the above checks out, double check your firewall settings to make
sure SMTP outgoing is allowed. Also, if you are sending attachments, you
will have to open up the firewall to allow these to go out.
HTH
Adrian M.
"GRupe" <GRupe@.discussions.microsoft.com> wrote in message
news:8C7FCACB-1608-4CF9-BB97-63A091DAB05D@.microsoft.com...
>I am having no luck getting RS to send email. I see no error messages in
>any
> of the logs.
> I have correct SMTP settings. These same setting work for my Project
> Server
> emails.
> What should I be looking at to help debug this issue?
> Thanks

e-mail setup on SQL 2000 std

Hello All,
I am trying to set up e-mail notification, but when I open SQL Server Agent
(Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
Profile.
I have Outlook 2002 (XP) installed on the machine, and I tried configuring a
profile with POP and IMAP account, but no mather what I do, the Mail Profile
is stil outgreyed. I don't have MAPI access from that machine, but according
to some books I refered to it shouldn't be a must.
As I can see, either it should be a MAPI, or I am missing something that
should be installed on SQL server, a component or something like that.
Any ideas?
Thanx in advance,
ZoranYOu have t configure the EMail inBox for the service Account SQL Server
Agent is running on. If this is confugured you will be able to see the
Profile. Anyway, if you want to use another program not relying on MAPI, try
the SMTP_Sendmail which is free of charge :-)
http://www.sqldev.net/xp/xpsmtp.htm
HTH, Jens Süßmeyer.
"Kizetoni" <kizetoni@.mail.ru> schrieb im Newsbeitrag
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>|||http://www.aspfaq.com/2403
--
This is my signature. It is a general reminder.
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Kizetoni" <kizetoni@.mail.ru> wrote in message
news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> Hello All,
> I am trying to set up e-mail notification, but when I open SQL Server
> Agent
> (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> Profile.
> I have Outlook 2002 (XP) installed on the machine, and I tried configuring
> a
> profile with POP and IMAP account, but no mather what I do, the Mail
> Profile
> is stil outgreyed. I don't have MAPI access from that machine, but
> according
> to some books I refered to it shouldn't be a must.
> As I can see, either it should be a MAPI, or I am missing something that
> should be installed on SQL server, a component or something like that.
> Any ideas?
> Thanx in advance,
> Zoran
>|||Yes! :o)
Aaron, thanx!
I checked the link you sent me, and I understood that I should be logging on
with SQL service account.
Once I did that, I could configure the whole thing!
Thanx again!
Regards, Zoran
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> skrev i en meddelelse
news:%23MjmN8CQFHA.2680@.TK2MSFTNGP09.phx.gbl...
> http://www.aspfaq.com/2403
> --
> This is my signature. It is a general reminder.
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
>
> "Kizetoni" <kizetoni@.mail.ru> wrote in message
> news:ODJc24CQFHA.3788@.tk2msftngp13.phx.gbl...
> > Hello All,
> >
> > I am trying to set up e-mail notification, but when I open SQL Server
> > Agent
> > (Properties) the Mail Profile is outgreyed, and I cannot choose any Mail
> > Profile.
> >
> > I have Outlook 2002 (XP) installed on the machine, and I tried
configuring
> > a
> > profile with POP and IMAP account, but no mather what I do, the Mail
> > Profile
> > is stil outgreyed. I don't have MAPI access from that machine, but
> > according
> > to some books I refered to it shouldn't be a must.
> >
> > As I can see, either it should be a MAPI, or I am missing something that
> > should be installed on SQL server, a component or something like that.
> >
> > Any ideas?
> >
> > Thanx in advance,
> > Zoran
> >
> >
>sql

e-mail setup on SQL 2000 std

Email setup for Admins

Hello all,
Can someone point me to a site that takes you thru the steps involve in
setting up the following;
We want the server to email a list of admins when the system is having
problems.
Thanks
Deasun
Home Site: www.tirnaog.com
Check out: The Code Vault in my forums section.
In article <047E210D-909A-4F8C-AA4C-8FC891518A61@.microsoft.com>,
Deasun@.discussions.microsoft.com says...
> Hello all,
> Can someone point me to a site that takes you thru the steps involve in
> setting up the following;
> We want the server to email a list of admins when the system is having
> problems.
> Thanks
>
version?
Graham (Pete) Berry
PeteBerry@.Caltech.edu
|||Sorry should have said:
2005
Deasun
Home Site: www.tirnaog.com
Check out: The Code Vault in my forums section.
"Pete Berry" wrote:

> In article <047E210D-909A-4F8C-AA4C-8FC891518A61@.microsoft.com>,
> Deasun@.discussions.microsoft.com says...
> version?
> --
> Graham (Pete) Berry
> PeteBerry@.Caltech.edu
>

Email setup for Admins

Hello all,
Can someone point me to a site that takes you thru the steps involve in
setting up the following;
We want the server to email a list of admins when the system is having
problems.
Thanks
--
Deasun
Home Site: www.tirnaog.com
Check out: The Code Vault in my forums section.In article <047E210D-909A-4F8C-AA4C-8FC891518A61@.microsoft.com>,
Deasun@.discussions.microsoft.com says...
> Hello all,
> Can someone point me to a site that takes you thru the steps involve in
> setting up the following;
> We want the server to email a list of admins when the system is having
> problems.
> Thanks
>
version?
--
Graham (Pete) Berry
PeteBerry@.Caltech.edu|||Sorry should have said:
2005
--
Deasun
Home Site: www.tirnaog.com
Check out: The Code Vault in my forums section.
"Pete Berry" wrote:
> In article <047E210D-909A-4F8C-AA4C-8FC891518A61@.microsoft.com>,
> Deasun@.discussions.microsoft.com says...
> > Hello all,
> >
> > Can someone point me to a site that takes you thru the steps involve in
> > setting up the following;
> > We want the server to email a list of admins when the system is having
> > problems.
> >
> > Thanks
> >
> version?
> --
> Graham (Pete) Berry
> PeteBerry@.Caltech.edu
>

Email setup for Admins

Hello all,
Can someone point me to a site that takes you thru the steps involve in
setting up the following;
We want the server to email a list of admins when the system is having
problems.
Thanks
--
Deasun
Home Site: www.tirnaog.com
Check out: The Code Vault in my forums section.In article <047E210D-909A-4F8C-AA4C-8FC891518A61@.microsoft.com>,
Deasun@.discussions.microsoft.com says...
> Hello all,
> Can someone point me to a site that takes you thru the steps involve in
> setting up the following;
> We want the server to email a list of admins when the system is having
> problems.
> Thanks
>
version?
--
Graham (Pete) Berry
PeteBerry@.Caltech.edu|||Sorry should have said:
2005
Deasun
Home Site: www.tirnaog.com
Check out: The Code Vault in my forums section.
"Pete Berry" wrote:

> In article <047E210D-909A-4F8C-AA4C-8FC891518A61@.microsoft.com>,
> Deasun@.discussions.microsoft.com says...
> version?
> --
> Graham (Pete) Berry
> PeteBerry@.Caltech.edu
>

Monday, March 19, 2012

Email notifications setup

Hi
Sorry if this seems dumb, i have upgraded to sql 2000 and
am having a great time so far, but I have a little problem.
In my office only 5 people have email so we are using a
simple email server (workgroupmail) is support imap,pop
and all the other usuals.
my question is how do I set up sql server to allow me to
send emails when scheduled tasks run or dont run.
CheersIf you don't want to bother setting up exchange/mapi/outlook/sql mail, see
http://www.aspfaq.com/2403 for some other alternatives.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"merlin" <anonymous@.discussions.microsoft.com> wrote in message
news:07ba01c3b685$e3c7bed0$a301280a@.phx.gbl...
> Hi
> Sorry if this seems dumb, i have upgraded to sql 2000 and
> am having a great time so far, but I have a little problem.
> In my office only 5 people have email so we are using a
> simple email server (workgroupmail) is support imap,pop
> and all the other usuals.
> my question is how do I set up sql server to allow me to
> send emails when scheduled tasks run or dont run.
> Cheers|||Hi
The following show how to set up mail on sqlserver:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba01/html/SQLServerE-mail.asp
and a whole lot more:
http://www.aspfaq.com/show.asp?id=2403
Without a exchange you may have to have a user logged into the server with
outlook open see (I am not sure if this has changed recently!!) :
http://tinyurl.com/wzx5
An alternative if you have SMTP is XPSMTP
http://www.sqldev.net/xp/xpsmtp.htm
You will have to write your own notification calls.
John
"merlin" <anonymous@.discussions.microsoft.com> wrote in message
news:07ba01c3b685$e3c7bed0$a301280a@.phx.gbl...
> Hi
> Sorry if this seems dumb, i have upgraded to sql 2000 and
> am having a great time so far, but I have a little problem.
> In my office only 5 people have email so we are using a
> simple email server (workgroupmail) is support imap,pop
> and all the other usuals.
> my question is how do I set up sql server to allow me to
> send emails when scheduled tasks run or dont run.
> Cheers

Tuesday, March 27, 2012

Embedded Images ....

Monday, March 26, 2012

Emailing Errors

Emailing Errors

Email with attachments.

Email with attachments.

Email with attachments.

Thursday, March 22, 2012

email trigger

email trigger

email trigger

Email through SQL

Email subscriptions

Wednesday, March 21, 2012

Email Subscription

Email setup with Reporting Services

e-mail setup on SQL 2000 std

e-mail setup on SQL 2000 std

e-mail setup on SQL 2000 std

Email setup for Admins

Email setup for Admins

Email setup for Admins

Monday, March 19, 2012

Email notifications setup

Sql Edition Selection

Blog Archive

About Me