End to End Server Disk Space reporting within SQL Server

This procedure using OLE object calls to obtain server disk space values and writes them to a table. It then creates an HTML report based on the contents of the table and then , via a SQL Agent job, sends out colour coded emails relating to how much drive space is left... this is very handy!!!!

2 (2)

2016-03-16 (first published: )

1,016 reads

Blogs

The PowerShell Basics If Statement–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

T-SQL Tuesday Retrospective #013: What the business wants

By

Click here to read previous retrospective entries. From Steve Jones (blog | Twitter) in December 2010...

Daily Coping 14 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SSRS Report doesn't refresh data

By christi1711

Hi all, I have SSRS Report that uses SP as a source. I have...

Last day of the previous month - Format MM/DD/YYYY

By SQL Server

I use the below to get Last day of Previous Month, but I want...

How to change schema of all tables, views and stored procedures in MSSQL

By carlton 84646

Hello Community, I trying to use the following sql code to change the Schema...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Sorting in R

See possible answers