Table size problem in SQL Server 7

[taixut]

Hi,

I have a table in SQL Server 7 with some rows (around 2000). The info in this table is updated around 30 times a day (only updates, nevers inserts). Everything works fine but from time to time the size of the table starts increasing til there is not enough space on the disk. If I drop the table, shrink the DB and create it again I recover the space...

Does anybody know why this can happen and a way to stop it happening??

Thanks.

 

[nigelrivett]

I assume it is the table that is increasing not the transaction log.

Have a look at what the processes are doing - that something is not looping running updates.

Is it the data or indexes that are growing?

Have a look at the page allocations - if it's really the table then there have to be a lot of empty extents.

You can look at what is actually in the pages using dbcc page.
see

http://www.nigelrivett.net/PageStructure.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[taixut]

Thanks for your help...

it's the data what is growing...
Right now the page allocations seems to be pretty ok...But if finally is that, what can I do to solve the problem?