Timeline for Changing a column's data type fills the transaction log
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 26, 2021 at 0:09 | comment | added | Rodrigo | Hi @Remus, just chaning from resizing from high to a small value, this requires SQL server rewrite something on log? For example, changing from varchar(30) to varchar(20), I guess SQL server just need scan to confirm that dont exists rows with column size more than 20 chars... If it finds, just throw errros... What the reason SQL would need write this change to log, in addition metadata changes? | |
| Jan 3, 2012 at 13:07 | history | migrated | from stackoverflow.com (revisions) | ||
| Jan 3, 2012 at 4:40 | history | answered | Remus Rusanu | CC BY-SA 3.0 |