I have been looking for away to find out how much space is avaiable in the data devices for a database. I would like to automate as a select statement or stored procedure and then only alert the administrator when the device gets near to filling up.
I have tried using sp_spaceused but that shows space left for the log as well which is not usful if you have a 500MB log file.
I have tried using sp_spaceused but that shows space left for the log as well which is not usful if you have a 500MB log file.
