These scripts can be run straight on SSMS.
Check Table Sizes
* The <DB_NAME> should be repalced with the actual database name of the database for which table sizes are being checked.
* The script returns table names and sizes for the database specified
Check Database Sizes
* The script returns the sizes of all data and log files for each database
* The sizes are represented in MB rather than 8KB pages