Gurus.. Please help for Data file used space
I want to select the information for 'database used' and 'datafile used' spaces from the system tables. Which table or query can I use?
I updated statiscs, ran sp_updateusdage command but found the data displayed by sp_spaceused command without parameters lot differing from the data displayed from Enterprise Manager/View/Taskpad for the same database. Though this is simple in other databse vendors, it looks a bit difficult in SQLServer2000 which is known for user friendly.
For example I found fo a databse
Enterprise Manager shows database free: 3.13 MB