Receiving error processing a dimension based upon a table with ~8 million rows. Running SQL Server 2000 with SP1 applied. Processing the dimension takes up to an hour before erroring. Have plenty of disk and memory, not sure where to start looking. Any ideas would be greatly appreciated!