I would think that SPs would be superior to RVs during migration due to speed difference. I haven't worked with any hugh datasets on SQL Server yet, but there has been a significant amount of talk here, with folks complaining of slowness during migrations.
PF
>I'll tell you where I like RVs ----> quick and dirty looks at server data or one-time migrations.
>
>
>>
>>If you maintain your RV's in code, why not use SPT, and avoid the problems with RV's????? Seems to me that without the VD, any advantage of RV's that may exist, is gone...
(On an infant's shirt): Already smarter than Bush