List DB tables and their maximum row size (bytes)

Many users during the process of insert or update get the following warning issued by SQL ServerWarning: 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 […]

5 (1)

2005-09-02 (first published: )

287 reads

Blogs

Daily Coping 5 Aug 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Interview Tip: Know your resume

By

Seriously. Make a point of reading your resume before submitting it, and again before...

SQL Server on Kubernetes Book Published!

By

I’m super proud to announce that Ben E. Weissman and I have published SQL...

Read the latest Blogs

Forums

cheap hennessy

By bion

Are you looking for quality Wine, Champagn,Hennessy or Heineken for your birth day party,wedding,events...

is Forced Parameterization usually more beneficial than less?

By VoldemarG

On a hybrid server, with ~70% OLTP vs 30% (somewhat heavy) DW workloads, with...

Celebrating Lives

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Celebrating Lives

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers