sp_spaceused

[A.M. de Jong]

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.

[Anith Sen]

Re: sp_spaceused

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 )