Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: 283 | 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