asked on 7/24/2008

Emailing Log Shipping or other SQL 2005 Standard reports to users?

Hi all

Does anyone know if it is possible to email the log shipping report to end users so that they don't have to log on to SSMS to check the status?

An if you can do this does anyone know how?

Thanks

Gopher

Microsoft SQL Server 2005

Last Comment

Gopher1976

7/24/2008

chapmandew

7/24/2008

You can use database mail and send the results to them....

setting up db mail:
http://articles.techrepublic.com.com/5100-10878_11-6164310.html

to execute the report:

execute sp_help_log_shipping_monitor

Gopher1976

7/24/2008

ASKER

Ok, but can the report be similar to the HTML Version in SQL Standard Reports?

chapmandew

7/24/2008

You mean from reporting services?...It can, if you're good.

If you're using reporting services, then you can just create a report to execute the stored procedure from above and then have your RS alerts send out the email....does that make sense?

Gopher1976

7/24/2008

ASKER

Ah I see!

Unfortunately we don't have reporting services enabled - but I might have to try and come up with a custom report.

Also how can you get the results of a query in the email body?

Thanks for your help

chapmandew

7/24/2008

In the link I gave you, I list a few different ways to email results...

Gopher1976

7/24/2008

ASKER

Thanks, I have had a go and I get the email. Unfortunately the formatting is really bad and our end users will have no idea what it means!!

I will award you the points, but on a side not you don't know how to make the results more readable?

Thanks

Gopher

ASKER CERTIFIED SOLUTION

chapmandew

7/24/2008

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Gopher1976

7/24/2008

ASKER

Thanks