If the table is a small table (less then 8 pages), then it is located on shared extent. Shared extent stores pages of few small tables that each one of them has less then 8 pages. Since those tables don’t have there own extents, reducing there fragmentation won’t always be successful. In any case there is no reason to worry about it, since at that size it doesn’t really matter.

One small remark – You are working on SQL Server 2005. The DBCC commands to rebuild or reorganize the tables/indexes are there because of compatibility issues. Microsoft is planning to remove those commands in the future versions. Instead of using those commands, you can (and should) use the alter index statements.

Adi