For sure. You would need to have all of your linked servers set up correctly, and then from there you could add an input parameter to the proc which would...

Unfortunately, it will likely be a while from now. I've recently changed jobs and on top of that I am expecting my first child in < 1 month. So, things...

Good news. Thanks for sharing the solution. 🙂

It's pointing to the correct db mail profile and you changed the email address in the proc, correct?

Thanks. Hope it helps.

Thanks. 🙂

Yes indeed. All of the quarterly calculations are now there in the script. 🙂

LOL! Maybe I'll add those next. 😉

The report is intended to compile SQL Server information and then send the results to a recipient via email. You will need to have mail functionality turned on and configured....

It sounds like you are set up to send mail from SQL Server, but can you confirm this? And if yes, do you have any other processes that currently send...

Quick FYI:

I've added a few more calculations (should be online soon, the code changes are just "awaiting approval" from SQLServerCentral):

is_last_day_in_month: is the date value the last day of the month...

Fantastic! Thanks for letting me know. 🙂

I believe it should run on 2008, though I don't have a box to test it against. If you do, please let me know if it runs as expected. Thanks!

Perfect. I like the idea a lot. I've added it to the list and will re-post the script when it's done.

Great! Glad it worked. It's probably easier to just change the VARCHAR value, but whatever works best for you. 🙂