There are two ways (apart from BULK insert) which creates minimal transaction logs
1) SELECT INTO
2) using TABLOCK hint
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter