SQL Server Performance Forum – Threads Archive
How to get unallocated space
Hi allexec sp_spaceused
If you run the above query u will get
database_name database_size unallocated space
————————————– —————— ——————
master 12.19 MB 0.77 MB
reserved data index_size unused
—————— —————— —————— ——————
10928 KB 9256 KB 1320 KB 352 KB
U will get the above result. My request is how to get ‘unallocated space’ value. because its return two different type of rowsets. can you help me. or give me alternate script. Thanks
S. Ramesh
Look at the definition of sp_spaceused, take a copy and modify as you please. Roji. P. Thomas
http://toponewithties.blogspot.com
Have fun with thishttp://www.4guysfromrolla.com/webtech/032906-1.shtml article. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>