Row size and Physical table | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Row size and Physical table

Do you receive any message that row size is ended and no more records entered?
When you update any row in enterprise manager in physical table, is there any option to roll back as auto commit is on in SQL server or you physically select the row and update information?
By default AUTOGROW will be enabled on the data &log files of your database, unless there is no space on the disk where this data file is located you. It is not a best practice to update a table using Enterprise Manager, you must control such update using TSQL queries with BEGIN..END transaction in order to rollback or commit in case of such checkups. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
If that is related to the UPDATE of rows in a table that exceed the max row size of 8060 bytes per row, you might need to reconsider your table design. —
Frank Kalis
Moderator
Microsoft SQL Server MVP
Webmaster:http://www.insidesql.de
]]>