Please start any new threads on our new 
    site at https://forums.sqlteam.com.  We've got lots of great SQL Server
    experts to answer whatever question you can come up with.
    
        | 
                
                    | 
                            
                                | Author | Topic |  
                                    | piotr_pikielnyStarting Member
 
 
                                        1 Post | 
                                            
                                            |  Posted - 2007-10-04 : 08:27:54 
 |  
                                            | I have the following problem. I need to insert 100.000 records (50Kb each) in one operation from a VB program into a SQL Server 2005 database. All of these records will be ready for inserting at the same time.How to make this insert as one big transaction instead of 100.000 small ones? |  |  
                                    | harsh_athalyeMaster Smack Fu Yak Hacker
 
 
                                    5581 Posts |  |  
                                    | grazChief SQLTeam Crack Dealer
 
 
                                    4149 Posts |  |  
                                |  |  |  |