• Thanks for your replies.

     

    Bill,

     

    Should i use DBCC SHRINKFILE with the TRUNCATEONLY argument to release the unused space ?

     

     

    Mike,

     

    About that interesting command (sp_MSforeachtable), it's not working, am i missing something ? :

     

    Server: Msg 201, Level 16, State 4, Procedure sp_MSforeachtable, Line 0

    Procedure 'sp_MSforeachtable' expects parameter '@command1', which was not supplied.