Does SQL Server need compacting like MSAccess databases?

I have a database on a shared SQL 2005 server at www.serverintellect.com

It is currently limited to 250 MB.

I have a stored procedure that runs every 15 minutes. It deletes all records
from a table and then inserts records again on the same table.

If this was MSAccess, the file size of the database would increase every 15
minutes by the size of the insert. Does the same apply to SQL Server 2005?

On Jul 15, 4:59 am, "Mark B" wrote:
> I have a database on a shared SQL 2005 server atwww.serverintellect.com
>
> It is currently limited to 250 MB.
>
> I have a stored procedure that runs every 15 minutes. It deletes all records
> from a table and then inserts records again on the same table.
>
> If this was MSAccess, the file size of the database would increase every 15
> minutes by the size of the insert. Does the same apply to SQL Server 2005?

Since you delete the data that space will be free and MSSQL will use
that space during next insert, after using all free space is there is
need of more space file will grow as per setting in your db.
MSSQL does not release the space to OS automatically after deleting
data.

Amish Shah
http://shahamishm.blogspot.com