Thank you qovinn

Thanks folks, the ISO standard worked

Thanks for replying but, that's what I have done.

Thanks to all,

I am also thinking of doing away with the autonumber (Due to problems with replication)and doing the it manually in the SP. Will it be safe in the...

Thanks guys,

I know tables are basically sets so the ordering is irrelevant. But I am doing some dev so I check if the insertions were correct. I know I can...

Thank you all

Thanks AJ,

But this is exactly what happened. The view returns about 8000000 records and while importing with the options described in my post the view got converted to table.

I don't...

Thanks everyone. Frank, You mean to say there are some system procedures which begin with 'r_'. Will Dinesh's solution work? I mean shouldn't it be 'dt_%' not 'dt%' or...

Thanks Frank, but why "routine_name not like 'r_%'" is needed? Why is the first where clause not enough?

Thanks Brian.

Thanks

I agree with Alex Oganezov. The answer is vague.