Executing the script will create the stored procedure st_UsedSpace in the master database.
Parameters are follows:
@TableName, name of the particular table. If it is '' procdure will calculate used space for all the tables in the database;
@SortOrderFieldNumber, determinate the field from result set that will be sorted
@Desc, determinate the sort order of the particular field. 0 for ascending and 1 for descending.