Viewing 2 posts - 1 through 2 (of 2 total)
Nice article, but in MS SQL Server is preferred to avoid courses. With the System Dynamic Management Views this is now a hard to write select statement that return size...
August 9, 2018 at 1:48 pm
#2001136
Hello
This is the cool example, but you do not need to write own procedure to determine the tables row count. Just try this:
exec SP_MSFOREACHTABLE @command1=N' exec SP_SPACEUSED ''?'' '
Regards
Yankov...
March 31, 2010 at 12:42 am
#1142860