automating SSMS reports

Is there a way to automate some of the reports available in Sql Server Mgmt
Studio? I really like several of them, such as the Schema Changes History,
and think they would be helpful from a "compliance" perspective. So, I've
been exporting a few to PDF or Excel on a regular basis... so it's pretty
obvious that the next step would be to have a job that does automatically on
a scheduled basis (Daily, Weekly, whatever).
Any insight on if this doable w/out too many hoops?
-- Margo Noreen
Hello M,
You can download the reports here
http://blogs.msdn.com/sqlrem/archive/2006/08/30/SSMS_Reports_3.aspx
You will need to put them in RS and schedule them
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

> Is there a way to automate some of the reports available in Sql Server
> Mgmt Studio? I really like several of them, such as the Schema
> Changes History, and think they would be helpful from a "compliance"
> perspective. So, I've been exporting a few to PDF or Excel on a
> regular basis... so it's pretty obvious that the next step would be to
> have a job that does automatically on a scheduled basis (Daily,
> Weekly, whatever).
> Any insight on if this doable w/out too many hoops?
>
|||So that assumes one has Reporting Services setup and configured... which we
do not.
No other way?
-- Margo Noreen
"Simon Sabin" wrote:
[vbcol=seagreen]
> Hello M,
> You can download the reports here
> http://blogs.msdn.com/sqlrem/archive/2006/08/30/SSMS_Reports_3.aspx
> You will need to put them in RS and schedule them
>
> Simon Sabin
> SQL Server MVP
> http://sqlblogcasts.com/blogs/simons
>
|||RS is needed if you want the same cool look you currently have in Management
Studio. If you're just after the data, you can pull the queries into a
sproc, tweak it to output to a persistent table and schedule a job to run it
at whatever frequency you need.
joe.
"M Noreen" <MNoreen@.discussions.microsoft.com> wrote in message
news:3D38CBF0-A6EC-435F-B1EC-309BAEF92BC5@.microsoft.com...[vbcol=seagreen]
> So that assumes one has Reporting Services setup and configured... which
> we
> do not.
> No other way?
> --
> -- Margo Noreen
>
> "Simon Sabin" wrote:
|||We have Reporting Services installed on some servers. Can we run these
reports against any other SQL Servers in our network.
thanks,
ktm
"Joe Yong" wrote:

> RS is needed if you want the same cool look you currently have in Management
> Studio. If you're just after the data, you can pull the queries into a
> sproc, tweak it to output to a persistent table and schedule a job to run it
> at whatever frequency you need.
>
> joe.
> "M Noreen" <MNoreen@.discussions.microsoft.com> wrote in message
> news:3D38CBF0-A6EC-435F-B1EC-309BAEF92BC5@.microsoft.com...
>
>
|||You can run these reports against any SQL Server 2005 instance.
Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/
"ktmd" <ktmd@.discussions.microsoft.com> wrote in message
news:3F316342-FAB9-4E5A-802A-320713FD9E39@.microsoft.com...[vbcol=seagreen]
> We have Reporting Services installed on some servers. Can we run these
> reports against any other SQL Servers in our network.
> thanks,
> ktm
> "Joe Yong" wrote: