Good afternoon one and all,

I have the following problem :

I have a table which currently has 40+ mill records. Some of the fields are of type nvarchar and these need changing to varchar. I have attempted to change these fields to varchar but the process proceeds to increase the transaction log (to 6 Gigs!) until there is no space left on the server (causing a multitude of other problems with existing programs on the server). Once this happens I have no choice but to kill the change.

Does any1 know how I can make these changes without SQL writing to the transaction log?

Any and all help appreciated,

Thanks

Gurmi