• On the databases I have AutoClose off. It's one of those really bright ideas that no one wants.

    Autoshrink is off because I found it twice trying to shrink itself during a very heavy I/O time (which added to the length of time for the process).

    I just use DBCC SHRINKFILE(table, size).

    Patrick

    Quand on parle du loup, on en voit la queue