Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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)

List DB tables and their maximum row size (bytes)

By Dfalir,

Many users during the process of insert or update get the following warning issued by SQL Server

Warning: The table 'TABLE NAME' has been created but its maximum row size (XXXX) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.

This is happening because the row-length in bytes, exceeds the maximum length SQL server allows. The script, does not prevent this from happening. Instead, it lists to the user all of its database tables, along with their length in Bytes. All Tables that are above 8060 should have their column datatype lengths changed to prevent any loss of Data during Insert or Update of Data.


Total article views: 267 | Views in the last 30 days: 2
 
Related Articles
FORUM

maximum length of Dimension Attribute

maximum length of Dimension Attribute

FORUM

insert and update issue

insert and update not working

FORUM

Strategies for bypassing the 8,060 byte limit on Row Length

Are there practical ways to store data that exceeds the maximum row length

FORUM

Trigger defined for Insert, Update

Determine Update or Insert for Trigger defined for Insert, Update

Tags
miscellaneous    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

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.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones