All,

Is it possible to add a column to an existing table via binary bulk loading? We have a table with ~1 billion rows and we would like to add columns to the table, but would prefer bulk loads for speed. Also, does anyone have a snippet of code to create the binary file format that bulk loading expects. I’ve tried a couple versions (simple int  and double), but the server wouldn’t recognize the files.

Thanks,

Dave