Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Jim Youmans,
Sometimes you need to list all the tables that are being published on a server. Once you have the list it is really nice to have the table sizes too (row count and total MBs for table). This script will do the following.
Please Note: This assumes no filters on the publication. If you have a very large table and are only replicating 5 of 60 columns, if will not see that and will give you the numbers for the entire table.