MS SQL Server - DBCC ShowFileStatus v. SP

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

DBCC ShowFileStatus v. SP_Spaceused

vtcs212

2005-07-21, 7:23 am

In trying to determine how much space is begin used by a database and how
much space is free, DBCC ShowFileStatus and SP_Spaceused give simillar, but
different results. Which is more accurate?

Tibor Karaszi

2005-07-21, 11:23 am

DBCC is accurate. Read the source for sp_spaceused and you will see that it picks up the info from
sysindexes.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/

"vtcs212" <vtcs212@discussions.microsoft.com> wrote in message
news:DC3D36A0-E5A6-43AE-94F0- ECE6AC081407@microso
ft.com...
> In trying to determine how much space is begin used by a database and how
> much space is free, DBCC ShowFileStatus and SP_Spaceused give simillar, but
> different results. Which is more accurate?

Sponsored Links