September 22, 2007 at 8:48 am
Comments posted to this topic are about the item Display Row Count for all Tables
Mr or Mrs. 500
September 24, 2007 at 2:19 pm
cadebryant (9/22/2007)Comments posted to this topic are about the item Display Row Count for all Tables
You could also use the system stored procedure sp_spaceused 'YourTableName' . I actually saved this and other system stored procedures on my "Keyboard Shortcuts" for easy access.
[font="Verdana"]Sal Young[/font][font="Verdana"]MCITP Database Administrator[/font]
December 18, 2007 at 2:14 am
:unsure:This is not an efficient script, it doesn't include tables without clustered indexes(primary key).
December 18, 2007 at 9:01 pm
This script has a fault,that is,the results don't contain those tables which not exists any indexes.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply