Stored Procedures

Technical Article

End to End Server Disk Space reporting within SQL Server

  • Script

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)

You rated this post out of 5. Change rating

2016-03-16 (first published: )

1,074 reads

Blogs

TryHackMe Advent of Cyber

By

I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...

You should be running on SQL Server 2022

By

It’s me again with my apparently semi-annual blog post. This time we’re going to...

Removing a PowerShell Array Element–#SQLNewBlogger

By

I saw an article on this and realized I had no idea how to...

Read the latest Blogs

Forums

Asking for your feedback on a PHP code security scanner in beta

By Kevbrock12

Hey! Kev is here to invite you to an exciting experience. Our team, full...

WHY Follow a LEFT OUTER JOIN with another LEFT OUTER JOIN

By YSLGuru

NOTE: The Topic Title probably isn't very good but I wasn't sure how to...

Replication Monitoring with Always On Availability Group

By sqlpops

Hey Folks, So I have SQL Transactional Replication set up on a database that's...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers