MSDE database deleting data to make space.
Posted on 2007-03-24
Hello Expert-Exchange Members
I have an application that has a MSDE database, this week the database has hit the MSDE limit of 2GB data file. I have some space that will keep the application going for a couple of weeks. I need to make more space in the data file.
I have delete data out of the largest tables, but no space has been made in the data part of the database file. I have never seen this before, I deal with many SQL Database everyday and have been able to delete data from them to make sapce.
I have doubled check to see if the applcation is rebuilding the data in the database but that is not the case.
I think it may have something to do with the fillfactor between the databse table rows as it is set to 0% and I have never seen that before. Is that the case and how would I resove?
Thank you for Reading