|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
automating SSMS reportsIs 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 Show quote > 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? -- Show quote-- Margo Noreen "Simon Sabin" wrote: > 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? 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. Show quote "M Noreen" <MNor***@discussions.microsoft.com> wrote in message news:3D38CBF0-A6EC-435F-B1EC-309BAEF92BC5@microsoft.com... > So that assumes one has Reporting Services setup and configured... which > we > do not. > > No other way? > > -- > -- Margo Noreen > > > "Simon Sabin" wrote: > >> 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? We have Reporting Services installed on some servers. Can we run these
reports against any other SQL Servers in our network. thanks, ktm Show quote "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" <MNor***@discussions.microsoft.com> wrote in message > news:3D38CBF0-A6EC-435F-B1EC-309BAEF92BC5@microsoft.com... > > So that assumes one has Reporting Services setup and configured... which > > we > > do not. > > > > No other way? > > > > -- > > -- Margo Noreen > > > > > > "Simon Sabin" wrote: > > > >> 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? > > > 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/ Show quote "ktmd" <k***@discussions.microsoft.com> wrote in message news:3F316342-FAB9-4E5A-802A-320713FD9E39@microsoft.com... > 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" <MNor***@discussions.microsoft.com> wrote in message >> news:3D38CBF0-A6EC-435F-B1EC-309BAEF92BC5@microsoft.com... >> > So that assumes one has Reporting Services setup and configured... >> > which >> > we >> > do not. >> > >> > No other way? >> > >> > -- >> > -- Margo Noreen >> > >> > >> > "Simon Sabin" wrote: >> > >> >> 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? >> >> >>  |
|||||||||||||||||||||||
Other interesting topics