LinkedIn | FaceBook | Twitter
I've completed documenting all of the Standard Reports in SQL Server Management Studio. You can get to them from the tags, but I thought I would post a list of them all here with the links.
I hope that you've been able to put some of this information into use in your organization. A lot of work went into creating and surfacing these reports, and we think they can really help you make your day more productive.
I'd also love to hear if you've created your own reports, and how you're using them. If you're willing, you can post them on CodePlex, and leave a link here.
PingBack from http://alonzo.mediaplusnews.info/sqlservermanagementstudio.html
Great series! thanks!
Is there a way to schedule one of these reports so it executed and sent by email?
No, these are within Management Studio - but there are tools like Quest, Idera and Redgate that can do that.
Is this latest / updated list of std. reports? and is there any Reports for analyzing cubes utilization and performance?
Yes, it's current, and no, there aren't any that I am aware of for that. But as of SQL Server 2005 SP2 you can create your own.
Every edition of SQL Server has access to the Standard reports? Thanks.
Pnglv: Yes, with the exception of Express.
Perfect. I need them. Thanks very much!
Does u know if the sql server agent standard rpts (Top Jobs rpt) can be imported into SSRS or scheduled to run and sent via email?
If you are interested in automating reports like these take a look at blogs.msdn.com/.../mdw-overview-report-for-data-collector-mdw-report-series-part-1.aspx
It assumes you are running and have access to the SCOM MDW
i am running a query daily and extracting the output . is there a way that it run the query daily at a particular time and send mail or save it in a location.
Max, yes, you can do that. Use SQL Server Reporting Services and you can create an automated report. You could also simply use a SQL Server Agent Job to do the same.