The following SQL query returns the size of each table in the specified database.
USE
sp_MSforeachtable @command1=’EXEC sp_spaceused ”?”’,@whereand=’or OBJECTPROPERTY(o.id, N”IsSystemTable”) = 1′
Site Stats
follow:- RSS
The following SQL query returns the size of each table in the specified database.
USE
sp_MSforeachtable @command1=’EXEC sp_spaceused ”?”’,@whereand=’or OBJECTPROPERTY(o.id, N”IsSystemTable”) = 1′
follow: RSS