Try this This one checks the space used by a table; sp_spaceused @objname = 'NameofTable'
This one will give you the space used by the whole DB; sp_spaceused @updateusage = 'TRUE' Use these in Query analyzer or in your CF templates. Bruce ----- Original Message ----- From: "Kay Smoljak" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Thursday, February 14, 2002 1:17 AM Subject: MSSQL Table size? > Hi all, > > Is there a way to find out the size in MB of a table in an SQL Server > database? I have both a version 7 box and a 2000 box that I'd like to do > this with. > > Thanks, > Kay. > ______________________________________________________ > Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd > > Level 9/105 St George's Terrace - Perth - Western Australia > Ph: (08) 9226 1366 Fax: (08) 9226 1375 www.perthweb.com.au > > http://developer.perthweb.com.au - Tools for Developers > cfx_pwcamtech | cfx_pwimageproc | cfx_pwcardcyrpt > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
