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,026 reads

Blogs

Accessibility is not just about slides

By

Although I don’t write about it much on this website, I am on the...

Daily Coping 4 Aug 2021

By

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

Architect a disaster recovery for SQL Server on AWS: Part 1

By

  New blog post - Architect a disaster recovery for SQL Server on AWS: Part...

Read the latest Blogs

Forums

Nested Join Alternative

By Jackie Lowery

Is there a better way to write this nested join query?  I'm concerned about...

How to determine whether SSIS is being used?

By jankovic

Hello I've inherited some dev environment which looks like was abandoned, but I'd like...

xml output from sql query

By Bruin

The script runs but gives me "no data to export"  I see data in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers