Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vinay.varala
Starting Member
3 Posts |
 Posted - 2014-01-11 : 16:47:23
|
| I have removed 10 columns from table actually table consists of 50 columns . I have executed dbcc cleantable to reclaim space but gives up below message 'DBCC execution completed. If DBCC printed error messages, contact your system administrator' .can someone help me how to reclaim space ?Regards, |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-01-11 : 19:25:10
|
| Can you explain how you know it didn't reclaim the space? Are you referring to the file sizes? If so, you would need to execute dbcc shrinkfile to reclaim space back to the disk.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
vinay.varala
Starting Member
3 Posts |
Posted - 2014-01-12 : 02:59:25
|
| after executing dbcc cleantable command looking for avg_page_space_used_in_percent its shows the same percent before and after executing and rebuild the clustered index to ensure it works.command I am using to execute : dbcc cleantable (testfm,TEST_AccDam);Regards, |
|
|
|
|
|
|
DBCC Cleantable