-
Where is the "retricted file growth" value from system tables?
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.
-
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
-
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.
-
Thanks for both of you. Your solutions work!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|