September 22, 2007 at 8:48 am
Comments posted to this topic are about the item Display Row Count for all Tables
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy