By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,920 Members | 1,946 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,920 IT Pros & Developers. It's quick & easy.

Reclaim disk space after DROP columns

P: n/a
Hello,

I tried to make what one reply advice to recover the disk space after
DROPed columns but it doesn't work. I did DBCC DBREINDEX to the table
but nothing changes.

Any other solution?

Ignacio

Aug 2 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Be sure to run DBCC UPDATEUSAGE(0) so the the numbers reported about
page usage will be accurate.

Roy Harvey
Beacon Falls, CT

On 2 Aug 2006 12:41:55 -0700, "Nacho" <na*********@gmail.comwrote:
>Hello,

I tried to make what one reply advice to recover the disk space after
DROPed columns but it doesn't work. I did DBCC DBREINDEX to the table
but nothing changes.

Any other solution?

Ignacio
Aug 2 '06 #2

P: n/a
Nacho (na*********@gmail.com) writes:
I tried to make what one reply advice to recover the disk space after
DROPed columns but it doesn't work. I did DBCC DBREINDEX to the table
but nothing changes.
DBCC CLEANTABLE may be what you need to try.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Aug 2 '06 #3

P: n/a
thanks a lot, it worked perfectly !!!!
Nacho

Roy Harvey wrote:
Be sure to run DBCC UPDATEUSAGE(0) so the the numbers reported about
page usage will be accurate.

Roy Harvey
Beacon Falls, CT

On 2 Aug 2006 12:41:55 -0700, "Nacho" <na*********@gmail.comwrote:
Hello,

I tried to make what one reply advice to recover the disk space after
DROPed columns but it doesn't work. I did DBCC DBREINDEX to the table
but nothing changes.

Any other solution?

Ignacio
Aug 3 '06 #4

P: n/a
I have SQL 2005 express, when I send this command you told me(DBCC
CLEANTABLE ) the system doesn't recognize even the command
"cleantable".
What am I doing wrong?
Nacho

Erland Sommarskog wrote:
Nacho (na*********@gmail.com) writes:
I tried to make what one reply advice to recover the disk space after
DROPed columns but it doesn't work. I did DBCC DBREINDEX to the table
but nothing changes.

DBCC CLEANTABLE may be what you need to try.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Aug 3 '06 #5

P: n/a
Nacho (na*********@gmail.com) writes:
I have SQL 2005 express, when I send this command you told me(DBCC
CLEANTABLE ) the system doesn't recognize even the command
"cleantable".
What am I doing wrong?
Exactly which command did you use? This ran for me:

DBCC CLEANTABLE(usertest, lingondricka)

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Aug 3 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.