Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Table - Physical File Table size?
Message
From
28/07/2003 05:13:20
Rene Lovino
Bigfoot Global Solutions, Inc
Cebu, Philippines
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00813985
Message ID:
00813998
Views:
6
Hi Russell,

You can use the sp_spaceused system stored procedure.
You can call it using sqlexec() function.
example:
=sqlexec(ConnectionHandle, "EXEC sp_spaceused 'tablename'", "CursorName")

see SQL Books Online for more detail about "sp_spaceused"

Rene




How can I determine the physical Table size (Bytes) occupied by a particular SQL Server Table?
Previous
Reply
Map
View

Click here to load this message in the networking platform