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: )

285 reads

Blogs

New Power BI Report Design Pre-Con in 2020

By

I’m excited to announce that I will be offering a full-day pre-con about Power...

Resetting an Azure SQL Database Admin Password

By

This is likely something that most people know, but it was a bit confusing...

Read the latest Blogs

Forums

Deadlocks

By Admingod

Looking for some ideas so to prevent deadlocks. I have captured queries that constantly...

Lengthy query response times

By bob-596435

I'm dealing with a strange problem that started today. A simple query that will...

Query runs for days when upgrading to 2017

By askcoffman

We upgraded our datawarehouse sql server from 110 to 140, RTM - CU17. In...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers