<div>
just make sure that you add a column with a default value (for example null)<br />
otherwise, SQL Server might have to update that value to all existing records and that might cause you the log work
</div>


just make sure that you add a column with a default value (for example null)
otherwise, SQL Server might have to update that value to all existing records and that might cause you the log work

<div>
I am doing that. I am trying to add a new column named Age - varchar(10) - default value null
</div>


I am doing that. I am trying to add a new column named Age - varchar(10) - default value null

<div>
By GUI, I tried Alter column and it worked just fine. Thanks so much.
</div>


By GUI, I tried Alter column and it worked just fine. Thanks so much.

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have a database hosted on Network Solutions. I am trying to add new columns to a really large table, but I am getting an error stating &quot;unable to modify table - transaction log full....&quot;<br />
<br />
I ran &quot;BACKUP LOG mydb WITH TRUNCATE ONLY&quot; on the database using ms sql server 2005 express, but no luck....<br />
<br />
Is there something I can do or try on my end using ms sql server express to fix this error, or does Network Solutions have to fix this on the database settings end?<br />
<br />
Thanks in advance
</div>
</div>


Hi Experts,

I have a database hosted on Network Solutions. I am trying to add new columns to a really large table, but I am getting an error stating "unable to modify table - transaction log full...."

I ran "BACKUP LOG mydb WITH TRUNCATE ONLY" on the database using ms sql server 2005 express, but no luck....

Is there something I can do or try on my end using ms sql server express to fix this error, or does Network Solutions have to fix this on the database settings end?

Thanks in advance

SQL Server 2005 - Unable to modify table structure - Transaction log full???

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.