Monday, March 12, 2012

How can I know a user table's size?

I want to check a user table's size, Maybe 20M or more?
what can i do ,pls kindly help me
Regards
Grantexec sp_spaceused ThisTable, @.updateusage = TRUE
Roy Harvey
Beacon Falls, CT
On Wed, 26 Apr 2006 19:41:02 -0700, Grant
<Grant@.discussions.microsoft.com> wrote:

>I want to check a user table's size, Maybe 20M or more?
>what can i do ,pls kindly help me
>
>Regards
>Grant|||try this (untested)
EXEC sp_spaceused [table1]
"Grant" wrote:

> I want to check a user table's size, Maybe 20M or more?
> what can i do ,pls kindly help me
>
> Regards
> Grant
>

No comments:

Post a Comment