If you have enterprise manager for 7.0 open click on the database name that you want to view. In the right pane there are three tabs you can click on, General, Tables & Indexes, Space Allocated. You will find what you are looking for under the Tables & Indexes tab.
I am not sure what 2000 looks like. Matthew >From: "Bruce Sorge" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: SQL <[EMAIL PROTECTED]> >Subject: Re: MSSQL Table size? >Date: Thu, 14 Feb 2002 05:38:11 -0600 > >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 > > > > > > > > > > > ______________________________________________________________________ Macromedia ColdFusion 5 Training from the Source Step by Step ColdFusion http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
