The sp_database procedure will return the name and size for each DB on the server (to which the user has access). I have several servers, and would like to get not only the name and size of each DB on each server, but would like the DataSize, DataFreeSpace, LogSize and LogFreeSpace. I would like to run a procedure to get/update the latest data on a regular basis.
Any help on this is greatly appreciated.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.
