Home Forums SQL Server 2005 Administering Best way to create a weekly email report for SQL Server RE: Best way to create a weekly email report for SQL Server

  • Backup summary.

    Avg Disk Reads / Writes

    SCOM could get you some of the info you need. Other options are to use PowerShell, SMO, tsql scripts to build a custom in-house app that could track and email this stuff.

    Another option would be to use the dynamic management views to gather information, and then use SSRS, SSIS, or TSQL script to send the report.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events