Automatically Grow File

[DrSql]

Automatically Grow File
I am trying to find out in which table 'Automatically Grow File' dteails get stored. I have server that has around 50 dbs, i want to verfiy all the Db file grwoth is set to "By Percent" rather than "In Megebytes" small growth (below 100 mb). I have looked into SYSFILES and SYSFILES1 neither have thos details.
Thanks

Dr. Sql
goEdeveloper@yahoo.com
Good Luck.

 

[jester777]

It is in the sysfiles of each database. See this description of sysfiles from BOL.

growth int Growth size of the database. A value of 0 indicates no growth. Can be either the number of pages or the percentage of file size, depending on value of status. If status contains 0x100000, then growth is the percentage of file size; otherwise, it is the number of pages.



status int Status bits for the growth value in either megabytes (MB) or kilobytes (K).
0x1 = Default device.
0x2 = Disk file.
0x40 = Log device.
0x80 = File has been written to since last backup.
0x4000 = Device created implicitly by the
CREATE DATABASE statement.
0x8000 = Device created during database
creation.
0x100000 = Growth is in percentage, not pages.