The Standard reports can be used to generate various reports for server and database level in SQL Server 2005.
I am trying to find out whether these reports can be automated i.e. can these standard reports be generated automatically and scheduled in a SQL job.
I would also like to know whether they can then be emailed, maybe as an attachment (XLS/PDF) or just sent as part of the email?
Any help would be highly appreciated.
asked Mar 30 '10 at 09:00 AM in Default
The reports that are accessed from the SSMS object explorer are rdl files like any other report, they take values from the point in the tree where you right click as parameters to give you data relevant to your selection.
It would be possible to locate a copy of these reports to a report server and schedule/email/export to file share as with any other report, so long as you provide values for the parameters.
you can get the set of Standard Reports from this blog - http://blogs.msdn.com/sqlrem/archive/2006/08/30/SSMS-Reports-3.aspx
answered Mar 30 '10 at 09:25 AM