> Is it possible to query SQL Server to find out the size of a
> database? I'd like to be able to track its growth from a CF
> application without having to go to the Enterprise Manager to
> find out.
Each database in SQL Server has a sysfiles table, and if you sum the column
size, that will tell you how much space is allocated to your data and log
files.
To access the sysfiles, you may have to set up a new SQL Server account that
has access to objects owned by system. I've never attempted to do this, so
I don't know for sure if SQL Server allows these tables to be accessed by
the outside world (it's something of a security hole).
Dana Larose
ColdFusion Monkey
Canadian Web Design & Consulting Inc.
A: 701-281 McDermot Avenue (McDermot & King)
P: 204.946.5155
C: 204.228.0477
F: 204.946.5156
E: [EMAIL PROTECTED]
W: http://www.cdnwebdesign.com
The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone else
is unauthorized. If you are not the intended recipient, any disclosure,
copying, distribution or any action taken or omitted to be taken in reliance
on it, is prohibited and may be unlawful. When addressed to our clients any
opinions or advice contained in this email are subject to the terms and
conditions expressed in the applicable Canadian Web Design & Consulting Inc.
client engagement contract.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
