Hello,

I have observed an unusual happening in the past couple of weeks. I added two rows to a table in the database called shift_code and shift_name. Both were of type varchar and 14 and 7 in size, with Nulls allowed. Since this addition my Database has soubled in size from 100 to 200MB in size. The transaction Log is dumped every 12 hours and a full backup is done every 24 hours. After 5 days the DB returned to it original size but then after archiving data it has returned to 200MB in size and has remained that size for over a week now. Can anyone explian what is happening here. There are 1,117,064 rows in total in my Database of average length 80chars. Any comments or explainations would be greatly appreciated. Regards Alan Shinnors