SQL Server 2005 compaction

In SQL server 2005 (Express and Standard), does the database automatically compact itself (ie allow the reuse of disk space)?

Thanks in advance!
steven_maherAsked:
Who is Participating?
 
EvilPostItConnect With a Mentor Commented:
You would have to shrink the data file or set the database to auto_shrink.

Please do bear in mind that any kind of shrink operation will fragment the database.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.