>Whats the best method to update sqlserver when data is large?
>Scenario:
>
>i am trying to insert 47,000 records to a table in SQL Server with 95 fields, but it took me 1.5 hours to complete the proccess. I am using SPT to update the table.
>
>thanks in advance
If datatypes are OK (no memo,general) then I think copying to a text file and using 'bulk insert' would be the fastest.
PS : Check Thread #
886406 Cetin