How do you Compact / repair the database in V4 sql2008 R2 Express?

I can't seem to find the option in the menu.

Regards

Rick

Hi Rick,

With SQL Server there isn't an equivalent of a Compact Repair (one of the advantages to SQL Server!) so the menu options are no longer needed.

There are some maintenance bits you can do periodically, and we're hoping to publish some more info on this once we have it documented fully.

------------
Peter Jarrett, Technical Director
Broadcast Radio Ltd.

Bill Bailey: No win, no fee, no basis in reality. Just a room above a minicab office in Acton and a steady stream of greedy simpletons whose delusion is only matched by their clumsiness

Thanks for the info Peter!

Will your maintenance bits include a database defrag script?