Where is the "retricted file growth" value from system tables?

[happy888]

Does anyone know where I can find the "retricted file growth" value (for the data file) from the system tables? We setup a limit for the file growth for all the databases. We would like to write a script to alert us when the database size approachs the limit.

[MAK]

use databasename
go
select name,size/128.00 as SizeinMB,maxsize/128.00 as MaxSizeinMB from sysfiles
where maxsize not in (0,-1)
go


or

use master
go
select name,maxsize/128.00 as SizeinMB from master..sysaltfiles where maxsize not in (-1,0)
go

[MAK]

use sysfiles



From BOL....
sysaltfiles
Under special circumstances, contains rows corresponding to the files in a database. This table is stored in the master database.

[happy888]

Thanks for both of you. Your solutions work!