Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
joed777
Starting Member
4 Posts |
 Posted - 2005-05-11 : 16:51:45
|
| I was randomly executing sp_spaceused to see what kind of results I would get, when I got this:database_name database_size unallocated space Enterprise 1060.63 MB -59708.27 MB reserved data index_size unused61710168 KB 60707320 KB 359472 KB 643376 KBWhat's up with the minus (-) sign under the 'unallocated space'?TIA,JD |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-11 : 18:21:03
|
| Try running sp_spaceused with the @updateusage = TRUE option.Tara |
 |
|
|
joed777
Starting Member
4 Posts |
Posted - 2005-05-17 : 14:59:25
|
| Thanks Tara, that worked.joed777 |
|
|
|
|
|
|
sp_spaceused