471,090 Members | 1,343 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,090 software developers and data experts.

sp_spaceused

Hi,

In our environment sp-spaceused returns:
Allocated: 500
Unallocated: -100

Enterprise Database Taskpad shows that our total database size = 400 MB
(320 used; 80 unused)

Windows Explorer shows also that MDF file is more or less 400 MB.

What does sp_spaceused exactly ???
How do I SELECT the 320;80 of the taskpad with a query ???

Greetings,

Arno de Jong, The Netherlands.
Jul 20 '05 #1
1 3724
Most likely the statistics are not updated. Have you tried with the
@updateusage option? Or you can run DBCC UPDATEUSAGE on the database or on
the specific table. Refer to SQL Server Books Online for more details.

--
- Anith
( Please reply to newsgroups only )
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Brad Tobin | last post: by
1 post views Thread by Saiyou Anh | last post: by
1 post views Thread by Philip Yale | last post: by
1 post views Thread by Harcharan Jassal | last post: by
2 posts views Thread by Peter CCH | last post: by
2 posts views Thread by Desmodromic | last post: by
30 posts views Thread by Neil | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.