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
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment