There is no easy way of doing that. You need to use cursor to walk through
those 100 dbs and in each db, run the following commands:
alter database dbname modify file ( name = dbname_data, size = 100MB )
alter database dbname modify file ( name = dbname_data, maxsize = 500MB )
alter database dbname modify file ( name = dbname_data, filegrowth = 10MB )
The above three line can not be done in one statement because only one
property can be changed at one time.
Richard
Quote:> Hi,
> I have a sql7 server developers version.
> I have to open more then 100 databases!
> I what to change the default settings so I won't have to change all the
100
> databases,
> I need to change the file growth, Maximum file size, space allocated.
> Does some body knows where or how can it be change?
> 10x allot
> Nir