Re: table size
From: Andrew J. Kelly (akelly@targitinteractive.com)
Date: 07/30/02
- Next message: Mary Chipman: "Re: SQL Connection string."
- Previous message: Andrew J. Kelly: "Re: Users on a DB are dropped without any intervention"
- In reply to: kaushik: "table size"
- Next in thread: BP Margolin: "Re: table size"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Andrew J. Kelly" <akelly@targitinteractive.com> Date: Tue, 30 Jul 2002 10:21:01 -0400
Don't know if its the Best way but one way is to use sp_spaceused
'TableName'. You may want to use the Updateusage option as well.
-- Andrew J. Kelly SQL MVP Targitinteractive, Inc. "kaushik" <kaushikmondal@excite.com> wrote in message news:2f4a01c237d2$451e51f0$3bef2ecf@TKMSFTNGXA10... > what is the best way of calculating the size of a table
- Next message: Mary Chipman: "Re: SQL Connection string."
- Previous message: Andrew J. Kelly: "Re: Users on a DB are dropped without any intervention"
- In reply to: kaushik: "table size"
- Next in thread: BP Margolin: "Re: table size"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
