I have a MS SQL Server 2008 R2 DB server currently in use with a production app.
A new enhancement to the app now requires a
varchar(100) column in a table to be increased in length.
Can the length of this existing column in the prod DB be increased without affecting the current data?
Does this change have to be completed during off-hours to avoid disruption of service?