SQL Server Performance Forum – Threads Archive
Space usedHi all, Just need to find out total space uesed in database server. in SQL 2000 and 2005!! how can i get that please. thanks Thanks!!
SP_SPACEUSED @UPDATEUSAGE=’TRUE’ Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Also check out xp_fixeddrives and dbcc sqlperf(logspace) for drive space usage and log space usage respectively.
http://sqlteam.com/forums/topic.asp?TOPIC_ID=61762 Madhivanan Failing to plan is Planning to fail