One way: execute the stored procedure 'master.sp_databases'--returns
database_size as total of both database and transaction log in KB for each
database--on SQL 2000.
Glenn
-----Original Message-----
From: Chris Sinkwitz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 11:36 AM
To: CF-Talk
Subject: RE: MS SQL 7/2k File Size
There will be a file most likely in your D:\MSSQL7\DATA folder that will be
a .mdf file. That is your database, look at the properties of that. If you
don't know what the file would be named or can't figure it out you can look
in Enterprise Manager right click on your database go to properties and look
at the location of your database and it will tell you the name and the place
it is stored. Hope this helps.
Chris Sinkwitz
-----Original Message-----
From: BEN MORRIS [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 7:35 AM
To: CF-Talk
Subject: MS SQL 7/2k File Size
List,
Does anyone know of a way in SQL (as opposed to enterprise manager) to get
the file size of a MS SQL database?
Thanks in advance,
Ben Morris
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
