Create HTML email/page from SQL Query

Last Post 25 Mar 2009 11:26 AM by phsatech. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
phsatech
New Member
New Member

--
25 Mar 2009 11:26 AM
We run SQL 2000 (non-reporting) and I have a query that runs nightly to update a table for disk space on our server farm.

I'd like to do one or both; send an html email out; and/or have the results populate into a html page. I'm not much of a web programmer so I thought I'd get some ideas here.

Basically the query

use DiskMonitor
"SELECT * FROM Freespace"

Columns:
Computer
Drive
DiskSize
FreeSpace
Percentage
Date


Appreciate input.


Acceptable Use Policy
---