Eric:

When I look for the Database size and available space via Enterprise Manager and using the system SP - sp_spaceused, Database size seems to be perfect but there seems to be discrepancies in the available space(Enterprise Manager) and Unallocated Space (sp_spaceused).

Isit a SQL Server bug or my understanding is wrong?

Thanks,

Kothan.

-- Anonymous, November 19, 1999

Answers

Kothan,

Neil Pike, MVP/MCSE of Protech Computing Ltd. provides this answer on the usenet forum, microsoft.public.sqlserver.connect.

Q. Why does my SQL Server log show that it's still full? - I have truncated it. (v1.0 17.10.1998) A. The reason for this is that all the tools that interrogate log space - e.g. dbcc sqlperf, sp_spaceused and SQL EM all just look at the system catalog information in sysindexes - the dpages column. In SQL 6.5 and earlier this information is NOT kept up to date, so it is constantly wrong. The reason it is not kept updated is that it would cause a performance bottleneck. The easiest way to correct the information is :- dbcc checktable(syslogs)

go

checkpoint

go

The information will then be correct until the next update/delete/insert transaction is issued.

Hope this helps,

Eric

-- Anonymous, November 24, 1999