This might be a good idea. Since you have so much data why don't you break it apart. In a Stored Procedure , Create 3 temp table Create table #TempTable1 (col1 int,col 2 int,col3 money.....) then insert the data like 50000 in one temp table 1, another 50000 in temptable2 and so on. insert into #TempTable1 (col1, col2, col3,....) values (select col1, col2, col3, ...from OriginalTable where .....(i think here you might wanna counter < 50000) so now you break the data into 3 part. now all you need to do is selete from those temp tables and create a file. for select, use Select * from #TempTable1 this might work. let me know if there is any issue.. KEEP DIGGIN......Keep Programmin......