Thank this author by sharing:
This script searches all tables in a database and reports the defined rowlength and the longest actual row. Ifa table contains text or image columns it's possible that the actual used length is greater than the defined one.
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.