Thank this author by sharing:
By Steen Molberg,
This script uses a cursor to loop through all tables and get the count and table sizes using sp_spac...
I want to exe sp_spaceused for every 5 hrs and store the result in table.
I created sql job...
A better way to use sp_spaceused, returning values on one row for the database instead of two.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.