Hi Carl,

Thanks for the reply. Yep, I re-ran the REINDEX, UPDATEUSAGE and sp_spaceused again exactly as you mentioned to double check it wasn't my befuddled brain but it's coming out the same. The exact order I last ran these in was:

dbcc cleantable ('DatabaseName','NotMyTable')

go

backup database DatabaseName to disk ='C:\DatabaseName.bak' WITH INIT, NOUNLOAD, NOFORMAT, SKIP,STATS = 10

go

dbcc shrinkdatabase (DatabaseName, 10)

go

dbcc shrinkfile(1)

go

exec sp_updatestats

go

dbcc dbreindex ('DatabaseName.dbo.NotMyTable', IX_NotMyTable, 90)

go

dbcc indexdefrag (DatabaseName, NotMyTable, IX_NotMyTable)

go

dbcc shrinkfile(1)

go

dbcc updateusage (DatabaseName) with count_rows

go

exec sp_spaceused 'NotMyTable'

go

Here are the results from the query (sorry about the formatting):

PageBytes_sb_8096 KbPerPages_sb_8

8192 8

IndexName indid rows OrigFillFactor ReservedPages DataPages ReservedKB DataKb IndexKb

IX_NotMytable126169979034620343632769602749042008

_WA_Sys_KeyID_5FF32EF82090NULLNULLNULLNULLNULL

_WA_Sys_An1ID_5FF32EF83090NULLNULLNULLNULLNULL

_WA_Sys_An2ID_5FF32EF84090NULLNULLNULLNULLNULL

_WA_Sys_An3ID_5FF32EF85090NULLNULLNULLNULLNULL

_WA_Sys_TC_5FF32EF86090NULLNULLNULLNULLNULL

_WA_Sys_UpdBy_5FF32EF87090NULLNULLNULLNULLNULL

_WA_Sys_UpdWhen_5FF32EF88090NULLNULLNULLNULLNULL

_WA_Sys_UpdAction_5FF32EF89090NULLNULLNULLNULLNULL

tNotMytable25500729546224736583636817978880

name rows reserved data index_size unused

NotMyTable2616997 6113328 KB2072792 KB2008 KB4038528 KB

Can I also ask, do you know where I could get more info on spt_values or is it one of those MS-only-undocumented ones?

Yours Appreciatively,

Martin