Leif,

I agree that another schema of increment growing of databases could be better.

 My concern was that after the reboot the increment for autogrow automatically re-set to 1 Mb (only on...

If you do not have dependacies you can :

1. extract data

2. trancate table

3. load data back

Leonid

The autogrow for the 'model' is 10% and is not changing after the re-boot.

The is a tempdb.sysfiles table and comparing the values in the status column for the 'normal' and...

Hi,

I've contacted Microsoft and they comfirm that NT_Authority\System as well as DOMAIN\COMPUTERACCOUNT must be the sys admins on SQL box and :

" ...Microsoft has...

Thank you,

It sounds right.