Excellent! Thanks.
> -----Original Message-----
> From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 14 February 2002 7:38 PM
> To: SQL
> Subject: Re: MSSQL Table size?
>
>
> 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
> >
> >
> >
> >
> >
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
