Is there a way to compact a SQL2000/2005 MDF file?

Question

I deleted millions of rows of old data from a production SQL database recently, and it didn't seem to shrink the size of the .MDF file much. We have a finite amount of disk space.

I am wondering if there is anything else I can do to "tighten" the file (like something analogous to Access' Compact and Repair function)?

Answer 1

DBCC SHRINKDATABASE etc. - read up on transaction logs and backups in the Books Online

Answer 2

Use the Shrink File option in Sql Server Management Studio Right-click on Database > Tasks > Shrink > Database (or Files)