>I have a project where I need to load in a few million
>text files to one of two tables. I am using a primary
>key that is assigned via a stored procedure routine
>similar to the one used in TasTrade (newid()).
>
>The first file contains 1.2 million records and after
>22 hours it is only about 1/2 complete.
>
>Would it have been better to not set NEWID() as
>the default value and used a different technique?

if this is a one-time deal, i'd import to a table wo/ the RI and functions. if it isn't, i'd be patient.

btw, i'm not familiar with the newid stored procedure. is this a default value for a field in a new record?