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: )

993 reads

Blogs

Check Query Progress with Live Query Stats

By

This is something I touched on back in 2017 a little after the Live...

SQL Server 2019 on Docker no longer runs as root by default

By

In my home lab I have an Ubuntu virtual machine that runs both SQL...

SQL Server 2019 – Compatibility Level in Azure

By

I am not sure when this became available but for Azure SQL Database 150...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

SSIS catalog deployment from source server to target - powershell

By iKvfpMWsaoC1Gy8

I am looking for a good solution for automating the deployment of SSIS packages...

XML Data singleton value not fixed????

By jbalbo

Hi Hope to explain this correctly I have some XML data that can vary...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers