Hi, everyone
Could you please tell me how to get the size of a table(including data) in
SQL Sever 2000?
have a look in BOL for sp_spaceused, eg
USE pubs
EXEC sp_spaceused 'titles'
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||but how can reclaim the unused table size ?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment