I've got an instance with dozens of DB's, and I need to know the total spaced used by all the DB's. I don't want to have to do sp_spaceused on each of them. Could I do a foreach loop and add them all up, or something like that? Or is there some system stored proc that will do the job?
If the DBs are on their own partitions,
Not sure how you'd do it inside Sybase itself, though.