Technical Article

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)

You rated this post out of 5. Change rating

2016-03-16 (first published: )

1,113 reads

Blogs

A Couple Quick GENERATE_SERIES Tests

By

I had someone reach out about generate_series() recently, saying they hadn’t realized this was...

How I passed the DP-700 Exam

By

I recently took and passed the DP-700 exam, which is required for the Microsoft...

Which approach to take: Build it, buy it, cloud it?

By

As a Consultant, I would typically answer with – it depends! Then a typical...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

How to Download and Restore AdventureWorks 2019 Database

By Noman072

Comments posted to this topic are about the item How to Download and Restore...

Tracking Table Sizes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Tracking Table Sizes

Visit the forum

Question of the Day

Counting Bits IV

What does this code return in SQL Server 2022+?

select bit_count(2.4)
 

See possible answers