Create HTML email/page from SQL Query

Last Post 25 Mar 2009 11:26 AM by phsatech. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
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.
You are not authorized to post a reply.

Acceptable Use Policy