the SQL server 2008 R2 report

"You have to write the Store procedure to send this report via dbmail. Here is a very nice article with step by step instructions including stored procedure to send Disk usuage report via email"

what if I need to send out whatever report I want, any way to generate that without knowing to much SQL programming ?

it should be generate the same beautiful report as the SSMS instead of pure simple table with text only.

we do not have SSRS installed.

Either you have SSRS or not, you still have to query your databases by creating Stored procedure or just writing queries to get any Management Data Warehouse reports which in this case you wanted.

There is no simple way Sorry !

the report format by that article is too simple, so we can't just generate exactly the same report from the SQL server SSMS dashboard?

basically in my previous  company, they setup it up and it works everyday.

I just don't know how to do it.

it seems that if I want to programming more on SSMS report, I need to use reporting builder from SQL server 2008 R2, right?

I am not sure if this is helpful articles:

1)http://blogs.msdn.com/b/billramo/archive/2010/06/06/mdw-overview-report-for-data-collector-mdw-report-series-part-1.aspx
2) http://blogs.msdn.com/b/billramo/archive/2010/06/19/mdw-overview-report-for-data-collector-server-activity-mdw-report-series-part-2.aspx
3) http://blogs.msdn.com/b/billramo/archive/2010/11/18/may-the-source-be-with-you-mdw-report-series-part-6-the-final-edition.aspx
4) http://blogs.msdn.com/b/billramo/archive/2010/10/24/what-are-all-these-reports-anyways-mdw-report-series-part-5.aspx

5) http://blogs.msdn.com/b/billramo/archive/2010/06/28/server-activity-history-report-mdw-report-series-part-4.aspx

6) http://blogs.msdn.com/b/managingsql/archive/2010/06/21/server-activity-history-report-mdw-report-series-part-3.aspx
?

also how can I use the file download from here if you know :

http://blogs.msdn.com/b/billramo/archive/2011/02/19/mdw-reports-new-source-code-zip-file-available.aspx

Hi marrowyung,

Above shows you the reporting via SSRS. You can enable SSRS on your server if you want. The file above can be used with SSRS, via SQL Server Business Intelligence Development Studio.

Keep in mind, you might have to tweak some of the queries or Stored procedures listed in tutorial above in order to accommodate with your databases.

As per something at your previous work, they might have custom report too, as there is no such automated report, but if you create one, u can make it automated going forward.

Mohit

Mohit,

But the production server do not have SSRS installed but only SSIS.

Waht should I do ?

install the SSRS in a separate machine and configure that report template ? thne once it is done ship it to the production server. will it works ?

"As per something at your previous work, they might have custom report too, as there is no such automated report, "

So we can't just simple make use of the SAME reporting format from the SSMS and email to someone ?

Hi marrowyung,

Sorry for the late reply as I was away. As per the examples and RDL files you have listed above, you do need SSRS to get anything working. You can just enable SSRS on dev or test server and connect your production server as a link server to SSRS from there, this way you can run any report pertaining to production data. You need that SSRS server for future reporting too, it's not like you design report in SSRS and once its done, u can disable it. SSRS is the reporting engine for the reports to render.

The only other way of bypassing SSRS is writing your own SP to get what you want and use dbmail to send emails accordingly.  I know that's sounds a lot of work, but unfortunately I haven't come across any simple solution. In case my answers doesn't justify you, you can close this question and open something again and may be other experts have something to share which I am not aware or known off.

Best Regards,

Mohit

"
The only other way of bypassing SSRS is writing your own SP to get what you want and use dbmail to send emails accordingly."

This is that I am doing it also, what kind of script you can suggest?

I am now testing the database disk space script.

might be you can help to answer :

https://www.experts-exchange.com/questions/28089671/master-sp-send-cdosysmail.html

I don't know why the script for SQL 2005 can't send out email.

"You need that SSRS server for future reporting too, it's not like you design report in SSRS and once its done, u can disable it. SSRS is the reporting engine for the reports to render.
"

So after I fix the report on SSRS on a test server, I can't use it on production server as the production server do not have SSRS installed?